public int InsertRateType(RateTypeEntity rte)
{
StringBuilder sb = new StringBuilder("insert into RateType(Rty_Name,Rty_Remark,Rty_IfUse) values(");
sb.AppendFormat(" '{0}',", rte.RtyName);
sb.AppendFormat(" '{0}',", rte.RtyRemark);
sb.AppendFormat(" '{0}')", rte.RtyIfUse == true ? 1 : 0);
return(SqlDataHelper.ExecuteNonQuery(SqlDataHelper.GetConnection(), CommandType.Text, sb.ToString()));
}
public int UpdateRateType(RateTypeEntity rte)
{
StringBuilder sb = new StringBuilder("update dbo.RateType set");
sb.AppendFormat(" Rty_Remark='{0}', ", rte.RtyRemark);
sb.AppendFormat(" Rty_IfUse={0} ", rte.RtyIfUse == true ? 1 : 0);
sb.AppendFormat(" where Rty_Id={0}", rte.RtyId);
return(SqlDataHelper.ExecuteNonQuery(SqlDataHelper.GetConnection(), CommandType.Text, sb.ToString()));
}
public void BtnRateTypeSave(object sender, EventArgs e)
{
RateTypeEntity rte = new RateTypeEntity()
{
RtyName = this.View.TxtRateTypeName.Text,
RtyRemark = this.View.TxtRateTypeRemark.Text,
RtyIfUse = this.View.CboRateTypeIfUse.Checked
};
if (this.View.TxtRateTypeId.Text != null && this.View.TxtRateTypeId.Text != "")
{
rte.RtyId = Convert.ToInt32(this.View.TxtRateTypeId.Text);
string jsonresult = MyBaseMessageService.EditRateType(rte);
FeedbackInfomation fi = JsonConvert.DeserializeObject <FeedbackInfomation>(jsonresult);
if (fi.ErrorStatus == STATUS_ADAPTER.SAVE_SUCCESS)
{
LoadRateTypeData();
this.View.DgvRateType.Rows[rateTypeRowIndex].Selected = true;
MsgBox.ShowDialog(fi.FeedbackMessage, "信息提示");
}
else
{
MsgBox.ShowDialog(fi.FeedbackMessage, "信息提示", MsgBox.MyButtons.OKCancel, true);
}
}
else
{
string result = CheckRateTypeName(rte.RtyName);
if (result == "正确")
{
string jsonresult = MyBaseMessageService.AddRateType(rte);
FeedbackInfomation fi = JsonConvert.DeserializeObject <FeedbackInfomation>(jsonresult);
if (fi.ErrorStatus == STATUS_ADAPTER.INSERT_NORMAL)
{
LoadRateTypeData();
this.View.DgvRateType.Rows[this.View.DgvRateType.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.TxtRateTypeName.Enabled = false;
this.View.TxtRateTypeRemark.Enabled = false;
this.View.CboRateTypeIfUse.Enabled = false;
this.View.BtnRateTypeSave.Enabled = false;
this.View.BtnRateTypeAdd.Enabled = true;
}
public RateTypeEntity DsToRateTypeEntity(DataSet ds)
{
RateTypeEntity rte = new RateTypeEntity();
if (DataValidate.CheckDataSetNotEmpty(ds))
{
var dr = ds.Tables[0].Rows[0];
rte.RtyId = Convert.ToInt32(dr["Rty_Id"]);
rte.RtyName = dr["Rty_Name"].ToString();
rte.RtyRemark = dr["Rty_Remark"].ToString();
rte.RtyIfUse = Convert.ToBoolean(Convert.IsDBNull(dr["Rty_IfUse"]) == true ? false : dr["Rty_IfUse"]);
rte.RtyIfUse2 = Convert.ToBoolean(dr["Rty_IfUse"]) == true ? "是" : "否";
}
return(rte);
}
public List <RateTypeEntity> DsToRateTypeEntityList(DataSet ds)
{
List <RateTypeEntity> rtes = new List <RateTypeEntity>();
if (DataValidate.CheckDataSetNotEmpty(ds))
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
RateTypeEntity rte = new RateTypeEntity();
rte.RtyId = Convert.ToInt32(dr["Rty_Id"]);
rte.RtyName = dr["Rty_Name"].ToString();
rte.RtyRemark = dr["Rty_Remark"].ToString();
rte.RtyIfUse = Convert.ToBoolean(Convert.IsDBNull(dr["Rty_IfUse"]) == true ? false : dr["Rty_IfUse"]);
rte.RtyIfUse2 = Convert.ToBoolean(dr["Rty_IfUse"]) == true ? "是" : "否";
rtes.Add(rte);
}
}
return(rtes);
}
public FeedbackInfomation EditRateType(RateTypeEntity rte)
{
FeedbackInfomation fi = new FeedbackInfomation();
try
{
fi.Result = MyBaseMessageDAL.UpdateRateType(rte);
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 AddRateType(RateTypeEntity rte)
{
FeedbackInfomation fi = new FeedbackInfomation();
try
{
fi.Result = MyBaseMessageDAL.InsertRateType(rte);
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 EditRateType(RateTypeEntity rte)
{
return(JsonConvert.SerializeObject(MyBaseMessageBll.EditRateType(rte)));
}
public static RateTypeDto ToRateTypeDto(this RateTypeEntity request) => new RateTypeDto
{
RateTypeCode = request.RateTypeCode,
RateTypeName = request.RateTypeName
};
