/// <summary>
/// 添加省份
/// </summary>
/// <param name="province"></param>
/// <returns></returns>
public int AddProvince(TProvince province)
{
int stat = 0;
#region 变量
string code = province.code;
string name = province.name;
#endregion
NameValueCollection nvc = new NameValueCollection();
nvc.Add("@code", code);
nvc.Add("@name", name);
dh.Open();
dh.ExecuteNonQuery(CommandType.Text, "Insert into province(code,name)values(@code,@name)", nvc);
dh.Close();
return(stat);
}
/// <summary>
/// 更新 省
/// </summary>
/// <param name="province"></param>
/// <param name="id"></param>
/// <returns></returns>
public int UpdateProvince(TProvince province, int id)
{
int stat = 0;
#region 变量
string code = province.code;
string name = province.name;
#endregion
NameValueCollection nvc = new NameValueCollection();
nvc.Add("@code", code);
nvc.Add("@name", name);
nvc.Add("@id", id.ToString());
dh.Open();
dh.ExecuteNonQuery(CommandType.Text, "Update province set code=@code,name=@name where id=@id", nvc);
dh.Close();
return(stat);
}
public TProvince GetProvinceByCode(string Code)
{
TProvince tp = new TProvince();
NameValueCollection nvc = new NameValueCollection();
nvc.Add("@code", Code);
dh.Open();
using (DbDataReader dr = dh.ExecuteReader(CommandType.Text, "Select ID,code,name from province where code=@code", nvc))
{
if (dr.HasRows)
{
dr.Read();
int provinceid = 0;
Int32.TryParse(dr[0].ToString().Trim(), out provinceid);
tp.ID = provinceid;
tp.code = dr[1].ToString().Trim();
tp.name = dr[2].ToString();
}
}
dh.Close();
return(tp);
}
