public static DictCity[] GetDistircts(string CityID, out int Result, out string ErrMsg) { DictCity[] dictCitys = null; SqlConnection myCon = null; SqlCommand cmd = new SqlCommand(); DataSet ds = null; try { myCon = new SqlConnection(DBUtility.BestToneCenterConStr); cmd.Connection = myCon; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "up_Customer_V3_Interface_DistirctInfoQuery"; SqlParameter parCityID = new SqlParameter("@CityID", SqlDbType.VarChar, 32); parCityID.Value = CityID; cmd.Parameters.Add(parCityID); SqlParameter parResult = new SqlParameter("@Result", SqlDbType.Int, 4); parResult.Direction = ParameterDirection.Output; cmd.Parameters.Add(parResult); SqlParameter parErrMsg = new SqlParameter("@ErrMsg", SqlDbType.VarChar, 256); parErrMsg.Direction = ParameterDirection.Output; cmd.Parameters.Add(parErrMsg); ds = DBUtility.FillData(cmd, DBUtility.BestToneCenterConStr); if (ds != null) { if (ds.Tables.Count != 0) { if (ds.Tables[0].Rows.Count != 0) { int RowCount = ds.Tables[0].Rows.Count; dictCitys = new DictCity[RowCount]; for (int i = 0; i < RowCount; i++) { DictCity dc = new DictCity(); dc.ID = ds.Tables[0].Rows[i]["id"].ToString().Trim(); dc.Name = ds.Tables[0].Rows[i]["name"].ToString().Trim(); dc.Code = ds.Tables[0].Rows[i]["code"].ToString().Trim(); dc.Grade = int.Parse(ds.Tables[0].Rows[i]["grade"].ToString().Trim()); dictCitys[i] = dc; } } } } Result = int.Parse(parResult.Value.ToString().Trim()); ErrMsg = parErrMsg.Value.ToString().Trim(); } catch (Exception e) { Result = ErrorDefinition.IError_Result_System_UnknowError_Code; ErrMsg = "获取区信息异常," + e.Message; } return(dictCitys); }
public static DictCity[] GetProvinces(out int Result, out string ErrMsg) { DictCity[] dictCitys = null; SqlConnection myCon = null; SqlCommand cmd = new SqlCommand(); DataSet ds = null; try { myCon = new SqlConnection(DBUtility.BestToneCenterConStr); cmd.Connection = myCon; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "up_Customer_V3_Interface_ProvinceInfoQuery"; SqlParameter parResult = new SqlParameter("@Result", SqlDbType.Int, 4); parResult.Direction = ParameterDirection.Output; cmd.Parameters.Add(parResult); SqlParameter parErrMsg = new SqlParameter("@ErrMsg", SqlDbType.VarChar, 256); parErrMsg.Direction = ParameterDirection.Output; cmd.Parameters.Add(parErrMsg); ds = DBUtility.FillData(cmd, DBUtility.BestToneCenterConStr); if (ds != null) { if (ds.Tables.Count != 0) { if (ds.Tables[0].Rows.Count != 0) { int RowCount = ds.Tables[0].Rows.Count; dictCitys = new DictCity[RowCount]; for (int i = 0; i < RowCount; i++) { DictCity dc = new DictCity(); dc.ID = ds.Tables[0].Rows[i]["id"].ToString().Trim(); dc.Name = ds.Tables[0].Rows[i]["name"].ToString().Trim(); dc.Code = ds.Tables[0].Rows[i]["code"].ToString().Trim(); dc.Grade = int.Parse(ds.Tables[0].Rows[i]["grade"].ToString().Trim()); dictCitys[i] = dc; } } } } Result = int.Parse(parResult.Value.ToString().Trim()); ErrMsg = parErrMsg.Value.ToString().Trim(); } catch (Exception e) { Result = ErrorDefinition.IError_Result_System_UnknowError_Code; ErrMsg = "��ȡʡ��Ϣ�쳣��" + e.Message; } return dictCitys; }