public override int Query() { panel1.Enabled = true; if (_Form == null) { _Form = new UIForms.FormContractProcessingSheetConditicon(); _Form.StartPosition = FormStartPosition.CenterParent; _Form.ShowInTaskbar = false; } if (_Form.ShowDialog() != System.Windows.Forms.DialogResult.OK) { return(0); } _where = _Form.GetWhereCondition; List <FishEntity.ContractProcessingSheetEntity> list = _bll.GetModelListVo(_where + _rolewhere + _orderBy); if (list == null || list.Count < 1) { _fish = null; return(1); } else { _fish = list[0]; Set(); } return(1); }
public int Add(FishEntity.ContractProcessingSheetEntity model) { StringBuilder Strsql = new StringBuilder(); Strsql.Append("insert into t_ContractProcessingSheet(code,contractcode,tdate,TheReason,Processing,createtime,createman,modifytime,modifyman)"); Strsql.Append("values(@code,@contractcode,@tdate,@TheReason,@Processing,@createtime,@createman,@modifytime,@modifyman);"); Strsql.Append("select last_insert_id();"); MySqlParameter[] parameters = { new MySqlParameter("@code", MySqlDbType.VarChar, 45), new MySqlParameter("@contractcode", MySqlDbType.VarChar, 45), new MySqlParameter("@tdate", MySqlDbType.DateTime), new MySqlParameter("@TheReason", MySqlDbType.VarChar, 200), new MySqlParameter("@Processing", MySqlDbType.VarChar, 200), new MySqlParameter("@createtime", MySqlDbType.Timestamp), new MySqlParameter("@createman", MySqlDbType.VarChar, 45), new MySqlParameter("@modifytime", MySqlDbType.Timestamp), new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45) }; parameters[0].Value = model.Code; parameters[1].Value = model.Contractcode; parameters[2].Value = model.Tdate; parameters[3].Value = model.TheReason; parameters[4].Value = model.Processing; parameters[5].Value = model.Createtime; parameters[6].Value = model.Createman; parameters[7].Value = model.Modifytime; parameters[8].Value = model.Modifyman; int id = MySqlHelper.ExecuteSqlReturnId(Strsql.ToString(), parameters); return(id); }
private void FormContractProcessingSheet_Load(object sender, EventArgs e) { _rolewhere = " and code='" + Megres.oddNum + "'"; List <FishEntity.ContractProcessingSheetEntity> list = _bll.GetModelListVo(_where + _rolewhere + _orderBy); Megres.oddNum = string.Empty; if (list == null || list.Count < 1) { _fish = null; } else { _fish = list [0]; Set( ); this.panel1.Enabled = true; menuStrip1.Visible = true; tmiQuery.Visible = true; tmiPrevious.Visible = false; tmiExport.Visible = false; tmiReview.Visible = true; tmiAdd.Visible = false; tmiModify.Visible = false; tmiDelete.Visible = false; tmiClose.Visible = true; tmiCancel.Visible = false; tmiSave.Visible = false; tmiNext.Visible = false; tmiprint.Visible = false; } }
public List <FishEntity.ContractProcessingSheetEntity> GetModelListVo(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from t_ContractProcessingSheet "); if (strWhere.Trim() != "") { strSql.Append(" where 1=1 " + strWhere); } DataSet ds = MySqlHelper.Query(strSql.ToString()); List <FishEntity.ContractProcessingSheetEntity> modelList = new List <FishEntity.ContractProcessingSheetEntity>(); int rowsCount = ds.Tables[0].Rows.Count; FishEntity.ContractProcessingSheetEntity model; for (int n = 0; n < rowsCount; n++) { DataRow row = ds.Tables[0].Rows[n]; model = new FishEntity.ContractProcessingSheetEntity(); if (row["id"].ToString() != "") { model.Id = int.Parse(row["id"].ToString()); } if (row["contractcode"] != null && row["contractcode"].ToString() != "") { model.Contractcode = row["contractcode"].ToString(); } if (row["code"] != null && row["code"].ToString() != "") { model.Code = row["code"].ToString(); } if (row["tdate"] != null && row["tdate"].ToString() != "") { model.Tdate = DateTime.Parse(row["tdate"].ToString()); } if (row["TheReason"] != null && row["TheReason"].ToString() != "") { model.TheReason = row["TheReason"].ToString(); } if (row["Processing"] != null && row["Processing"].ToString() != "") { model.Processing = row["Processing"].ToString(); } modelList.Add(model); } return(modelList); }
public bool Update(FishEntity.ContractProcessingSheetEntity model) { StringBuilder Strsql = new StringBuilder(); Strsql.Append("update t_ContractProcessingSheet set "); Strsql.Append("code=@code,"); Strsql.Append("contractcode=@contractcode,"); Strsql.Append("tdate=@tdate,"); Strsql.Append("TheReason=@TheReason,"); Strsql.Append("Processing=@Processing,"); Strsql.Append("modifytime=@modifytime,"); Strsql.Append("modifyman=@modifyman "); Strsql.Append("where id=@id"); MySqlParameter[] parameters = { new MySqlParameter("@code", MySqlDbType.VarChar, 45), new MySqlParameter("@contractcode", MySqlDbType.VarChar, 45), new MySqlParameter("@tdate", MySqlDbType.DateTime), new MySqlParameter("@TheReason", MySqlDbType.VarChar, 200), new MySqlParameter("@Processing", MySqlDbType.VarChar, 200), new MySqlParameter("@modifytime", MySqlDbType.Timestamp), new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45), new MySqlParameter("@id", MySqlDbType.Int32, 11) }; parameters[0].Value = model.Code; parameters[1].Value = model.Contractcode; parameters[2].Value = model.Tdate; parameters[3].Value = model.TheReason; parameters[4].Value = model.Processing; parameters[5].Value = model.Modifytime; parameters[6].Value = model.Modifyman; parameters[7].Value = model.Id; int rows = MySqlHelper.ExecuteSql(Strsql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public override void Save() { FishEntity.ContractProcessingSheetEntity _fish = new FishEntity.ContractProcessingSheetEntity(); _fish.Code = FishBll.Bll.SequenceUtil.GetContractProcessingSheetquence(); _fish.Contractcode = txtcontractcode.Text.Trim(); _fish.Tdate = dtptdate.Value; _fish.TheReason = txtTheReason.Text.Trim(); _fish.Processing = txtProcessing.Text.Trim(); _fish.Createtime = DateTime.Now; _fish.Createman = FishEntity.Variable.User.username; _fish.Modifytime = DateTime.Now; _fish.Modifyman = FishEntity.Variable.User.username; FishBll.Bll.FormContractProcessingSheetBll bll = new FishBll.Bll.FormContractProcessingSheetBll(); bool isok = bll.Exists(_fish.Code); while (isok) { _fish.Code = FishBll.Bll.SequenceUtil.GetContractProcessingSheetquence(); isok = bll.Exists(_fish.Code); } int id = bll.Add(_fish); if (id > 0) { _fish.Id = id; tmiQuery.Visible = false; tmiDelete.Visible = false; tmiModify.Visible = false; tmiAdd.Visible = false; tmiSave.Visible = true; tmiCancel.Visible = true; MessageBox.Show("添加成功。"); txtcode.Text = _fish.Code.ToString(); } else { // txtCode.Text = _fish.Code; MessageBox.Show("添加失败。"); } }
public bool Update(FishEntity.ContractProcessingSheetEntity model) { return(dal.Update(model)); }
public int Add(FishEntity.ContractProcessingSheetEntity model) { return(dal.Add(model)); }