protected void btnSave_Click(object sender, EventArgs e)
{
this.btnSave.Enabled = false;
this.btnCancle.Enabled = false;
if (string.IsNullOrEmpty(this.txtRegionName.Text.Trim()))
{
this.btnSave.Enabled = true;
this.btnCancle.Enabled = true;
MessageBox.ShowFailTip(this, "地区名称不能为空！");
}
else
{
Maticsoft.Model.Ms.Regions model = new Maticsoft.Model.Ms.Regions {
AreaId = null
};
if (((this.Regions1.Province_iID == 0) && (this.Regions1.City_iID == 0)) && (this.Regions1.Area_iID == 0))
{
model.ParentId = null;
model.Path = "0,";
model.Depth = 1;
}
if (((this.Regions1.Province_iID != 0) && (this.Regions1.City_iID == 0)) && (this.Regions1.Area_iID == 0))
{
model.ParentId = new int?(this.Regions1.Province_iID);
model.Path = "0," + this.Regions1.Province_iID;
model.Depth = 2;
}
if (((this.Regions1.Province_iID != 0) && (this.Regions1.City_iID != 0)) && (this.Regions1.Area_iID == 0))
{
model.ParentId = new int?(this.Regions1.City_iID);
model.Path = string.Concat(new object[] { "0,", this.Regions1.Province_iID, ",", this.Regions1.City_iID });
model.Depth = 3;
}
if (((this.Regions1.Province_iID != 0) && (this.Regions1.City_iID != 0)) && (this.Regions1.Area_iID != 0))
{
MessageBox.ShowSuccessTip(this, "暂时支持添加到三级区域");
}
else
{
Maticsoft.BLL.Ms.Regions regions2 = new Maticsoft.BLL.Ms.Regions();
model.RegionId = regions2.GetMaxId();
model.RegionName = this.txtRegionName.Text;
model.Spell = null;
model.SpellShort = this.txtSpellShort.Text;
model.DisplaySequence = Globals.SafeInt(this.txtDisplaySequence.Text, 1);
if (0 < regions2.Add(model))
{
this.btnSave.Enabled = false;
this.btnCancle.Enabled = false;
MessageBox.ShowSuccessTip(this, "保存成功！", "add.aspx");
}
else
{
this.btnSave.Enabled = true;
this.btnCancle.Enabled = true;
MessageBox.ShowSuccessTip(this, "添加失败！");
}
}
}
}
public Maticsoft.Model.Ms.Regions DataRowToModel(DataRow row)
{
Maticsoft.Model.Ms.Regions regions = new Maticsoft.Model.Ms.Regions();
if (row != null)
{
if ((row["AreaId"] != null) && (row["AreaId"].ToString() != ""))
{
regions.AreaId = new int?(int.Parse(row["AreaId"].ToString()));
}
if ((row["RegionId"] != null) && (row["RegionId"].ToString() != ""))
{
regions.RegionId = int.Parse(row["RegionId"].ToString());
}
if ((row["ParentId"] != null) && (row["ParentId"].ToString() != ""))
{
regions.ParentId = new int?(int.Parse(row["ParentId"].ToString()));
}
if (row["RegionName"] != null)
{
regions.RegionName = row["RegionName"].ToString();
}
if (row["Spell"] != null)
{
regions.Spell = row["Spell"].ToString();
}
if (row["SpellShort"] != null)
{
regions.SpellShort = row["SpellShort"].ToString();
}
if ((row["DisplaySequence"] != null) && (row["DisplaySequence"].ToString() != ""))
{
regions.DisplaySequence = int.Parse(row["DisplaySequence"].ToString());
}
if (row["Path"] != null)
{
regions.Path = row["Path"].ToString();
}
if ((row["Depth"] != null) && (row["Depth"].ToString() != ""))
{
regions.Depth = int.Parse(row["Depth"].ToString());
}
}
return regions;
}
public Maticsoft.Model.Ms.Regions GetModel(int RegionId)
{
StringBuilder builder = new StringBuilder();
builder.Append("select top 1 * from MS_Regions ");
builder.Append(" where RegionId=@RegionId");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@RegionId", SqlDbType.Int, 4) };
cmdParms[0].Value = RegionId;
Maticsoft.Model.Ms.Regions regions = new Maticsoft.Model.Ms.Regions();
DataSet set = DbHelperSQL.Query(builder.ToString(), cmdParms);
if (set.Tables[0].Rows.Count <= 0)
{
return null;
}
if ((set.Tables[0].Rows[0]["AreaId"] != null) && (set.Tables[0].Rows[0]["AreaId"].ToString() != ""))
{
regions.AreaId = new int?(int.Parse(set.Tables[0].Rows[0]["AreaId"].ToString()));
}
if ((set.Tables[0].Rows[0]["RegionId"] != null) && (set.Tables[0].Rows[0]["RegionId"].ToString() != ""))
{
regions.RegionId = int.Parse(set.Tables[0].Rows[0]["RegionId"].ToString());
}
if ((set.Tables[0].Rows[0]["ParentId"] != null) && (set.Tables[0].Rows[0]["ParentId"].ToString() != ""))
{
regions.ParentId = new int?(int.Parse(set.Tables[0].Rows[0]["ParentId"].ToString()));
}
if ((set.Tables[0].Rows[0]["RegionName"] != null) && (set.Tables[0].Rows[0]["RegionName"].ToString() != ""))
{
regions.RegionName = set.Tables[0].Rows[0]["RegionName"].ToString();
}
if ((set.Tables[0].Rows[0]["Spell"] != null) && (set.Tables[0].Rows[0]["Spell"].ToString() != ""))
{
regions.Spell = set.Tables[0].Rows[0]["Spell"].ToString();
}
if ((set.Tables[0].Rows[0]["SpellShort"] != null) && (set.Tables[0].Rows[0]["SpellShort"].ToString() != ""))
{
regions.SpellShort = set.Tables[0].Rows[0]["SpellShort"].ToString();
}
if ((set.Tables[0].Rows[0]["DisplaySequence"] != null) && (set.Tables[0].Rows[0]["DisplaySequence"].ToString() != ""))
{
regions.DisplaySequence = int.Parse(set.Tables[0].Rows[0]["DisplaySequence"].ToString());
}
if ((set.Tables[0].Rows[0]["Path"] != null) && (set.Tables[0].Rows[0]["Path"].ToString() != ""))
{
regions.Path = set.Tables[0].Rows[0]["Path"].ToString();
}
if ((set.Tables[0].Rows[0]["Depth"] != null) && (set.Tables[0].Rows[0]["Depth"].ToString() != ""))
{
regions.Depth = int.Parse(set.Tables[0].Rows[0]["Depth"].ToString());
}
return regions;
}
