protected void AddImages(FishEntity.SalesRContractEntity fish) { if (fish == null) { return; } FishBll.Bll.ImageBll bll = new FishBll.Bll.ImageBll(); if (setbool.id > 0) { bll.DeleteByRecordIdAndType(setbool.id, (int)FishEntity.ImageTypeEnum.HETONG); } List <FishEntity.ImageEntity> images = GetSGSImages(); images = GetSGSImages(); if (images != null) { foreach (FishEntity.ImageEntity item in images) { item.recordid = setbool.id; item.createman = FishEntity.Variable.User.username; item.createtime = DateTime.Now; item.title = "合同"; item.remark = this.Name; bll.Add(item); } } }
public override void Save() { _model = new FishEntity.SalesRContractEntity(); List <FishEntity.productsituationEntity> modelList = new List <FishEntity.productsituationEntity>(); bll = new FishBll.Bll.SalesRContractBll(); GetSalesRContract(); DataView(modelList); //bool isok = bll.Exists(_model.ContractCode); //if (isok) //{ // MessageBox.Show("合同编号已存在!"); // return; //} bool isok = bll.ExistsNumbering(_model.Numbering); if (isok) { MessageBox.Show("编号已存在!"); return; } _model.Id = bll.Add(_model, modelList); if (_model.Id > 0) { setbool.id = _model.Id; AddImages(_model); MessageBox.Show("保存成功!"); } }
public override int Add() { tmiSave.Visible = true; tmiCancel.Visible = true; tmiAdd.Visible = false; tmiModify.Visible = false; tmiQuery.Visible = false; tmiDelete.Visible = false; tmiClose.Visible = false; tmiNext.Visible = false; tmiPrevious.Visible = false; tmiExport.Visible = false; tmiReview.Visible = false; txtcode.Text = string.Empty; txtdemand.Text = string.Empty; txtNumbering.Text = string.Empty; txtSignplace.Text = string.Empty; txtsupplier.Text = string.Empty; dtpSigndate.Value = DateTime.Now; _model = null; dataGridView1.Rows.Clear(); dataGridView1.Rows.Insert(0, new DataGridViewRow()); //新增带入 bll = new FishBll.Bll.SalesRContractBll(); DataTable queryTable = bll.getxxsqd(" a.Numbering='" + name + "' "); if (queryTable != null && queryTable.Rows.Count > 0) { dataGridView1.Rows.Clear(); for (int i = 0; i < queryTable.Rows.Count; i++) { int idx = dataGridView1.Rows.Add(); DataGridViewRow row = dataGridView1.Rows[idx]; txtNumbering.Text = queryTable.Rows[i]["Numbering"].ToString(); dtpSigndate.Value = DateTime.Parse(queryTable.Rows[i]["Signdate"].ToString()); txtdemand.Text = queryTable.Rows[i]["demand"].ToString(); txtSignplace.Text = queryTable.Rows[i]["Signplace"].ToString(); txtsupplier.Text = queryTable.Rows[i]["supplier"].ToString(); txtcode.Text = queryTable.Rows[i]["code"].ToString(); row.Cells["product_id"].Value = queryTable.Rows[i]["product_id"].ToString(); row.Cells["productname"].Value = queryTable.Rows[i]["productname"].ToString(); row.Cells["Funit"].Value = queryTable.Rows[i]["Funit"].ToString(); row.Cells["Variety"].Value = queryTable.Rows[i]["Variety"].ToString(); row.Cells["Quantity"].Value = queryTable.Rows[i]["Quantity"].ToString(); row.Cells["unitprice"].Value = queryTable.Rows[i]["unitprice"].ToString(); row.Cells["Amonut"].Value = queryTable.Rows[i]["Amonut"].ToString(); } } return(0); }
public int Add(FishEntity.SalesRContractEntity model, List <FishEntity.productsituationEntity> modeList) { StringBuilder strsql = new StringBuilder(); Hashtable SQLString = new Hashtable(); strsql.Append("insert into t_salesrcontract(Numbering,Signdate,Signplace,supplier,demand,createman,createtime,modifyman,modifytime,ContractCode)values(@Numbering,@Signdate,@Signplace,@supplier,@demand,@createman,@createtime,@modifyman,@modifytime,@ContractCode)"); MySqlParameter[] parameters = { new MySqlParameter("@ContractCode", MySqlDbType.VarChar, 45), new MySqlParameter("@Numbering", MySqlDbType.VarChar, 45), new MySqlParameter("@Signdate", MySqlDbType.DateTime), new MySqlParameter("@Signplace", MySqlDbType.VarChar, 45), new MySqlParameter("@supplier", MySqlDbType.VarChar, 45), new MySqlParameter("@demand", MySqlDbType.VarChar, 45), new MySqlParameter("@createman", MySqlDbType.VarChar, 45), new MySqlParameter("@createtime", MySqlDbType.DateTime), new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45), new MySqlParameter("@modifytime", MySqlDbType.DateTime) }; parameters[0].Value = model.ContractCode; parameters[1].Value = model.Numbering; parameters[2].Value = model.Signdate; parameters[3].Value = model.Signplace; parameters[4].Value = model.Supplier; parameters[5].Value = model.Demand; parameters[6].Value = model.Createman; parameters[7].Value = model.Createtime; parameters[8].Value = model.Modifyman; parameters[9].Value = model.Modifytime; SQLString.Add(strsql.ToString(), parameters); foreach (FishEntity.productsituationEntity list in modeList) { add_body(list, SQLString, strsql); } if (MySqlHelper.ExecuteSqlTran(SQLString)) { strsql = new StringBuilder(); strsql.AppendFormat("select id from t_SalesRContract where ContractCode='{0}' and Numbering='{1}'", model.ContractCode, model.Numbering); DataTable dt = MySqlHelper.Query(strsql.ToString()).Tables[0]; if (dt != null && dt.Rows.Count > 0) { return(string.IsNullOrEmpty(dt.Rows[0]["id"].ToString()) == true ? 0 : Convert.ToInt32(dt.Rows[0]["id"].ToString())); } else { return(0); } } else { return(0); } }
public override int Modify() { _model = new FishEntity.SalesRContractEntity(); GetSalesRContract(); List <FishEntity.productsituationEntity> modelList = new List <FishEntity.productsituationEntity>(); DataView(modelList); bll = new FishBll.Bll.SalesRContractBll(); bool isok = bll.Update(_model, modelList); if (isok == true) { AddImages(_model); MessageBox.Show("保存成功!"); return(1); } return(1); }
public override int Query( ) { if (QueryForm == null) { QueryForm = new UIForms.FormSalesRContractQuery(); QueryForm.StartPosition = FormStartPosition.CenterParent; QueryForm.ShowInTaskbar = false; } if (QueryForm.ShowDialog() != System.Windows.Forms.DialogResult.OK) { return(0); } _where = QueryForm.GetWhereCondition; bll = new FishBll.Bll.SalesRContractBll(); _model = new FishEntity.SalesRContractEntity(); _model = bll.GetList(_where); if (_model != null) { SetSalesRContract(); dataGridView1.Rows.Clear(); GenerateBody(); } else { MessageBox.Show("查无数据!"); } //FormSalesTables form = new FormSalesTables(); //form.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent; //if (form.ShowDialog() != System.Windows.Forms.DialogResult.OK) //if (form.fish == null) return 1; //txtcode.Text = string.Empty; //txtcode.Text = form.fish.code; //dataGridView1.Rows.Clear(); //GenerateContect(); //if (result == true) // GenerateBody(); return(base.Query( )); }
//void GenerateContect ( ) //{ // result = _bll . Exist (txtNumbering. Text ); // if ( result == true ) // { // _rolewhere += " Numbering= '" + txtNumbering.Text+"' "; // if (FishEntity.Variable.User.roletype.Equals(FishEntity.Constant.Role_SalesMan)) // { // _rolewhere += string.Format(" and createman='{0}' ", FishEntity.Variable.User.username); // } // FishEntity . SalesRequisitionEntity _list = _bll . GetList (_rolewhere); // if ( _list == null ) // return; // headSetValue ( _list ); // } // else // MessageBox . Show ( "编号:" + txtNumbering. Text + "不存在,请核实" ); //} //void GenerateContectCode() //{ // result = _bll.ExistCode(txtNumbering.Text); // if (result == true) // { // _rolewhere += " Numbering= '" + txtcode.Text + "' "; // if (FishEntity.Variable.User.roletype.Equals(FishEntity.Constant.Role_SalesMan)) // { // _rolewhere += string.Format(" and createman='{0}' ", FishEntity.Variable.User.username); // } // FishEntity.SalesRequisitionEntity _list = _bll.GetList(_rolewhere); // if (_list == null) // return; // headSetValue(_list); // } // else // MessageBox.Show("销售编号:" + txtcode.Text + "不存在,请核实"); //} void GenerateContectNumbering() { bll = new FishBll.Bll.SalesRContractBll(); result = _bll.ExistCode(txtNumbering.Text); if (result == true) { _rolewhere += " Numbering= '" + txtNumbering.Text + "' "; if (FishEntity.Variable.User.roletype.Equals(FishEntity.Constant.Role_SalesMan)) { _rolewhere += string.Format(" and createman='{0}' ", FishEntity.Variable.User.username); } _model = new FishEntity.SalesRContractEntity(); _model = bll.GetList(_rolewhere); if (_model == null) { return; } SetSalesRContract(); } //else //MessageBox.Show("销售编号:" + txtcode.Text + "不存在,请核实"); }
public static FishEntity.SalesRContractEntity DataRowToModel(DataRow row) { FishEntity.SalesRContractEntity model = new FishEntity.SalesRContractEntity(); if (row != null) { if (row["Numbering"] != null && row["Numbering"].ToString() != "") { model.Numbering = row["Numbering"].ToString(); } if (row["ContractCode"] != null && row["ContractCode"].ToString() != "") { model.ContractCode = row["ContractCode"].ToString(); } if (row["demand"] != null && row["demand"].ToString() != "") { model.Demand = row["demand"].ToString(); } if (row["supplier"] != null && row["supplier"].ToString() != "") { model.Supplier = row["supplier"].ToString(); } if (row["Signplace"] != null && row["Signplace"].ToString() != "") { model.Signplace = row["Signplace"].ToString(); } if (row["Signdate"] != null && row["Signdate"].ToString() != "") { model.Signdate = DateTime.Parse(row["Signdate"].ToString()); } if (row["id"] != null && row["id"].ToString() != "") { model.Id = int.Parse(row["id"].ToString()); } } return(model); }
/// <summary> /// 编辑一单记录 /// </summary> /// <param name="model"></param> /// <param name="modeList"></param> /// <returns></returns> public bool Update(FishEntity.SalesRContractEntity model, List <FishEntity.productsituationEntity> modeList) { return(Dao.Update(model, modeList)); }
/// <summary> /// 新建 /// </summary> /// <param name="_model"></param> /// <param name="modeList"></param> /// <returns></returns> public int Add(FishEntity.SalesRContractEntity _model, List <FishEntity.productsituationEntity> modeList) { return(Dao.Add(_model, modeList)); }
/// <summary> /// 编辑一单记录 /// </summary> /// <param name="model"></param> /// <param name="modeList"></param> /// <returns></returns> public bool Update(FishEntity.SalesRContractEntity model, List <FishEntity.productsituationEntity> modeList) { Hashtable SQLString = new Hashtable(); StringBuilder strSql = new StringBuilder(); strSql.Append("update t_salesrcontract set "); strSql.Append("ContractCode=@ContractCode,"); strSql.Append("Signdate=@Signdate,"); strSql.Append("Signplace=@Signplace,"); strSql.Append("supplier=@supplier,"); strSql.Append("demand=@demand,"); strSql.Append("modifyman=@modifyman,"); strSql.Append("modifytime=@modifytime "); strSql.Append(" where id = @id"); MySqlParameter[] parameters = { new MySqlParameter("@ContractCode", model.ContractCode), new MySqlParameter("@Signdate", model.Signdate), new MySqlParameter("@Signplace", model.Signplace), new MySqlParameter("@supplier", model.Supplier), new MySqlParameter("@demand", model.Demand), new MySqlParameter("@modifyman", model.Modifyman), new MySqlParameter("@modifytime", model.Modifytime), new MySqlParameter("@id", model.Id), }; SQLString.Add(strSql.ToString(), parameters); foreach (FishEntity.productsituationEntity list in modeList) { if (Exists(list.Numbering, list.Product_id) == false) { add_body(list, SQLString, strSql); } else { edit_body(list, SQLString, strSql); } } DataSet ds = MySqlHelper.Query("SELECT product_id FROM t_productsituation WHERE code='" + model.ContractCode + "'" + " and Numbering='" + model.Numbering + "'"); DataTable dt = ds.Tables[0]; if (dt != null && dt.Rows.Count > 0) { FishEntity.productsituationEntity list = new FishEntity.productsituationEntity(); for (int i = 0; i < dt.Rows.Count; i++) { model.Product_id = list.Product_id = dt.Rows[i]["product_id"].ToString(); list = modeList.Find((k) => { return(k.Product_id.Equals(model.Product_id)); }); if (list == null) { delete_body(model.Numbering, model.Product_id, SQLString, strSql); } } } return(MySqlHelper.ExecuteSqlTran(SQLString)); }