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;
}
