/// <summary>
/// 添加存取款单信息
/// </summary>
/// <param name="model">存取款单实体</param>
/// <param name="IntID">返回添加后的主键ID</param>
/// <returns>true 成功,false失败</returns>
public static bool InsertStoreFetchBill(StoreFetchBillModel model, out int IntID)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("Insert into officedba.StoreFetchBill");
sql.AppendLine("(CompanyCD,SFNo,SFBillNum,SFDate,");
sql.AppendLine("Executor,BankName,AccountNo,");
sql.AppendLine("Type,TotalPrice,ModifiedDate,ModifiedUserID,");
sql.AppendLine("Summary,CurrencyType,CurrencyRate)values(@CompanyCD,@SFNo,@SFBillNum,");
sql.AppendLine("getdate(),@Executor,@BankName,@AccountNo,");
sql.AppendLine("@Type,@TotalPrice,getdate(),@ModifiedUserID,@Summary,@CurrencyType,@CurrencyRate)");
sql.AppendLine("set @IntID= @@IDENTITY");
SqlParameter[] parms = new SqlParameter[13];
parms[0] = SqlHelper.GetParameter("@CompanyCD", model.CompanyCD);
parms[1] = SqlHelper.GetParameter("@SFNo", model.SFNo);
parms[2] = SqlHelper.GetParameter("@SFBillNum", model.SFBillNum);
parms[3] = SqlHelper.GetParameter("@Executor", model.Executor);
parms[4] = SqlHelper.GetParameter("@BankName", model.BankName);
parms[5] = SqlHelper.GetParameter("@AccountNo", model.AccountNo);
parms[6] = SqlHelper.GetParameter("@Type", model.Type);
parms[7] = SqlHelper.GetParameter("@TotalPrice", model.TotalPrice);
parms[8] = SqlHelper.GetParameter("@ModifiedUserID", model.ModifiedUserID);
parms[9] = SqlHelper.GetParameter("@Summary", model.Summary);
parms[10] = SqlHelper.GetParameter("@CurrencyType", model.CurrencyType);
parms[11] = SqlHelper.GetParameter("@CurrencyRate", model.CurrencyRate);
parms[12] = SqlHelper.GetOutputParameter("@IntID", SqlDbType.Int);
SqlHelper.ExecuteTransSql(sql.ToString(), parms);
IntID = Convert.ToInt32(parms[12].Value);
return SqlHelper.Result.OprateCount > 0 ? true : false;
}
/// <summary>
/// 修改存取款单信息
/// </summary>
/// <param name="model">存取款单实体</param>
/// <returns>true 成功,false失败</returns>
public static bool UpdateStoreFetchBill(StoreFetchBillModel model)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("Update officedba.StoreFetchBill ");
sql.AppendLine("set SFBillNum=@SFBillNum,SFDate=@SFDate,");
sql.AppendLine("Executor=@Executor,BankName=@BankName,");
sql.AppendLine("AccountNo=@AccountNo,Type=@Type,");
sql.AppendLine("TotalPrice=@TotalPrice,ModifiedDate=getdate(),ModifiedUserID=@ModifiedUserID,");
sql.AppendLine("Summary=@Summary,CurrencyType=@CurrencyType,CurrencyRate=@CurrencyRate where ID=@ID");
SqlParameter[] parms = new SqlParameter[12];
parms[0] = SqlHelper.GetParameter("@SFBillNum", model.SFBillNum);
parms[1] = SqlHelper.GetParameter("@SFDate", model.SFDate);
parms[2] = SqlHelper.GetParameter("@Executor", model.Executor);
parms[3] = SqlHelper.GetParameter("@BankName", model.BankName);
parms[4] = SqlHelper.GetParameter("@AccountNo", model.AccountNo);
parms[5] = SqlHelper.GetParameter("@Type", model.Type);
parms[6] = SqlHelper.GetParameter("@TotalPrice", model.TotalPrice);
parms[7] = SqlHelper.GetParameter("@ModifiedUserID", model.ModifiedUserID);
parms[8] = SqlHelper.GetParameter("@Summary", model.Summary);
parms[9] = SqlHelper.GetParameter("@CurrencyType", model.CurrencyType);
parms[10] = SqlHelper.GetParameter("@CurrencyRate", model.CurrencyRate);
parms[11] = SqlHelper.GetParameter("@ID", model.ID);
SqlHelper.ExecuteTransSql(sql.ToString(), parms);
return SqlHelper.Result.OprateCount > 0 ? true : false;
}
/// <summary>
/// 修改存取款单信息
/// </summary>
/// <param name="model">存取款单实体</param>
/// <returns>true 成功,false失败</returns>
public static bool UpdateStoreFetchBill(StoreFetchBillModel model)
{
model.ModifiedUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID;
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
try
{
bool succ = false;
string loginUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID;
LogInfoModel logModel = InitLogInfo(model.SFNo, 0);
logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
succ = StoreFetchBillDBHelper.UpdateStoreFetchBill(model);
if (!succ)
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
else
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
LogDBHelper.InsertLog(logModel);
return succ;
}
catch (Exception ex)
{
WriteSystemLog(userInfo, 0, ex);
return false;
}
}
