/// <summary> /// 更新一条数据 /// </summary> public bool Update(FishEntity.CustomerOfCompanyEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update t_customerofcompany set "); //#warning 系统发现缺少更新的字段,请手工确认如此更新是否正确! strSql.Append("id=@id,"); strSql.Append("companyid=@companyid,"); strSql.Append("customerid=@customerid"); strSql.Append(" where id=@id"); MySqlParameter[] parameters = { new MySqlParameter("@id", MySqlDbType.Int32, 11), new MySqlParameter("@companyid", MySqlDbType.Int32, 11), new MySqlParameter("@customerid", MySqlDbType.Int32, 11) }; parameters[0].Value = model.id; parameters[1].Value = model.companyid; parameters[2].Value = model.customerid; int rows = MySqlHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(FishEntity.CustomerOfCompanyEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_customerofcompany("); strSql.Append("companyid,customerid)"); strSql.Append(" values ("); strSql.Append("@companyid,@customerid)"); MySqlParameter[] parameters = { new MySqlParameter("@companyid", MySqlDbType.Int32, 11), new MySqlParameter("@customerid", MySqlDbType.Int32, 11) }; parameters[0].Value = model.companyid; parameters[1].Value = model.customerid; int rows = MySqlHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public FishEntity.CustomerOfCompanyEntity DataRowToModel(DataRow row) { FishEntity.CustomerOfCompanyEntity model = new FishEntity.CustomerOfCompanyEntity(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["companyid"] != null && row["companyid"].ToString() != "") { model.companyid = int.Parse(row["companyid"].ToString()); } if (row["customerid"] != null && row["customerid"].ToString() != "") { model.customerid = int.Parse(row["customerid"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public FishEntity.CustomerOfCompanyEntity GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,companyid,customerid from t_customerofcompany "); strSql.Append(" where id=@id"); MySqlParameter[] parameters = { new MySqlParameter("@id", MySqlDbType.Int32) }; parameters[0].Value = id; FishEntity.CustomerOfCompanyEntity model = new FishEntity.CustomerOfCompanyEntity(); DataSet ds = MySqlHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public override int Modify() { if (Check() == false) { return(0); } int sourceCompanyId = _customer.companyId; _customer.code = txtCode.Text; int companyId = 0; if (string.IsNullOrEmpty(txtCompany.Text) == false && txtCompany.Tag != null && txtCompany.Tag is FishEntity.CompanyEntity) { FishEntity.CompanyEntity company = txtCompany.Tag as FishEntity.CompanyEntity; _customer.company = company.code; companyId = company.id; _customer.companyId = company.id; } else { _customer.companyId = 0; _customer.company = string.Empty; } _customer.currentlinkDate = dtpCurrentDate.Value; _customer.department = string.Empty; _customer.email = txtEmail.Text; _customer.modifyman = FishEntity.Variable.User.username; _customer.modifytime = DateTime.Now; _customer.name = txtName.Text; _customer.phone1 = txtPhone1.Text; _customer.phone2 = txtPhone2.Text; _customer.phone3 = txtPhone3.Text; _customer.post = txtPost.Text; _customer.Department1 = txtdepartment1.Text; _customer.qq = txtQQ.Text; _customer.remark = txtRemark.Text; _customer.telephone = txtTelephone.Text; _customer.validate = cmbValidate.Text.Equals("有效")?1:0; _customer.weixin = txtWeixin.Text; _customer.homeaddress = txtHomeAddress.Text.Trim(); _customer.officeaddress = txtOfficeAddress.Text.Trim(); _customer.sex = rdbMan.Checked?"男":"女"; _customer.fox = txtfox.Text.Trim(); DateTime nextlinkDate; if (DateTime.TryParse(txtNextLinkDate.Text, out nextlinkDate)) { _customer.nextlinkdate = nextlinkDate; } else { _customer.nextlinkdate = null; } FishBll.Bll.CustomerBll bll = new FishBll.Bll.CustomerBll(); bool isOk = bll.Update(_customer); if (isOk) { FishBll.Bll.CustomerOfCompanyBll ccBll = new FishBll.Bll.CustomerOfCompanyBll(); if (_customer.companyId == 0 && sourceCompanyId > 0) { ccBll.Delete(sourceCompanyId, _customer.id); } else if (_customer.companyId > 0 && sourceCompanyId == 0) { FishEntity.CustomerOfCompanyEntity ccEntity = new FishEntity.CustomerOfCompanyEntity(); ccEntity.companyid = _customer.companyId; ccEntity.customerid = _customer.id; ccBll.Add(ccEntity); } else if (_customer.companyId > 0 && sourceCompanyId > 0) { ccBll.Update(sourceCompanyId, _customer.id, _customer.companyId, _customer.id); } SaveHeaderPicture(_customer.id); MessageBox.Show("修改成功。"); } else { MessageBox.Show("修改失败。"); } return(1); }
public override void Save() { if (Check() == false) { return; } _customer = new FishEntity.CustomerEntity(); _customer.code = FishBll.Bll.SequenceUtil.GetCustomerSequence(); int companyId = 0; if (string.IsNullOrEmpty(txtCompany.Text) == false && txtCompany.Tag != null && txtCompany.Tag is FishEntity.CompanyEntity) { FishEntity.CompanyEntity company = txtCompany.Tag as FishEntity.CompanyEntity; _customer.company = company.code; companyId = company.id; _customer.companyId = company.id; } _customer.createman = FishEntity.Variable.User.username; _customer.createtime = DateTime.Now; _customer.currentlinkDate = dtpCurrentDate.Value; _customer.department = string.Empty; _customer.email = txtEmail.Text; _customer.isdelete = 0; _customer.modifyman = _customer.createman; _customer.modifytime = _customer.createtime; _customer.name = txtName.Text; DateTime nextlinkdate; if (DateTime.TryParse(txtNextLinkDate.Text, out nextlinkdate)) { _customer.nextlinkdate = DateTime.Parse(txtNextLinkDate.Text); } else { _customer.nextlinkdate = null; } _customer.phone1 = txtPhone1.Text; _customer.phone2 = txtPhone2.Text; _customer.phone3 = txtPhone3.Text; _customer.post = txtPost.Text; _customer.Department1 = txtdepartment1.Text; _customer.qq = txtQQ.Text; _customer.remark = txtRemark.Text; _customer.telephone = txtTelephone.Text; _customer.validate = cmbValidate.Text.Equals("有效") ? 1 : 0; _customer.weixin = txtWeixin.Text; _customer.homeaddress = txtHomeAddress.Text.Trim(); _customer.officeaddress = txtOfficeAddress.Text.Trim(); _customer.sex = rdbMan.Checked?"男":"女"; _customer.fox = txtfox.Text.Trim(); FishBll.Bll.CustomerBll bll = new FishBll.Bll.CustomerBll(); bool isok = bll.Exists(_customer.code); while (isok) { _customer.code = FishBll.Bll.SequenceUtil.GetCustomerSequence(); isok = bll.Exists(_customer.code); } bool isExistName = bll.ExistsName(_customer.name); if (isExistName) { MessageBox.Show("数据库中存在相同的联系人名称。"); } int id = bll.Add(_customer); if (id > 0) { _customer.id = id; txtCode.Text = _customer.code; FishBll.Bll.CustomerOfCompanyBll ccbll = new FishBll.Bll.CustomerOfCompanyBll(); if (false == string.IsNullOrEmpty(_customer.company)) { FishEntity.CustomerOfCompanyEntity ccEntity = new FishEntity.CustomerOfCompanyEntity(); ccEntity.companyid = companyId; ccEntity.customerid = _customer.id; ccbll.Add(ccEntity); } SaveHeaderPicture(id); tmiAdd.Visible = true; tmiModify.Visible = true; tmiQuery.Visible = true; tmiPrevious.Visible = true; tmiNext.Visible = true; tmiSave.Visible = false; tmiCancel.Visible = false; MessageBox.Show("添加成功。"); } else { txtCode.Text = string.Empty; MessageBox.Show("添加失败。"); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(FishEntity.CustomerOfCompanyEntity model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(FishEntity.CustomerOfCompanyEntity model) { return(dal.Add(model)); }