/// <summary> /// 更新一条数据 /// </summary> public bool Update(ZhongLi.Model.CooperativePartner model) { int rowsAffected = 0; SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@Name", SqlDbType.NVarChar, 50), new SqlParameter("@Logo", SqlDbType.NVarChar, 500), new SqlParameter("@Sort", SqlDbType.Int, 4), new SqlParameter("@LinkUrl", SqlDbType.NVarChar, 500), new SqlParameter("@CreateDate", SqlDbType.DateTime) }; parameters[0].Value = model.ID; parameters[1].Value = model.Name; parameters[2].Value = model.Logo; parameters[3].Value = model.Sort; parameters[4].Value = model.LinkUrl; parameters[5].Value = model.CreateDate; DbHelperSQL.RunProcedure("CooperativePartner_Update", parameters, out rowsAffected); if (rowsAffected > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ZhongLi.Model.CooperativePartner DataRowToModel(DataRow row) { ZhongLi.Model.CooperativePartner model = new ZhongLi.Model.CooperativePartner(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["Name"] != null) { model.Name = row["Name"].ToString(); } if (row["Logo"] != null) { model.Logo = row["Logo"].ToString(); } if (row["Sort"] != null && row["Sort"].ToString() != "") { model.Sort = int.Parse(row["Sort"].ToString()); } if (row["LinkUrl"] != null) { model.LinkUrl = row["LinkUrl"].ToString(); } if (row["CreateDate"] != null && row["CreateDate"].ToString() != "") { model.CreateDate = DateTime.Parse(row["CreateDate"].ToString()); } } return(model); }
protected void Page_Load(object sender, EventArgs e) { if (!Utils.CheckRole("14")) { Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsgclose('权限信息','没有权限!','/Systestcomjun/index.aspx',2)</script>"); return; } if (!IsPostBack) { ZhongLi.Model.siteconfig site = new ZhongLi.Bll.siteconfig().loadConfig(Server.MapPath("/xmlconfig/site.config")); imgformat = site.ImgFormat; ltlTitle.Text = "新增内容"; if (Request.QueryString["ID"] != null) { int ID = Convert.ToInt32(Request.QueryString["ID"]); ZhongLi.Model.CooperativePartner CP = bll.GetModel(ID); txtName.Text = CP.Name; if (CP.Logo != "") { img_Photo.ImageUrl = CP.Logo; } Sort.Text = CP.Sort.ToString(); LinkUrl.Text = CP.LinkUrl; } } }
protected void btnsave_Click(object sender, EventArgs e) { ZhongLi.Model.CooperativePartner cp = null; if (Request.QueryString["ID"] != null) { cp = bll.GetModel(Convert.ToInt32(Request.QueryString["ID"])); } else { cp = new ZhongLi.Model.CooperativePartner(); cp.CreateDate = DateTime.Now; cp.Logo = ""; } cp.Name = txtName.Text; ZhongLi.Model.siteconfig site = new ZhongLi.Bll.siteconfig().loadConfig(Server.MapPath("/xmlconfig/site.config")); if (fileLogo.HasFile) { if (fileLogo.PostedFile.ContentLength <= site.FileSize * 1024) { string fileExt = Utils.GetFileExt(fileLogo.FileName); string newname = DateTime.Now.ToString("yyyyMMddHHmmssffff") + "." + fileExt; string filePath = Utils.GetMapPath("/upload/CooperativePartner/") + newname; fileLogo.SaveAs(filePath); cp.Logo = "/upload/CooperativePartner/" + newname; } } cp.Sort = Convert.ToInt32(Sort.Text); cp.LinkUrl = LinkUrl.Text; if (cp.ID == 0) { if (bll.Add(cp) > 0) { webHelper.addLog("新添加了合作伙伴“" + cp.Name + "”"); Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsgclose('合作伙伴','保存成功!','',1)</script>"); } else { Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsgclose('合作伙伴','保存失败','',2)</script>"); } } else { if (bll.Update(cp)) { webHelper.addLog("修改了内容“" + cp.Name + "”"); Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsgclose('合作伙伴','保存成功!','',1)</script>"); } else { Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsgclose('合作伙伴','保存失败','',2);</script>"); } } }
/// <summary> /// 得到一个对象实体 /// </summary> public ZhongLi.Model.CooperativePartner GetModel(int ID) { SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; ZhongLi.Model.CooperativePartner model = new ZhongLi.Model.CooperativePartner(); DataSet ds = DbHelperSQL.RunProcedure("CooperativePartner_GetModel", parameters, "ds"); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ZhongLi.Model.CooperativePartner model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@Name", SqlDbType.NVarChar, 50), new SqlParameter("@Logo", SqlDbType.NVarChar, 500), new SqlParameter("@Sort", SqlDbType.Int, 4), new SqlParameter("@LinkUrl", SqlDbType.NVarChar, 500), new SqlParameter("@CreateDate", SqlDbType.DateTime) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.Name; parameters[2].Value = model.Logo; parameters[3].Value = model.Sort; parameters[4].Value = model.LinkUrl; parameters[5].Value = model.CreateDate; DbHelperSQL.RunProcedure("CooperativePartner_ADD", parameters, out rowsAffected); return((int)parameters[0].Value); }