/// <summary> /// 添加付款单信息 /// </summary> /// <param name="Model"></param> /// <param name="ID"></param> /// <returns></returns> public static bool InSertIntoPayBillInfo(PayBillModel model, out int IntID) { StringBuilder sql = new StringBuilder(); sql.AppendLine("insert into Officedba.PayBill ( "); sql.AppendLine(" BillingID,CompanyCD,CreatDate,PayNo, "); sql.AppendLine("CustName,PayAmount,PayDate,AcceWay,Executor, "); sql.AppendLine(" BankName,BankNo,ConfirmStatus,IsAccount,Remark,BlendingType,CurrencyType,CurrencyRate,CustID,FromTBName,FileName,ProjectID ) "); sql.AppendLine(" values ( @BillingID,@CompanyCD,@CreatDate,@PayNo,"); sql.AppendLine("@CustName,@PayAmount,@PayDate,@AcceWay,@Executor, "); sql.AppendLine(" @BankName,@BankNo,@ConfirmStatus,@IsAccout,@Remark,@BlendingType,@CurrencyType,@CurrencyRate,@CustID,@FromTBName,@FileName,@ProjectID ) "); sql.AppendLine("set @IntID= @@IDENTITY"); SqlCommand comm = new SqlCommand(); comm.CommandText = sql.ToString(); comm.Parameters.AddWithValue("@BillingID", SqlDbType.Int).Value = model.BillingID; comm.Parameters.AddWithValue("@CompanyCD", SqlDbType.VarChar).Value = model.CompanyCD; comm.Parameters.AddWithValue("@CreatDate", SqlDbType.DateTime).Value = model.CreatDate; comm.Parameters.AddWithValue("@PayNo", SqlDbType.VarChar).Value = model.PayNo; comm.Parameters.AddWithValue("@CustName", SqlDbType.VarChar).Value = model.CustName; comm.Parameters.AddWithValue("@PayAmount", SqlDbType.Decimal).Value = model.PayAmount; comm.Parameters.AddWithValue("@PayDate", SqlDbType.DateTime).Value = model.PayDate; comm.Parameters.AddWithValue("@AcceWay", SqlDbType.Char).Value = model.AcceWay; comm.Parameters.AddWithValue("@Executor", SqlDbType.Int).Value = model.Executor; comm.Parameters.AddWithValue("@BankName", SqlDbType.VarChar).Value = model.BankName; comm.Parameters.AddWithValue("@BankNo", SqlDbType.VarChar).Value = model.BankNo; comm.Parameters.AddWithValue("@ConfirmStatus", SqlDbType.Char).Value = model.ConfirmStatus; comm.Parameters.AddWithValue("@IsAccout", SqlDbType.Char).Value = model.IsAccout; comm.Parameters.AddWithValue("@Remark", SqlDbType.VarChar).Value = model.Remark; comm.Parameters.AddWithValue("@BlendingType", SqlDbType.Char).Value = model.BlendingType; comm.Parameters.AddWithValue("@CurrencyType", SqlDbType.Int).Value = model.CurrencyType; comm.Parameters.AddWithValue("@CurrencyRate", SqlDbType.Decimal).Value = model.CurrencyRate; comm.Parameters.AddWithValue("@CustID", SqlDbType.Int).Value = model.CustID; comm.Parameters.AddWithValue("@FromTBName", SqlDbType.VarChar).Value = model.FromTBName; comm.Parameters.AddWithValue("@FileName", SqlDbType.VarChar).Value = model.FileName; comm.Parameters.AddWithValue("@ProjectID", SqlDbType.Int).Value = model.ProjectID; SqlParameter Ret = new SqlParameter("@IntID", SqlDbType.Int); //定义返回值参数 Ret.Direction = ParameterDirection.Output; comm.Parameters.Add(Ret); ArrayList listCmd = new ArrayList(); listCmd.Add(comm); if (model.BillingID > 0) { UpdateInsertBillingPrice(listCmd, model.BillingID, model.PayAmount); } bool result = SqlHelper.ExecuteTransWithArrayList(listCmd); IntID = Convert.ToInt32(Ret.Value); //bool updateResult=false; //if (result) //{ // updateResult = UpdateStauts(model.BillingID); //} //return (result&&updateResult); return result; }
/// <summary> /// 更新付款单信息 /// </summary> /// <param name="model">实体</param> /// <param name="DiffAmount">本次输入的付款金额与修改前的付款金额之差</param> /// <returns></returns> public static bool UpdatePayBill(PayBillModel model, decimal DiffAmount) { StringBuilder sql = new StringBuilder(); sql.AppendLine("update officedba.PayBill set "); sql.AppendLine("PayNo=@PayNo,CustName=@CustName,PayAmount=@PayAmount,PayDate=@PayDate,AcceWay=@AcceWay, "); sql.AppendLine("Executor=@Executor,BankName=@BankName,BankNo=@BankNo,Remark=@Remark,ModifiedDate=@ModifiedDate,ModifiedUserID=@ModifiedUserID,BlendingType=@BlendingType,CurrencyType=@CurrencyType,CurrencyRate=@CurrencyRate,CustID=@CustID,FromTBName=@FromTBName,FileName=@FileName,ProjectID=@ProjectID "); sql.AppendLine(" where ID=@ID"); SqlCommand comm = new SqlCommand(); comm.CommandText = sql.ToString(); comm.Parameters.AddWithValue("@PayNo", SqlDbType.VarChar).Value = model.PayNo; comm.Parameters.AddWithValue("@CustName", SqlDbType.VarChar).Value = model.CustName; comm.Parameters.AddWithValue("@PayAmount", SqlDbType.Decimal).Value = model.PayAmount; comm.Parameters.AddWithValue("@PayDate", SqlDbType.DateTime).Value = model.PayDate; comm.Parameters.AddWithValue("@AcceWay", SqlDbType.Char).Value = model.AcceWay; comm.Parameters.AddWithValue("@Executor", SqlDbType.Int).Value = model.Executor; comm.Parameters.AddWithValue("@BankName", SqlDbType.VarChar).Value = model.BankName; comm.Parameters.AddWithValue("@BankNo", SqlDbType.VarChar).Value = model.BankNo; comm.Parameters.AddWithValue("@Remark", SqlDbType.VarChar).Value = model.Remark; comm.Parameters.AddWithValue("@ModifiedDate", SqlDbType.DateTime).Value = model.ModifiedDate; comm.Parameters.AddWithValue("@ModifiedUserID", SqlDbType.Int).Value = model.ModifiedUserID; comm.Parameters.AddWithValue("@BlendingType", SqlDbType.Char).Value = model.BlendingType; comm.Parameters.AddWithValue("@CurrencyType", SqlDbType.Int).Value = model.CurrencyType; comm.Parameters.AddWithValue("@CurrencyRate", SqlDbType.Decimal).Value = model.CurrencyRate; comm.Parameters.AddWithValue("@CustID", SqlDbType.Int).Value = model.CustID; comm.Parameters.AddWithValue("@FromTBName", SqlDbType.VarChar).Value = model.FromTBName; comm.Parameters.AddWithValue("@FileName", SqlDbType.VarChar).Value = model.FileName; comm.Parameters.AddWithValue("@ProjectID", SqlDbType.Int).Value = model.ProjectID; comm.Parameters.AddWithValue("@ID", SqlDbType.Int).Value = model.ID; ArrayList listCmd = new ArrayList(); listCmd.Add(comm); if (model.BillingID > 0) { updateUpBillingStatus(listCmd, model.BillingID.ToString(), DiffAmount); } bool result = SqlHelper.ExecuteTransWithArrayList(listCmd); return result; }
/// <summary> /// 添加付款单信息 /// </summary> /// <param name="Model"></param> /// <param name="ID"></param> /// <returns></returns> public static bool InSertIntoPayBillInfo(PayBillModel model, out int IntID) { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; try { bool suuc = PayBillDBHelper.InSertIntoPayBillInfo(model, out IntID); string loginUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID; LogInfoModel logModel = InitLogInfo(IntID.ToString()); logModel.Element = ConstUtil.LOG_PROCESS_INSERT; //设置操作日志类型 修改 logModel.ObjectName = ConstUtil.CODING_RULE_TABLE_PAYBILL; if (suuc) logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS; else logModel.Remark = ConstUtil.LOG_PROCESS_FAILED; LogDBHelper.InsertLog(logModel); LogInfoModel logModell = InitLogInfo(model.BillingID.ToString()); logModell.Element = ConstUtil.LOG_PROCESS_UPDATE; logModell.ObjectName = ConstUtil.CODING_RULE_TABLE_BILLING; if (suuc) logModell.Remark = ConstUtil.LOG_PROCESS_SUCCESS; else logModell.Remark = ConstUtil.LOG_PROCESS_FAILED; LogDBHelper.InsertLog(logModell); return suuc; } catch (Exception ex) { WriteSystemLog(userInfo, ex); throw ex; } }