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>"); } } }