/// <summary> /// 增加一条数据 /// </summary> public int Add(ZhongLi.Model.ChannelCnvestment model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@Company", SqlDbType.NVarChar, 50), new SqlParameter("@Address", SqlDbType.NVarChar, 200), new SqlParameter("@LinkMan", SqlDbType.NVarChar, 50), new SqlParameter("@Phone", SqlDbType.NVarChar, 50), new SqlParameter("@Email", SqlDbType.NVarChar, 50), new SqlParameter("@MainBusiness", SqlDbType.NVarChar, 200), new SqlParameter("@City", SqlDbType.NVarChar, 50), new SqlParameter("@TeamSize", SqlDbType.NVarChar, 50), new SqlParameter("@MainAdvantage", SqlDbType.NVarChar, 200) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.Company; parameters[2].Value = model.Address; parameters[3].Value = model.LinkMan; parameters[4].Value = model.Phone; parameters[5].Value = model.Email; parameters[6].Value = model.MainBusiness; parameters[7].Value = model.City; parameters[8].Value = model.TeamSize; parameters[9].Value = model.MainAdvantage; DbHelperSQL.RunProcedure("ChannelCnvestment_ADD", parameters, out rowsAffected); return((int)parameters[0].Value); }
private void databind() { int ID = Convert.ToInt32(Request.QueryString["ID"]); ZhongLi.Model.ChannelCnvestment c = bll.GetModel(ID); ltlCompany.Text = c.Company; ltlAddress.Text = c.Address; ltlPhone.Text = c.Phone; ltlLinkMan.Text = c.LinkMan; ltlEmail.Text = c.Email; ltlCity.Text = c.City; ltlTeamSize.Text = c.TeamSize; ltlMainBusiness.Text = c.MainBusiness; ltlMainAdvantage.Text = c.MainAdvantage; }
protected void btnSave_Click(object sender, EventArgs e) { ZhongLi.Model.ChannelCnvestment c = new ZhongLi.Model.ChannelCnvestment(); c.Company = txtCompany.Text; c.Address = txtAddress.Text; c.LinkMan = txtLinkMan.Text; c.Phone = txtPhone.Text; c.Email = txtEmail.Text; c.City = txtCity.Text; c.MainBusiness = txtMainBusiness.Text; c.MainAdvantage = txtMainAdvantage.Text; c.TeamSize = txtTeamSize.Text; new ZhongLi.BLL.ChannelCnvestment().Add(c); this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>document.body.onload=sload;function sload(){alert('提交申请成功!');window.location = 'index.aspx';}</script>"); }
/// <summary> /// 得到一个对象实体 /// </summary> public ZhongLi.Model.ChannelCnvestment DataRowToModel(DataRow row) { ZhongLi.Model.ChannelCnvestment model = new ZhongLi.Model.ChannelCnvestment(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["Company"] != null) { model.Company = row["Company"].ToString(); } if (row["Address"] != null) { model.Address = row["Address"].ToString(); } if (row["LinkMan"] != null) { model.LinkMan = row["LinkMan"].ToString(); } if (row["Phone"] != null) { model.Phone = row["Phone"].ToString(); } if (row["Email"] != null) { model.Email = row["Email"].ToString(); } if (row["MainBusiness"] != null) { model.MainBusiness = row["MainBusiness"].ToString(); } if (row["City"] != null) { model.City = row["City"].ToString(); } if (row["TeamSize"] != null) { model.TeamSize = row["TeamSize"].ToString(); } if (row["MainAdvantage"] != null) { model.MainAdvantage = row["MainAdvantage"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public ZhongLi.Model.ChannelCnvestment GetModel(int ID) { SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; ZhongLi.Model.ChannelCnvestment model = new ZhongLi.Model.ChannelCnvestment(); DataSet ds = DbHelperSQL.RunProcedure("ChannelCnvestment_GetModel", parameters, "ds"); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ZhongLi.Model.ChannelCnvestment model) { int rowsAffected = 0; SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@Company", SqlDbType.NVarChar, 50), new SqlParameter("@Address", SqlDbType.NVarChar, 200), new SqlParameter("@LinkMan", SqlDbType.NVarChar, 50), new SqlParameter("@Phone", SqlDbType.NVarChar, 50), new SqlParameter("@Email", SqlDbType.NVarChar, 50), new SqlParameter("@MainBusiness", SqlDbType.NVarChar, 200), new SqlParameter("@City", SqlDbType.NVarChar, 50), new SqlParameter("@TeamSize", SqlDbType.NVarChar, 50), new SqlParameter("@MainAdvantage", SqlDbType.NVarChar, 200) }; parameters[0].Value = model.ID; parameters[1].Value = model.Company; parameters[2].Value = model.Address; parameters[3].Value = model.LinkMan; parameters[4].Value = model.Phone; parameters[5].Value = model.Email; parameters[6].Value = model.MainBusiness; parameters[7].Value = model.City; parameters[8].Value = model.TeamSize; parameters[9].Value = model.MainAdvantage; DbHelperSQL.RunProcedure("ChannelCnvestment_Update", parameters, out rowsAffected); if (rowsAffected > 0) { return(true); } else { return(false); } }