public int UpdateDepotsProperty(DepotsPropertyEntity de) { StringBuilder sb = new StringBuilder("update dbo.DepotsProperty set"); sb.AppendFormat(" Dpr_Remark='{0}', ", de.DprRemark); sb.AppendFormat(" Dpr_IfUse={0} ", de.DprIfUse == true ? 1 : 0); sb.AppendFormat(" where Dpr_Id={0}", de.DprId); return(SqlDataHelper.ExecuteNonQuery(SqlDataHelper.GetConnection(), CommandType.Text, sb.ToString())); }
public int InsertDepotsProperty(DepotsPropertyEntity de) { StringBuilder sb = new StringBuilder("insert into DepotsProperty(Dpr_Name,Dpr_Remark,Dpr_IfUse) values("); sb.AppendFormat(" '{0}',", de.DprName); sb.AppendFormat(" '{0}',", de.DprRemark); sb.AppendFormat(" '{0}')", de.DprIfUse == true ? 1 : 0); return(SqlDataHelper.ExecuteNonQuery(SqlDataHelper.GetConnection(), CommandType.Text, sb.ToString())); }
public void BtnDepotsSave(object sender, EventArgs e) { DepotsPropertyEntity dpe = new DepotsPropertyEntity() { DprName = this.View.TxtDepotsName.Text, DprRemark = this.View.TxtDepotsRemark.Text, DprIfUse = this.View.CboDepotsIfUse.Checked }; if (this.View.TxtDepotsId.Text != null && this.View.TxtDepotsId.Text != "") { dpe.DprId = Convert.ToInt32(this.View.TxtDepotsId.Text); string jsonresult = MyBaseMessageService.EditDepotsProperty(dpe); FeedbackInfomation fi = JsonConvert.DeserializeObject <FeedbackInfomation>(jsonresult); if (fi.ErrorStatus == STATUS_ADAPTER.SAVE_SUCCESS) { LoadDepotsPropertyData(); this.View.DgvDepots.Rows[depotsRowIndex].Selected = true; MsgBox.ShowDialog(fi.FeedbackMessage, "信息提示"); } else { MsgBox.ShowDialog(fi.FeedbackMessage, "信息提示", MsgBox.MyButtons.OKCancel, true); } } else { string result = CheckDepotsName(dpe.DprName); if (result == "正确") { string jsonresult = MyBaseMessageService.AddDepotsProperty(dpe); FeedbackInfomation fi = JsonConvert.DeserializeObject <FeedbackInfomation>(jsonresult); if (fi.ErrorStatus == STATUS_ADAPTER.INSERT_NORMAL) { LoadDepotsPropertyData(); this.View.DgvDepots.Rows[this.View.DgvDepots.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.TxtDepotsName.Enabled = false; this.View.TxtDepotsRemark.Enabled = false; this.View.CboDepotsIfUse.Enabled = false; this.View.BtnDepotsSave.Enabled = false; this.View.BtnDepotsAdd.Enabled = true; }
public DepotsPropertyEntity DsToDepotsPropertyEntity(DataSet ds) { DepotsPropertyEntity de = new DepotsPropertyEntity(); if (DataValidate.CheckDataSetNotEmpty(ds)) { var dr = ds.Tables[0].Rows[0]; de.DprId = Convert.ToInt32(dr["Dpr_Id"]); de.DprName = dr["Dpr_Name"].ToString(); de.DprRemark = dr["Dpr_Remark"].ToString(); de.DprIfUse = Convert.ToBoolean(Convert.IsDBNull(dr["Dpr_IfUse"]) == true ? false : dr["Dpr_IfUse"]); de.DprIfUse2 = Convert.ToBoolean(dr["Dpr_IfUse"]) == true ? "是" : "否"; } return(de); }
public List <DepotsPropertyEntity> DsToDepotsPropertyEntityList(DataSet ds) { List <DepotsPropertyEntity> des = new List <DepotsPropertyEntity>(); if (DataValidate.CheckDataSetNotEmpty(ds)) { foreach (DataRow dr in ds.Tables[0].Rows) { DepotsPropertyEntity de = new DepotsPropertyEntity(); de.DprId = Convert.ToInt32(dr["Dpr_Id"]); de.DprName = dr["Dpr_Name"].ToString(); de.DprRemark = dr["Dpr_Remark"].ToString(); de.DprIfUse = Convert.ToBoolean(Convert.IsDBNull(dr["Dpr_IfUse"]) == true ? false : dr["Dpr_IfUse"]); de.DprIfUse2 = Convert.ToBoolean(dr["Dpr_IfUse"]) == true ? "是" : "否"; des.Add(de); } } return(des); }
public FeedbackInfomation EditDepotsProperty(DepotsPropertyEntity de) { FeedbackInfomation fi = new FeedbackInfomation(); try { fi.Result = MyBaseMessageDAL.UpdateDepotsProperty(de); 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 AddDepotsProperty(DepotsPropertyEntity de) { FeedbackInfomation fi = new FeedbackInfomation(); try { fi.Result = MyBaseMessageDAL.InsertDepotsProperty(de); 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 EditDepotsProperty(DepotsPropertyEntity de) { return(JsonConvert.SerializeObject(MyBaseMessageBll.EditDepotsProperty(de))); }