public static string GetCompanyNameAndIdForLeft(int C_Id) { //string Login = Mydb.ExecuteScalar("select LOGIN from ACCOUNT where LOG_IN_ID=@L", new SqlParameter[] { new SqlParameter("@L", Logid) }, CommandType.Text).ToString(); //if (string.IsNullOrEmpty(Login)) //{ string CompName = Mydb.ExecuteScalar("select COMPANY_NAME from CLIENT where CLIENT_ID=@C", new SqlParameter[] { new SqlParameter("@C", C_Id) }, CommandType.Text).ToString(); JavaScriptSerializer js = new JavaScriptSerializer(); List <ManCompany> mcs = new List <ManCompany>(); ManCompany mc = new ManCompany(); mc.NAME = CompName; return(js.Serialize(mc)); //return "{\"result\" : \"1\",\"IdComp\" :\"" + C_Id + "\",\"Compname\" :\"" + CompName + "\"}"; //} //else //{ // //DataTable dt = Mydb.ExecuteReadertoDataTable("select * from MAN_COMPANY where CLIENT_ID=@C", new SqlParameter[] { new SqlParameter("@C", C_Id) }, CommandType.Text); // return "{\"result\" : \"2\"}"; //} }
public static string GetUoById(int id) { DataTable dt = Mydb.ExecuteReadertoDataTable("sp_CounstructorAPI_GET_UO_by_ID", new SqlParameter[] { new SqlParameter("@MAN_COMPANY_ID", id) }, CommandType.StoredProcedure); List <ManCompany> mcs = new List <ManCompany>(); foreach (DataRow dr in dt.Rows) { ManCompany row = new ManCompany(); row.MAN_COMPANY_ID = Convert.ToInt32(dr["MAN_COMPANY_ID"]); row.INN = dr["INN"].ToString(); row.KPP = dr["KPP"].ToString(); row.OKPO = dr["OKPO"].ToString(); row.OGRN = dr["OGRN_OGRNIP"].ToString(); row.NAME = dr["NAME"].ToString(); row.LICENCE = dr["LICENCE"].ToString(); row.ADRESS_ID = dr["ADRESS_ID"].ToString(); row.ADRESS = dr["ADRESS"].ToString(); row.PHONE = dr["PHONE"].ToString(); row.EMAIL = dr["EMAIL"].ToString(); row.VK = dr["VK"].ToString(); row.OK = dr["OK"].ToString(); row.FB = dr["FB"].ToString(); row.TW = dr["TW"].ToString(); row.CLIENT_ID = Convert.ToInt32(dr["CLIENT_ID"]); row.RS = dr["RS"].ToString(); row.KS = dr["KS"].ToString(); row.BANK_BIK_ID = dr["BANK_BIK_ID"].ToString(); row.BANK_BIK = dr["BANK_BIK"].ToString(); row.BANK_NAME = dr["BANK_NAME"].ToString(); row.BANK_INN = dr["BANK_INN"].ToString(); row.BANK_KRS = dr["BANK_KRS"].ToString(); row.BANK_OGRN = dr["BANK_OGRN"].ToString(); row.SHOP_ID = dr["SHOP_ID"].ToString(); mcs.Add(row); } JavaScriptSerializer js = new JavaScriptSerializer(); return(js.Serialize(mcs)); }