/// <summary> ///[CusLinkman]表查询实体的方法 /// </summary> public static CusLinkman getCusLinkmanById(int id) { CusLinkman cuslinkman = null; string sql = "select * from CusLinkman where id=@id"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@id", id) }; DataTable dt = DBHelper.GetDataSet(sql, sp); if (dt.Rows.Count > 0) { cuslinkman = new CusLinkman(); foreach (DataRow dr in dt.Rows) { cuslinkman.Id = Convert.ToInt32(dr["id"]); cuslinkman.CustomerId = Convert.ToInt32(dr["customerId"]); cuslinkman.LinkName = Convert.ToString(dr["linkName"]); cuslinkman.DepartName = Convert.ToString(dr["departName"]); cuslinkman.Telephone = Convert.ToString(dr["telephone"]); cuslinkman.Fax = Convert.ToString(dr["fax"]); cuslinkman.Mobile = Convert.ToString(dr["mobile"]); cuslinkman.Email = Convert.ToString(dr["email"]); cuslinkman.Msn = Convert.ToString(dr["msn"]); cuslinkman.Skype = Convert.ToString(dr["skype"]); } } return(cuslinkman); }
/// <summary> ///根据SQL语句获取集合 /// </summary> public static IList <CusLinkman> getCusLinkmansBySql(string sql) { IList <CusLinkman> list = new List <CusLinkman>(); DataTable dt = DBHelper.GetDataSet(sql); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { CusLinkman cuslinkman = new CusLinkman(); cuslinkman.Id = Convert.ToInt32(dr["id"]); cuslinkman.CustomerId = Convert.ToInt32(dr["customerId"]); cuslinkman.LinkName = Convert.ToString(dr["linkName"]); cuslinkman.DepartName = Convert.ToString(dr["departName"]); cuslinkman.Telephone = Convert.ToString(dr["telephone"]); cuslinkman.Fax = Convert.ToString(dr["fax"]); cuslinkman.Mobile = Convert.ToString(dr["mobile"]); cuslinkman.Email = Convert.ToString(dr["email"]); cuslinkman.Msn = Convert.ToString(dr["msn"]); cuslinkman.Skype = Convert.ToString(dr["skype"]); list.Add(cuslinkman); } } return(list); }
/// <summary> /// 加载营业部信息 /// </summary> private void loadDepart() { string departid = Request.QueryString["departid"]; //营业部id CusLinkman model = CusLinkmanManager.getCusLinkmanById(int.Parse(departid)); departName.Value = model.DepartName; //营业部名称 linkTel.Value = model.Telephone; //电话 linkFax.Value = model.Fax; //传真 linkEmail.Value = model.Email; //邮箱 linkMsn.Value = model.Msn; //qq linkSkype.Value = model.Skype; //skype }
private void addlinkinfo() { //联系人信息 EtNet_Models.CusLinkman cusLink = new CusLinkman(); cusLink.CustomerId = CustomerManager.getLastOneID().Id; cusLink.LinkName = this.linkname.Value.ToString(); cusLink.Post = this.linkpost.Value.ToString(); cusLink.Telephone = this.linktel.Value.ToString(); cusLink.Fax = this.linkfax.Value.ToString(); cusLink.Email = this.linkemail.Value.ToString(); cusLink.Mobile = this.linkmobile.Value.ToString(); cusLink.Msn = this.linkmsn.Value.ToString(); cusLink.Skype = this.linkskype.Value.ToString(); CusLinkmanManager.addCusLinkman(cusLink); }
/// <summary> ///[CusLinkman]表添加的方法 /// </summary> public static int addCusLinkman(CusLinkman cuslinkman) { string sql = "insert into CusLinkman([customerId],[linkName],[departName],[telephone],[fax],[mobile],[email],[msn],[skype]) values (@customerId,@linkName,@departName,@telephone,@fax,@mobile,@email,@msn,@skype)"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@customerId", cuslinkman.CustomerId), new SqlParameter("@linkName", cuslinkman.LinkName), new SqlParameter("@departName", cuslinkman.DepartName), new SqlParameter("@telephone", cuslinkman.Telephone), new SqlParameter("@fax", cuslinkman.Fax), new SqlParameter("@mobile", cuslinkman.Mobile), new SqlParameter("@email", cuslinkman.Email), new SqlParameter("@msn", cuslinkman.Msn), new SqlParameter("@skype", cuslinkman.Skype) }; return(DBHelper.ExecuteCommand(sql, sp)); }
/// <summary> ///[CusLinkman]表修改的方法 /// </summary> public static int updateCusLinkmanById(CusLinkman cuslinkman) { string sql = "update CusLinkman set customerId=@customerId,linkName=@linkName,departName=@departName,telephone=@telephone,fax=@fax,mobile=@mobile,email=@email,msn=@msn,skype=@skype where id=@id"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@id", cuslinkman.Id), new SqlParameter("@customerId", cuslinkman.CustomerId), new SqlParameter("@linkName", cuslinkman.LinkName), new SqlParameter("@departName", cuslinkman.DepartName), new SqlParameter("@telephone", cuslinkman.Telephone), new SqlParameter("@fax", cuslinkman.Fax), new SqlParameter("@mobile", cuslinkman.Mobile), new SqlParameter("@email", cuslinkman.Email), new SqlParameter("@msn", cuslinkman.Msn), new SqlParameter("@skype", cuslinkman.Skype) }; return(DBHelper.ExecuteCommand(sql, sp)); }
public static int updateCusLinkman(CusLinkman cuslinkman) { return(CusLinkmanService.updateCusLinkmanById(cuslinkman)); }
public static int addCusLinkman(CusLinkman cuslinkman) { return(CusLinkmanService.addCusLinkman(cuslinkman)); }