using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Xml;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Globalization;
using System.IO;
using System.Drawing.Imaging;
using System.Windows.Forms.PropertyGridInternal;
using Microsoft.Win32;
using System.Media;
using System.Globalization;
using FarsiMsgBox;
using Persia;
using PersianTools;
namespace TProperty
{
class LID
{
public string str;
public string namestate, IDState;
public LID()
{
SqlDataAdapter dataadapter = new SqlDataAdapter();
SqlDataAdapter dataadapter2 = new SqlDataAdapter();
DataSet objset2 = new DataSet();
DataSet objset = new DataSet();
SqlDataAdapter objadapadap = new SqlDataAdapter();
DataTable objtabe12 = new DataTable();
SqlCommand command = new SqlCommand();
SqlCommand cmd2 = new SqlCommand();
SqlDataAdapter getDayAdp = new SqlDataAdapter();
DataSet getDayDs = new DataSet();
DataSet ds = new DataSet();
clsProgress cPro = new clsProgress();
connectdb sql_connnn_string_db = new connectdb();
hight_dgv h = new hight_dgv();
SqlConnection scon2 = new SqlConnection();
}
private void IDes ()
{
try
{
string strostan;
connectdb strcndb = new connectdb();
strcndb.strcon1 = str;
SqlConnection scon = new SqlConnection(strcndb.strcon1);
scon.Open();
string comand_search_id_state;
comand_search_id_state = "select * from State where subject=N'" + namestate + "'";
SqlCommand scom = new SqlCommand(comand_search_id_state, scon);
SqlDataReader dr;
dr = scom.ExecuteReader();
if(dr.Read())
{
return IDState = dr["ID"].ToString();
}
scon.Close();
}
catch { }
}
}
}