public int UpdateMeasureWay(MeasureWayEntity me) { StringBuilder sb = new StringBuilder("update dbo.MeasureWay set"); sb.AppendFormat(" Mwa_Remark='{0}', ", me.MwaRemark); sb.AppendFormat(" Mwa_IfUse={0} ", me.MwaIfUse == true ? 1 : 0); sb.AppendFormat(" where Mwa_Id={0}", me.MwaId); return(SqlDataHelper.ExecuteNonQuery(SqlDataHelper.GetConnection(), CommandType.Text, sb.ToString())); }
public int InsertMeasureWay(MeasureWayEntity me) { StringBuilder sb = new StringBuilder("insert into MeasureWay(Mwa_Name,Mwa_Remark,Mwa_IfUse) values("); sb.AppendFormat(" '{0}',", me.MwaName); sb.AppendFormat(" '{0}',", me.MwaRemark); sb.AppendFormat(" '{0}')", me.MwaIfUse == true ? 1 : 0); return(SqlDataHelper.ExecuteNonQuery(SqlDataHelper.GetConnection(), CommandType.Text, sb.ToString())); }
public void BtnMeasureSave(object sender, EventArgs e) { MeasureWayEntity mwe = new MeasureWayEntity() { MwaName = this.View.TxtMeasureName.Text, MwaRemark = this.View.TxtMeasureRemark.Text, MwaIfUse = this.View.CboMeasureIfUse.Checked }; if (this.View.TxtMeasureId.Text != null && this.View.TxtMeasureId.Text != "") { mwe.MwaId = Convert.ToInt32(this.View.TxtMeasureId.Text); string jsonresult = MyBaseMessageService.EditMeasureWay(mwe); FeedbackInfomation fi = JsonConvert.DeserializeObject <FeedbackInfomation>(jsonresult); if (fi.ErrorStatus == STATUS_ADAPTER.SAVE_SUCCESS) { LoadMeasureWayData(); this.View.DgvMeasure.Rows[measureRowIndex].Selected = true; MsgBox.ShowDialog(fi.FeedbackMessage, "信息提示"); } else { MsgBox.ShowDialog(fi.FeedbackMessage, "信息提示", MsgBox.MyButtons.OKCancel, true); } } else { string result = CheckMeasureName(mwe.MwaName); if (result == "正确") { string jsonresult = MyBaseMessageService.AddMeasureWay(mwe); FeedbackInfomation fi = JsonConvert.DeserializeObject <FeedbackInfomation>(jsonresult); if (fi.ErrorStatus == STATUS_ADAPTER.INSERT_NORMAL) { LoadMeasureWayData(); this.View.DgvMeasure.Rows[this.View.DgvMeasure.Rows.Count - 1].Selected = true; MsgBox.ShowDialog(fi.FeedbackMessage, "信息提示"); } else { MsgBox.ShowDialog(fi.FeedbackMessage, "信息提示", MsgBox.MyButtons.OKCancel, true); } } else { MsgBox.ShowDialog(result, "信息提示", MsgBox.MyButtons.OKCancel, true); } } this.View.TxtMeasureName.Enabled = false; this.View.TxtMeasureRemark.Enabled = false; this.View.CboMeasureIfUse.Enabled = false; this.View.BtnMeasureSave.Enabled = false; this.View.BtnMeasureAdd.Enabled = true; }
public MeasureWayEntity DsToMeasureWayEntity(DataSet ds) { MeasureWayEntity me = new MeasureWayEntity(); if (DataValidate.CheckDataSetNotEmpty(ds)) { var dr = ds.Tables[0].Rows[0]; me.MwaId = Convert.ToInt32(dr["Mwa_Id"]); me.MwaName = dr["Mwa_Name"].ToString(); me.MwaRemark = dr["Mwa_Remark"].ToString(); me.MwaIfUse = Convert.ToBoolean(Convert.IsDBNull(dr["Mwa_IfUse"]) == true ? false : dr["Mwa_IfUse"]); me.MwaIfUse2 = Convert.ToBoolean(dr["Mwa_IfUse"]) == true ? "是" : "否"; } return(me); }
public List <MeasureWayEntity> DsToMeasureWayEntityList(DataSet ds) { List <MeasureWayEntity> mes = new List <MeasureWayEntity>(); if (DataValidate.CheckDataSetNotEmpty(ds)) { foreach (DataRow dr in ds.Tables[0].Rows) { MeasureWayEntity me = new MeasureWayEntity(); me.MwaId = Convert.ToInt32(dr["Mwa_Id"]); me.MwaName = dr["Mwa_Name"].ToString(); me.MwaRemark = dr["Mwa_Remark"].ToString(); me.MwaIfUse = Convert.ToBoolean(Convert.IsDBNull(dr["Mwa_IfUse"]) == true ? false : dr["Mwa_IfUse"]); me.MwaIfUse2 = Convert.ToBoolean(dr["Mwa_IfUse"]) == true ? "是" : "否"; mes.Add(me); } } return(mes); }
public FeedbackInfomation EditMeasureWay(MeasureWayEntity me) { FeedbackInfomation fi = new FeedbackInfomation(); try { fi.Result = MyBaseMessageDAL.UpdateMeasureWay(me); fi.ErrorStatus = STATUS_ADAPTER.SAVE_SUCCESS; fi.FeedbackMessage = "修改成功"; return(fi); } catch (Exception ex) { fi.Result = ""; fi.ErrorStatus = STATUS_ADAPTER.SAVE_FAILED; fi.FeedbackMessage = ex.Message.ToString(); return(fi); } }
public FeedbackInfomation AddMeasureWay(MeasureWayEntity me) { FeedbackInfomation fi = new FeedbackInfomation(); try { fi.Result = MyBaseMessageDAL.InsertMeasureWay(me); fi.ErrorStatus = STATUS_ADAPTER.INSERT_NORMAL; fi.FeedbackMessage = "新增成功"; return(fi); } catch (Exception ex) { fi.Result = ""; fi.ErrorStatus = STATUS_ADAPTER.INSERT_ERROR; fi.FeedbackMessage = ex.Message.ToString(); return(fi); } }
public string EditMeasureWay(MeasureWayEntity me) { return(JsonConvert.SerializeObject(MyBaseMessageBll.EditMeasureWay(me))); }