public int Insert(GZS.Model.EnvironmentImgM model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into EnvironmentImg(");
strSql.Append("Environmenttabid,imgpath,imgexplain)");
strSql.Append(" values (");
strSql.Append("@Environmenttabid,@imgpath,@imgexplain)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Environmenttabid", SqlDbType.Int, 4),
new SqlParameter("@imgpath", SqlDbType.NVarChar, 300),
new SqlParameter("@imgexplain", SqlDbType.NVarChar, 300)
};
parameters[0].Value = model.Environmenttabid;
parameters[1].Value = model.imgpath;
parameters[2].Value = model.imgexplain;
object obj = DBHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
GZS.BLL.EnvironmentTabBLL envtabbll = new GZS.BLL.EnvironmentTabBLL();
GZS.BLL.EnvironmentImgBLL envimgbll = new GZS.BLL.EnvironmentImgBLL();
if (txtzhongwen.Text.Trim() == "")
{
Response.Write("<script>alert('请输入中文描述！');</script>");
txtzhongwen.Focus();
return;
}
if (counts == 0)
{
GZS.Model.EnvironmentTabM environmentTabmodel = new GZS.Model.EnvironmentTabM();
environmentTabmodel.loginName = loginname;
environmentTabmodel.EnvironmentTypeid = EnvironmentTypeids;
environmentTabmodel.Chineseintroduced = txtzhongwen.Text.Trim();
environmentTabmodel.Englishintroduction = txtengilsh.Text.Trim();
environmentTabmodel.Createtime = DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToLongTimeString().Trim();
environmentTabmodel.Updatetime = DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToLongTimeString().Trim();
int re = envtabbll.CountByLoginNameandTypeid(environmentTabmodel.loginName.Trim(), EnvironmentTypeids);
if (re > 0)
{
Response.Write("<script>alert('已经存在该类型的资料！');</script>");
return;
}
int reslut = envtabbll.Insert(environmentTabmodel);
if (reslut != 0)
{
foreach (DataListItem item in DataList1.Items)
{
HiddenField fid1 = (HiddenField)item.FindControl("HiddenField1");
HiddenField fid2 = (HiddenField)item.FindControl("HiddenField2");
GZS.Model.EnvironmentImgM envimgmodel = new GZS.Model.EnvironmentImgM();
envimgmodel.Environmenttabid = reslut;
envimgmodel.imgpath = fid1.Value.Trim();
envimgmodel.imgexplain = fid2.Value.Trim();
int res = envimgbll.Insert(envimgmodel);
}
int resa = envtabbll.StaticHtml(loginname);
int ax = envtabbll.StaticHtmls(loginname);
Response.Write("<script>alert('录入成功！');</script>");
}
else
{
Response.Write("<script>alert('录入失败！');</script>");
}
}
else
{
GZS.Model.EnvironmentTabM environmentTabmodelS = envtabbll.GetModel(counts);
GZS.Model.EnvironmentTabM environmentTabmodel = new GZS.Model.EnvironmentTabM();
environmentTabmodel.loginName = loginname;
environmentTabmodel.EnvironmentTypeid = EnvironmentTypeids;
environmentTabmodel.Chineseintroduced = txtzhongwen.Text.Trim();
environmentTabmodel.Englishintroduction = txtengilsh.Text.Trim();
environmentTabmodel.Createtime = environmentTabmodelS.Createtime.Trim();
environmentTabmodel.Environmentid = counts;
environmentTabmodel.Updatetime = DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToLongTimeString().Trim();
int s = envtabbll.Update(environmentTabmodel);
if (ViewState["update"].Equals("true"))
{
envimgbll.Delete(counts);
foreach (DataListItem item in DataList1.Items)
{
HiddenField fid1 = (HiddenField)item.FindControl("HiddenField1");
HiddenField fid2 = (HiddenField)item.FindControl("HiddenField2");
GZS.Model.EnvironmentImgM envimgmodel = new GZS.Model.EnvironmentImgM();
envimgmodel.Environmenttabid = counts;
envimgmodel.imgpath = fid1.Value.Trim();
envimgmodel.imgexplain = fid2.Value.Trim();
int res = envimgbll.Insert(envimgmodel);
}
}
int resa = envtabbll.StaticHtml(loginname);
int ax = envtabbll.StaticHtmls(loginname);
if (resa > 0)
{
Response.Write("<script>alert('修改成功！');location.href='EnvironmentManage.aspx';</script>");
}
else
{
Response.Write("<script>alert('修改失败！');</script>");
}
}
}
