/// <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; } }