public int Add(FishEntity.SampleSingleEntity model) { StringBuilder Strsql = new StringBuilder(); Strsql.Append("insert into t_samplesingle(code,ferryName,BillOfLadingNumber,PileAngle,tdate,createtime,createman,modifytime,modifyman)"); Strsql.Append("values (@code,@ferryName,@BillOfLadingNumber,@PileAngle,@tdate,@createtime,@createman,@modifytime,@modifyman);"); Strsql.Append("select last_insert_id();"); MySqlParameter[] parameters = { new MySqlParameter("@code", MySqlDbType.VarChar, 45), new MySqlParameter("@ferryName", MySqlDbType.VarChar, 45), new MySqlParameter("@BillOfLadingNumber", MySqlDbType.VarChar, 45), new MySqlParameter("@PileAngle", MySqlDbType.VarChar, 45), new MySqlParameter("@tdate", MySqlDbType.DateTime), 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.FerryName; parameters[2].Value = model.BillOfLadingNumber; parameters[3].Value = model.PileAngle; parameters[4].Value = model.Tdate; 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); //MySqlHelper.ExecuteSql(strSql.ToString(), parameters); return(id); }
public override int Query() { panel1.Enabled = true; if (_Form == null) { _Form = new UIForms.FormSampleSingleCodition(); _Form.StartPosition = FormStartPosition.CenterParent; _Form.ShowInTaskbar = false; } if (_Form.ShowDialog() != System.Windows.Forms.DialogResult.OK) { return(0); } _where = _Form.GetWhereCondition; List <FishEntity.SampleSingleEntity> list = _bll.GetModelListVo(_where + _rolewhere + _orderBy); if (list == null || list.Count < 1) { _fish = null; return(1); } else { _fish = list[0]; SetOnepound(); } return(1); }
public List <FishEntity.SampleSingleEntity> GetModelListVo(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from t_SampleSingle "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } DataSet ds = MySqlHelper.Query(strSql.ToString()); List <FishEntity.SampleSingleEntity> modelList = new List <FishEntity.SampleSingleEntity>(); int rowsCount = ds.Tables[0].Rows.Count; FishEntity.SampleSingleEntity model; for (int n = 0; n < rowsCount; n++) { DataRow row = ds.Tables[0].Rows[n]; model = new FishEntity.SampleSingleEntity(); if (row["id"].ToString() != "") { model.Id = int.Parse(row["id"].ToString()); } if (row["code"] != null && row["code"].ToString() != "") { model.Code = row["code"].ToString(); } if (row["ferryName"] != null && row["ferryName"].ToString() != "") { model.FerryName = row["ferryName"].ToString(); } if (row["BillOfLadingNumber"] != null && row["BillOfLadingNumber"].ToString() != "") { model.BillOfLadingNumber = row["BillOfLadingNumber"].ToString(); } if (row["PileAngle"].ToString() != "" && row["PileAngle"] != null) { model.PileAngle = row["PileAngle"].ToString(); } if (row["tdate"] != null && row["tdate"].ToString() != "") { model.Tdate = DateTime.Parse(row["tdate"].ToString()); } modelList.Add(model); } return(modelList); }
public bool Update(FishEntity.SampleSingleEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update t_samplesingle set "); strSql.Append("code = @code,"); strSql.Append("ferryName = @ferryName,"); strSql.Append("BillOfLadingNumber = @BillOfLadingNumber,"); strSql.Append("PileAngle = @PileAngle,"); strSql.Append("tdate = @tdate,"); strSql.Append("modifytime = @modifytime,"); strSql.Append("modifyman = @modifyman "); strSql.Append("where id = @id"); MySqlParameter[] parameters = { new MySqlParameter("@code", MySqlDbType.VarChar, 45), new MySqlParameter("@ferryName", MySqlDbType.VarChar, 45), new MySqlParameter("@BillOfLadingNumber", MySqlDbType.VarChar, 45), new MySqlParameter("@PileAngle", MySqlDbType.VarChar, 45), new MySqlParameter("@tdate", MySqlDbType.DateTime), 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.FerryName; parameters[2].Value = model.BillOfLadingNumber; parameters[3].Value = model.PileAngle; parameters[4].Value = model.Tdate; 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.SampleSingleEntity _fish = new FishEntity.SampleSingleEntity(); _fish.Code = FishBll.Bll.SequenceUtil.GetSampleSingleSequence(); _fish.FerryName = txtferryName.Text.Trim(); _fish.BillOfLadingNumber = txtBillOfLadingNumber.Text.Trim(); _fish.PileAngle = txtPileAngle.Text.Trim(); _fish.Tdate = dtptdate.Value; _fish.Createtime = DateTime.Now; _fish.Createman = FishEntity.Variable.User.username; _fish.Modifytime = DateTime.Now; _fish.Modifyman = FishEntity.Variable.User.username; FishBll.Bll.SampleSingleBll bll = new FishBll.Bll.SampleSingleBll(); bool isok = bll.Exists(_fish.Code); while (isok) { _fish.Code = FishBll.Bll.SequenceUtil.GetSampleSingleSequence(); 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.SampleSingleEntity model) { return(dal.Update(model)); }
public int Add(FishEntity.SampleSingleEntity model) { return(dal.Add(model)); }