public CorporationInfo GetModel(int id, bool fromCache = false)
{
CorporationInfo entity = null;
List <CorporationInfo> list = GetList(fromCache);
entity = list.Find(c => c.ID == id);
return(entity);
}
private void LoadData()
{
int id = GetInt("id");
if (id > 0)
{
CurrentCorporation = Corporations.Instance.GetModel(id, true);
txtName.Value = CurrentCorporation.Name;
}
}
protected void btnSubmit_Click(object sender,EventArgs e)
{
CorporationInfo entity = new CorporationInfo();
int id = GetInt("id");
if (id > 0) entity = Corporations.Instance.GetModel(id, true);
FillData(entity);
if (id > 0) Corporations.Instance.Update(entity);
else Corporations.Instance.Add(entity);
Corporations.Instance.ReloadCorporationListCache();
Response.Redirect("corporationmg.aspx");
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
CorporationInfo entity = new CorporationInfo();
if (Corporation != null) entity = Corporation;
else entity = Corporations.Instance.GetModel(DataConvert.SafeInt(ddlCorporation.SelectedValue), true);
FillData(entity);
Corporations.Instance.Update(entity);
Corporations.Instance.ReloadCorporationListCache();
if (Corporation != null) Corporation = entity;
WriteMessage("/message.aspx", "系统提示", "数据保存成功！", "", "/common/basesetting.aspx");
}
public static CorporationInfo PopulateCorporationInfo(IDataReader reader)
{
CorporationInfo entity = new CorporationInfo()
{
ID = (int)reader["ID"],
Name = reader["Name"] as string,
Sort = DataConvert.SafeInt(reader["Sort"])
};
SerializerData data = new SerializerData();
data.Keys = reader["PropertyNames"] as string;
data.Values = reader["PropertyValues"] as string;
entity.SetSerializerData(data);
return(entity);
}
public abstract void UpdateCorporation(CorporationInfo entity);
private void FillData(CorporationInfo entity)
{
entity.Trackmove = cbxTrackmove.Checked ? 1 : 0;
entity.Movecheck = cbxMovecheck.Checked ? 1 : 0;
entity.Forcedoffday = DataConvert.SafeInt(txtForcedoffday.Value);
List<string> offcustomerlevels = new List<string>();
foreach (ListItem item in cblOffcustomerlevel.Items)
{
if (item.Selected)
offcustomerlevels.Add(item.Value);
}
entity.Offcustomerlevel = string.Join(",", offcustomerlevels);
entity.Voluntaryoffday = DataConvert.SafeInt(txtVoluntaryoffday.Value);
entity.Offcheck = cbxOffcheck.Checked ? 1 : 0;
entity.Forcedoutday = DataConvert.SafeInt(txtForcedoutday.Value);
List<string> forcedoutdaylevels = new List<string>();
foreach (ListItem item in cblForcedoutdaylevel.Items)
{
if (item.Selected)
forcedoutdaylevels.Add(item.Value);
}
entity.Forcedoutdaylevel = string.Join(",", forcedoutdaylevels);
entity.Voluntaryoutday = DataConvert.SafeInt(txtVoluntaryoutday.Value);
entity.Outcheck = cbxOutcheck.Checked ? 1 : 0;
}
public abstract void AddCorporation(CorporationInfo entity);
public override void AddCorporation(CorporationInfo entity)
{
string sql = @"INSERT INTO ComOpp_Corporation(
[Name]
,[Sort]
,[PropertyNames]
,[PropertyValues]
)VALUES(
@Name
,(SELECT ISNULL(MAX([Sort]),0) + 1 FROM ComOpp_Corporation)
,@PropertyNames
,@PropertyValues
)";
SerializerData data = entity.GetSerializerData();
SqlParameter[] p =
{
new SqlParameter("@Name",entity.Name),
new SqlParameter("@PropertyNames", data.Keys),
new SqlParameter("@PropertyValues", data.Values)
};
SqlHelper.ExecuteNonQuery(_con, CommandType.Text, sql, p);
}
public override void UpdateCorporation(CorporationInfo entity)
{
SerializerData data = entity.GetSerializerData();
string sql = @"
UPDATE ComOpp_Corporation set
Name = @Name
,PropertyNames=@PropertyNames
,PropertyValues=@PropertyValues
WHERE ID=@ID";
SqlParameter[] parameters =
{
new SqlParameter("@ID", entity.ID),
new SqlParameter("@Name", entity.Name),
new SqlParameter("@PropertyNames", data.Keys),
new SqlParameter("@PropertyValues", data.Values)
};
SqlHelper.ExecuteNonQuery(_con, CommandType.Text, sql, parameters);
}
public abstract void AddCorporation(CorporationInfo entity);
public abstract void UpdateCorporation(CorporationInfo entity);
private void FillData(CorporationInfo entity)
{
entity.BrandID = DataConvert.SafeInt(ddlCarBrand.SelectedValue);
entity.ProvinceID = DataConvert.SafeInt(ddlProvince.SelectedValue);
entity.CityID = DataConvert.SafeInt(ddlCity.SelectedValue);
entity.DistrictID = DataConvert.SafeInt(ddlDistrict.SelectedValue);
entity.IsProcess = DataConvert.SafeInt(rblIsProcess.SelectedValue);
}
public void Update(CorporationInfo entity)
{
CommonDataProvider.Instance().UpdateCorporation(entity);
}
public void Add(CorporationInfo entity)
{
CommonDataProvider.Instance().AddCorporation(entity);
}
public void Update(CorporationInfo entity)
{
CommonDataProvider.Instance().UpdateCorporation(entity);
}
public void Add(CorporationInfo entity)
{
CommonDataProvider.Instance().AddCorporation(entity);
}
private void FillData(CorporationInfo entity)
{
entity.Name = txtName.Value;
}
public static CorporationInfo PopulateCorporationInfo(IDataReader reader)
{
CorporationInfo entity = new CorporationInfo()
{
ID = (int)reader["ID"],
Name = reader["Name"] as string,
Sort = DataConvert.SafeInt(reader["Sort"])
};
SerializerData data = new SerializerData();
data.Keys = reader["PropertyNames"] as string;
data.Values = reader["PropertyValues"] as string;
entity.SetSerializerData(data);
return entity;
}
