public string Insert(NM_BILL_NoMaster nm_BILL_NoMaster)
{
DbCommand cmd = _dataBaseAccess.CreateCommand();
cmd.CommandText = "Proc_NM_BILL_NoMaster_Insert";
ParameterAdd(ref cmd, nm_BILL_NoMaster);
_dataBaseAccess.ExecuteCommand(cmd);
return cmd.Parameters["@Result"].Value.ToString();
}
private void ParameterAdd(ref DbCommand cmd, NM_BILL_NoMaster nm_BILL_NoMaster)
{
if (nm_BILL_NoMaster.BusinessDate.Length!=6)
{
throw new Exception("年月必须6位");
}
if (nm_BILL_NoMaster.Mobile.Length <1 || nm_BILL_NoMaster.Mobile.Length > 14)
{
throw new Exception("号码需在1-14个字符之间!");
}
if (nm_BILL_NoMaster.BillSubjectId.Length < 1 || nm_BILL_NoMaster.BillSubjectId.Length > 20)
{
throw new Exception("账单科目长度需在1-20个字符之间!");
}
decimal money = 0;
if(!decimal.TryParse(nm_BILL_NoMaster.Money, out money))
{
throw new Exception("请输入有效金额!");
}
if (nm_BILL_NoMaster.Reason.Length >50)
{
throw new Exception("无主原因长度需小于50个字符!");
}
if (nm_BILL_NoMaster.BillFile.Length > 50)
{
throw new Exception("帐单文件长度需小于50个字符!");
}
DbParameter param = _dataBaseAccess.CreateParameter();
param.ParameterName = "@BusinessDate";
param.DbType = DbType.Int32;
param.Value = nm_BILL_NoMaster.BusinessDate;
cmd.Parameters.Add(param);
param = _dataBaseAccess.CreateParameter();
param.ParameterName = "@Mobile";
param.DbType = DbType.String;
param.Value = nm_BILL_NoMaster.Mobile;
cmd.Parameters.Add(param);
param = _dataBaseAccess.CreateParameter();
param.ParameterName = "@BillSubjectId";
param.DbType = DbType.Int64;
param.Value = nm_BILL_NoMaster.BillSubjectId;
cmd.Parameters.Add(param);
param = _dataBaseAccess.CreateParameter();
param.ParameterName = "@Money";
param.DbType = DbType.Decimal;
param.Value = money;
cmd.Parameters.Add(param);
param = _dataBaseAccess.CreateParameter();
param.ParameterName = "@Reason";
param.DbType = DbType.String;
param.Value = nm_BILL_NoMaster.Reason;
cmd.Parameters.Add(param);
param = _dataBaseAccess.CreateParameter();
param.ParameterName = "@BillFile";
param.DbType = DbType.String;
param.Value = nm_BILL_NoMaster.BillFile;
cmd.Parameters.Add(param);
param = _dataBaseAccess.CreateParameter();
param.ParameterName = "@Result";
param.DbType = DbType.String;
param.Size = 50;
param.Direction = ParameterDirection.Output;
cmd.Parameters.Add(param);
}
public ActionResult Insert(NM_BILL_NoMaster nm_BILL_NoMaster)
{
try
{
NoMasterInfoFilterNull(ref nm_BILL_NoMaster);
result = bll_NoMaster.Insert(nm_BILL_NoMaster);
if (string.IsNullOrEmpty(result))
{
resultJSON = Tools.ExecResultToJSON(true, "添加成功！");
}
else
{
resultJSON = Tools.ExecResultToJSON(false, result);
}
return Content(resultJSON);
}
catch (Exception ex)
{
Tools.LogWrite(ex.ToString());
resultJSON = Tools.ExecResultToJSON(false, ex.Message);
return Content(resultJSON);
}
}
public string Update(NM_BILL_NoMaster nm_BILL_NoMaster)
{
DbCommand cmd = _dataBaseAccess.CreateCommand();
cmd.CommandText = "Proc_NM_BILL_NoMaster_Update";
ParameterAdd(ref cmd, nm_BILL_NoMaster);
DbParameter param = _dataBaseAccess.CreateParameter();
param.ParameterName = "@Id";
param.DbType = DbType.String;
param.Value = nm_BILL_NoMaster.Id;
cmd.Parameters.Add(param);
_dataBaseAccess.ExecuteCommand(cmd);
return cmd.Parameters["@Result"].Value.ToString();
}
private void NoMasterInfoFilterNull(ref NM_BILL_NoMaster nm_BILL_NoMaster)
{
if (nm_BILL_NoMaster.BusinessDate == null)
{
nm_BILL_NoMaster.BusinessDate = string.Empty;
}
if (nm_BILL_NoMaster.Mobile == null)
{
nm_BILL_NoMaster.Mobile = string.Empty;
}
if (nm_BILL_NoMaster.BillSubjectId == null)
{
nm_BILL_NoMaster.BillSubjectId = string.Empty;
}
if (nm_BILL_NoMaster.Money == null)
{
nm_BILL_NoMaster.Money = string.Empty;
}
if (nm_BILL_NoMaster.Reason == null)
{
nm_BILL_NoMaster.Reason = string.Empty;
}
if (nm_BILL_NoMaster.BillFile == null)
{
nm_BILL_NoMaster.BillFile = string.Empty;
}
}
