private void Save()
{
ShowShop.BLL.SystemInfo.Provinces bll = new ShowShop.BLL.SystemInfo.Provinces();
Model.SystemInfo.Provinces model = new ShowShop.Model.SystemInfo.Provinces();
try
{
model.AddDate = System.DateTime.Now;
model.Child = 0;
model.CityEnglishName = this.txtCityEnglishName.Text;
model.CityName = this.txtCityName.Text;
model.Depth = ChangeHope.Common.StringHelper.StringToInt(this.txtDepth.Value);
model.Id = ChangeHope.Common.StringHelper.StringToInt(this.txtId.Value);
model.IsUse = ChangeHope.Common.StringHelper.StringToInt(this.ckbIsUse.SelectedValue);
model.ParentId = ChangeHope.Common.StringHelper.StringToInt(this.ddlParentId.SelectedValue);
model.OrderID = bll.GetChildCount(model.ParentId.ToString());
model.ParentPath = this.txtParentPath.Value;
if (model.Id > 0)
{
model.Child = bll.GetChildCount(model.Id.ToString());
bll.Update(model);
}
else
{
this.txtId.Value = bll.Add(model).ToString();
}
model = null;
bll = null;
this.ltlMsg.Text = "保存成功！";
this.pnlMsg.CssClass = "actionOk";
}
catch {
this.ltlMsg.Text = "保存失败！";
this.pnlMsg.CssClass = "actionErr";
}
finally {
this.pnlMsg.Visible = true;
model = null;
bll = null;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ShowShop.Model.SystemInfo.Provinces GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,CityName,CityEnglishName,ParentId,ParentPath,Depth,OrderID,Child,IsUse,AddDate from yxs_Provinces ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters = {
new SqlParameter("@Id", SqlDbType.Int,4)};
parameters[0].Value = Id;
ShowShop.Model.SystemInfo.Provinces model = new ShowShop.Model.SystemInfo.Provinces();
DataSet ds = ChangeHope.DataBase.SQLServerHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Id"].ToString() != "")
{
model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
model.CityName = ds.Tables[0].Rows[0]["CityName"].ToString();
model.CityEnglishName = ds.Tables[0].Rows[0]["CityEnglishName"].ToString();
if (ds.Tables[0].Rows[0]["ParentId"].ToString() != "")
{
model.ParentId = int.Parse(ds.Tables[0].Rows[0]["ParentId"].ToString());
}
model.ParentPath = ds.Tables[0].Rows[0]["ParentPath"].ToString();
if (ds.Tables[0].Rows[0]["Depth"].ToString() != "")
{
model.Depth = int.Parse(ds.Tables[0].Rows[0]["Depth"].ToString());
}
if (ds.Tables[0].Rows[0]["OrderID"].ToString() != "")
{
model.OrderID = int.Parse(ds.Tables[0].Rows[0]["OrderID"].ToString());
}
if (ds.Tables[0].Rows[0]["Child"].ToString() != "")
{
model.Child = int.Parse(ds.Tables[0].Rows[0]["Child"].ToString());
}
if (ds.Tables[0].Rows[0]["IsUse"].ToString() != "")
{
model.IsUse = int.Parse(ds.Tables[0].Rows[0]["IsUse"].ToString());
}
if (ds.Tables[0].Rows[0]["AddDate"].ToString() != "")
{
model.AddDate = DateTime.Parse(ds.Tables[0].Rows[0]["AddDate"].ToString());
}
return model;
}
else
{
return null;
}
}
