/// <summary>
/// 根据ID更新审核信息
/// </summary>
/// yangj 16.08.30
/// <param name="value">审核实体</param>
/// <returns></returns>
public int Update(ReviewInfo value)
{
SqlCommand comm = DHelper.GetSqlCommand(@"
UPDATE FANC_ReviewInfo SET
RepaymentDate = @RepaymentDate,
FinanceCost = @FinanceCost,
FinalCost = @FinalCost,
Payment = @Payment,
AdvicefinanceMoney = @AdvicefinanceMoney,
ApprovalPrincipal = @ApprovalPrincipal,
ApprovalFinanceRatio = @ApprovalFinanceRatio,
ReviewType = @ReviewType
WHERE FinanceId = @FinanceId");
DHelper.AddParameter(comm, "@FinanceId", SqlDbType.Int, value.FinanceId);
DHelper.AddParameter(comm, "@AdvicefinanceMoney", SqlDbType.Decimal, value.AdvicefinanceMoney);
DHelper.AddParameter(comm, "@ApprovalPrincipal", SqlDbType.Decimal, value.ApprovalPrincipal);
DHelper.AddParameter(comm, "@ApprovalFinanceRatio", SqlDbType.Float, value.ApprovalFinanceRatio);
DHelper.AddParameter(comm, "@FinanceCost", SqlDbType.Decimal, value.FinanceCost);
DHelper.AddParameter(comm, "@FinalCost", SqlDbType.Decimal, value.FinalCost);
DHelper.AddParameter(comm, "@Payment", SqlDbType.Decimal, value.Payment);
DHelper.AddParameter(comm, "@RepaymentDate", SqlDbType.Int, value.RepaymentDate);
DHelper.AddParameter(comm, "@ReviewType", SqlDbType.TinyInt, value.ReviewType);
return(DHelper.ExecuteNonQuery(comm));
}
/// <summary>
/// 更新[未使用]
/// </summary>
/// qiy 16.03.08
/// <param name="value"></param>
/// <returns></returns>
public bool Update(ActionInfo value)
{
SqlCommand comm = DHelper.GetSqlCommand(@"
UPDATE FLOW_Action SET
Node = @NodeId,
Transfer = @Transfer,
Name = @Name,
Type = @Type,
AllocationType = @AllocationType,
Description = @Description,
Method = @Method
WHERE ActionId = @ActionId
");
DHelper.AddParameter(comm, "@ActionId", SqlDbType.Int, value.ActionId);
DHelper.AddParameter(comm, "@NodeId", SqlDbType.Int, value.NodeId);
DHelper.AddParameter(comm, "@Transfer", SqlDbType.Int, value.Transfer);
DHelper.AddParameter(comm, "@Name", SqlDbType.NVarChar, value.Name);
DHelper.AddParameter(comm, "@Type", SqlDbType.TinyInt, value.AllocationType);
DHelper.AddParameter(comm, "@Description", SqlDbType.NVarChar, value.Description);
DHelper.AddParameter(comm, "@Method", SqlDbType.VarChar, value.Method);
return(DHelper.ExecuteNonQuery(comm) > 0);
}
/// <summary>
/// 更新
/// </summary>
/// qiy 16.03.29
/// <param name="value">值</param>
/// <returns></returns>
public int Update(PartnerInfo value)
{
SqlCommand comm = DHelper.GetSqlCommand(@"
UPDATE CRET_PartnerInfo SET
Bail = @Bail,
Address = @Address,
ProxyArea = @ProxyArea,
VehicleManage = @VehicleManage,
ControllerName = @ControllerName,
ControllerIdentity = @ControllerIdentity,
ControllerTelephone = @ControllerTelephone,
Province=@Province,
City=@City
WHERE CreditId = @CreditId
" );
DHelper.AddParameter(comm, "@CreditId", SqlDbType.Int, value.CreditId);
DHelper.AddParameter(comm, "@Bail", SqlDbType.Decimal, value.Bail);
DHelper.AddParameter(comm, "@Address", SqlDbType.NVarChar, value.Address);
DHelper.AddParameter(comm, "@ProxyArea", SqlDbType.NVarChar, value.ProxyArea);
DHelper.AddParameter(comm, "@VehicleManage", SqlDbType.NVarChar, value.VehicleManage);
DHelper.AddParameter(comm, "@ControllerName", SqlDbType.NVarChar, value.ControllerName);
DHelper.AddParameter(comm, "@ControllerIdentity", SqlDbType.NVarChar, value.ControllerIdentity);
DHelper.AddParameter(comm, "@ControllerTelephone", SqlDbType.NVarChar, value.ControllerTelephone);
DHelper.AddParameter(comm, "@Province", SqlDbType.NVarChar, value.Province);
DHelper.AddParameter(comm, "@City", SqlDbType.NVarChar, value.City);
return(DHelper.ExecuteNonQuery(comm));
}
/// <summary>
/// 更新
/// </summary>
/// qiy 16.03.31
/// qiy 16.05.31
/// yangj 16.07.26 新增融资预估金额字段
/// zouql 16.07.28 新增厂商指导价字段
/// zouql 16.08.04 新增融资实际金额字段
/// <param name="value">值</param>
/// <returns></returns>
public int Update(FinanceInfo value)
{
SqlCommand comm = DHelper.GetSqlCommand(@"
UPDATE FANC_FinanceInfo SET
ProduceId = @ProduceId,
Type = @Type,
IntentionPrincipal = @IntentionPrincipal,
ApprovalValue = @ApprovalValue,
Remarks = @Remarks ,
OncePayMonths=@OncePayMonths,
MarginMoney=@MarginMoney,
PaymonthlyMoney=@PaymonthlyMoney,
OnepayInterestMoney=@OnepayInterestMoney,
ActualcashMoney=@ActualcashMoney
WHERE FinanceId = @FinanceId
" );
DHelper.AddParameter(comm, "@FinanceId", SqlDbType.Int, value.FinanceId);
DHelper.AddParameter(comm, "@ProduceId", SqlDbType.Int, value.ProduceId);
DHelper.AddParameter(comm, "@Type", SqlDbType.TinyInt, value.Type);
// 建议融资金额
DHelper.AddParameter(comm, "@IntentionPrincipal", SqlDbType.Decimal, value.IntentionPrincipal);
DHelper.AddParameter(comm, "@ApprovalValue", SqlDbType.Decimal, value.ApprovalValue);
DHelper.AddParameter(comm, "@Remarks", SqlDbType.NVarChar, value.Remarks);
DHelper.AddParameter(comm, "@OncePayMonths", SqlDbType.Int, value.OncePayMonths);
// 保证金、先付月供金额、一次性付息金额、实际用款金额
DHelper.AddParameter(comm, "@MarginMoney", SqlDbType.Decimal, value.MarginMoney);
DHelper.AddParameter(comm, "@PaymonthlyMoney", SqlDbType.Decimal, value.PaymonthlyMoney);
DHelper.AddParameter(comm, "@OnepayInterestMoney", SqlDbType.Decimal, value.OnepayInterestMoney);
DHelper.AddParameter(comm, "@ActualcashMoney", SqlDbType.Decimal, value.ActualcashMoney);
return(DHelper.ExecuteNonQuery(comm));
}
/// <summary>
/// 根据ApplicantId 删除相对应的附加申请人（担保人、联系人）
/// </summary>
/// cais 16.03.31
/// <param name="applicantId"></param>
/// <returns></returns>
public int Delete(int applicantId)
{
SqlCommand comm = DHelper.GetSqlCommand(@"DELETE FANC_ApplicantInfo WHERE ApplicantId = @ApplicantId");
DHelper.AddParameter(comm, "@ApplicantId", SqlDbType.Int, applicantId);
return(DHelper.ExecuteNonQuery(comm));
}
/// <summary>
/// 根据一个产品ID ，修改对应的产品
/// </summary>
/// cais 16.03.29
/// yangj 16.07.25(新增融资返范围)
/// <param name="produce"></param>
/// <returns></returns>
public int Update(ProduceInfo produce)
{
SqlCommand comm = DHelper.GetSqlCommand(@"
UPDATE PROD_ProduceInfo SET Code=@Code ,
Name=@Name,
InterestRate=@InterestRate,
Rate=@Rate,
RepaymentMethod=@RepaymentMethod,
MinFinancingRatio=@MinFinancingRatio,
MaxFinancingRatio=@MaxFinancingRatio,
FinalRatio=@FinalRatio,
FinancingPeriods=@FinancingPeriods,
RepaymentInterval=@RepaymentInterval,
CustomerBailRatio=@CustomerBailRatio,
CustomerPoundage=@CustomerPoundage,
AddDate=@AddDate,
Remarks=@Remarks,
AdditionalGPSCost=@AdditionalGPSCost,
AdditionalOtherCost=@AdditionalOtherCost,
IsVehiclePrice=@IsVehiclePrice,
IsPurchaseTax=@IsPurchaseTax,
IsBusinessInsurance=@IsBusinessInsurance,
IsTafficCompulsoryInsurance=@IsTafficCompulsoryInsurance,
IsVehicleVesselTax=@IsVehicleVesselTax,
IsExtendedWarrantyInsurance=@IsExtendedWarrantyInsurance,
IsOther=@IsOther
WHERE ProduceId=@ProduceId");
DHelper.AddParameter(comm, "@Code", SqlDbType.NVarChar, produce.Code);
DHelper.AddParameter(comm, "@Name", SqlDbType.NVarChar, produce.Name);
DHelper.AddParameter(comm, "@InterestRate", SqlDbType.Float, (produce.InterestRate) / 12);
DHelper.AddParameter(comm, "@Rate", SqlDbType.Float, (produce.Rate) / 12);
DHelper.AddParameter(comm, "@RepaymentMethod", SqlDbType.Int, produce.RepaymentMethod);
DHelper.AddParameter(comm, "@MinFinancingRatio", SqlDbType.Int, produce.MinFinancingRatio);
DHelper.AddParameter(comm, "@MaxFinancingRatio", SqlDbType.Int, produce.MaxFinancingRatio);
DHelper.AddParameter(comm, "@FinalRatio", SqlDbType.Int, produce.FinalRatio);
DHelper.AddParameter(comm, "@FinancingPeriods", SqlDbType.Int, produce.FinancingPeriods);
DHelper.AddParameter(comm, "@RepaymentInterval", SqlDbType.Int, produce.RepaymentInterval);
DHelper.AddParameter(comm, "@CustomerBailRatio", SqlDbType.Float, produce.CustomerBailRatio);
DHelper.AddParameter(comm, "@CustomerPoundage", SqlDbType.Decimal, produce.CustomerPoundage);
DHelper.AddParameter(comm, "@AddDate", SqlDbType.DateTime, DateTime.Now);
DHelper.AddParameter(comm, "@Remarks", SqlDbType.NVarChar, produce.Remarks);
DHelper.AddParameter(comm, "@AdditionalGPSCost", SqlDbType.Decimal, produce.AdditionalGPSCost);
DHelper.AddParameter(comm, "@AdditionalOtherCost", SqlDbType.Decimal, produce.AdditionalOtherCost);
// 新增融资范围
DHelper.AddParameter(comm, "@IsVehiclePrice", SqlDbType.Bit, produce.IsVehiclePrice);
DHelper.AddParameter(comm, "@IsPurchaseTax", SqlDbType.Bit, produce.IsPurchaseTax);
DHelper.AddParameter(comm, "@IsBusinessInsurance", SqlDbType.Bit, produce.IsBusinessInsurance);
DHelper.AddParameter(comm, "@IsTafficCompulsoryInsurance", SqlDbType.Bit, produce.IsTafficCompulsoryInsurance);
DHelper.AddParameter(comm, "@IsVehicleVesselTax", SqlDbType.Bit, produce.IsVehicleVesselTax);
DHelper.AddParameter(comm, "@IsExtendedWarrantyInsurance", SqlDbType.Bit, produce.IsExtendedWarrantyInsurance);
DHelper.AddParameter(comm, "@IsOther", SqlDbType.Bit, produce.IsOther);
DHelper.AddParameter(comm, "@ProduceId", SqlDbType.Int, produce.ProduceId);
return(DHelper.ExecuteNonQuery(comm));
}
/// <summary>
/// 删除根据reportId
/// </summary>
/// yand 16.10.14
/// <param name="reportId"></param>
/// <returns></returns>
public int DeleteByReportId(int reportId)
{
SqlCommand comm = DHelper.GetSqlCommand(@"
DELETE Bank_TempRecord WHERE ReportID = @ReportID
");
DHelper.AddInParameter(comm, "@ReportID", SqlDbType.Int, reportId);
return(Convert.ToInt32(DHelper.ExecuteNonQuery(comm)));
}
/// <summary>
/// 删除文件信息
/// </summary>
/// yaoy 16.05.25
/// <param name="reportFilesId"></param>
/// <returns></returns>
public int Delete(int reportFilesId)
{
SqlCommand comm = DHelper.GetSqlCommand(@"
DELETE FROM BANK_ReportFiles WHERE FileID = @FileID
");
DHelper.AddInParameter(comm, "@FileID", SqlDbType.Int, reportFilesId);
return(Convert.ToInt32(DHelper.ExecuteNonQuery(comm)));
}
/// <summary>
/// 通过菜单删除
/// </summary>
/// yand 15.11.24
/// qiy 16.03.08
/// <param name="menuId"></param>
/// <returns></returns>
public void DeleteByMenu(int menuId)
{
SqlCommand comm = DHelper.GetSqlCommand(
"DELETE USER_Permissions WHERE MenuId = @MenuId"
);
DHelper.AddParameter(comm, "@MenuId", SqlDbType.Int, menuId);
DHelper.ExecuteNonQuery(comm);
}
/// <summary>
/// 删除
/// </summary>
/// yaoy 16.08.04
/// <param name="userId"></param>
/// <returns></returns>
public int Delete(int userId)
{
SqlCommand comm = DHelper.GetSqlCommand(@"
DELETE FROM CRET_Account WHERE UserId = @UserId
" );
DHelper.AddParameter(comm, "@UserId", SqlDbType.Int, userId);
return(DHelper.ExecuteNonQuery(comm));
}
/// <summary>
/// 通过用户删除
/// </summary>
/// qiy 16.03.09
/// <param name="userId">用户标识</param>
/// <returns></returns>
public void DeleteByUser(int userId)
{
SqlCommand comm = DHelper.GetSqlCommand(
"DELETE USER_Relation WHERE UserId = @UserId"
);
DHelper.AddParameter(comm, "@UserId", SqlDbType.Int, userId);
DHelper.ExecuteNonQuery(comm);
}
/// <summary>
/// 通过授信主体删除
/// </summary>
/// qiy 16.03.30
/// <param name="creditId"></param>
/// <returns></returns>
public void DeleteByCredit(int creditId)
{
SqlCommand comm = DHelper.GetSqlCommand(
"DELETE CRET_BindProduce WHERE CreditId = @CreditId"
);
DHelper.AddParameter(comm, "@CreditId", SqlDbType.Int, creditId);
DHelper.ExecuteNonQuery(comm);
}
/// <summary>
/// 删除文件
/// </summary>
/// cais 16.04.08
/// <param name="referenceId">文件引用id</param>
public void Delete(int referenceId)
{
SqlCommand comm = DHelper.GetSqlCommand(
"DELETE SYS_FileList WHERE ReferenceId=@ReferenceId"
);
DHelper.AddParameter(comm, "@ReferenceId", SqlDbType.Int, referenceId);
DHelper.ExecuteNonQuery(comm);
}
/// <summary>
/// 删除信息记录表
/// </summary>
/// cais 16.05.26
/// <param name="recordID">信息记录表主键</param>
/// <returns></returns>
public int DeleteByRecordId(int recordID)
{
SqlCommand comm = DHelper.GetSqlCommand(@"
DELETE BANK_InformationRecord WHERE RecordID=@RecordID
");
DHelper.AddInParameter(comm, "@RecordID", SqlDbType.Int, recordID);
return(Convert.ToInt32(DHelper.ExecuteNonQuery(comm)));
}
/// <summary>
/// 删除文件
/// </summary>
/// qiy 16.04.05
/// <param name="fileId">文件标识</param>
/// <returns></returns>
public int Delete(int fileId)
{
SqlCommand comm = DHelper.GetSqlCommand(
"DELETE SYS_FileList WHERE FL_ID = @FileId"
);
DHelper.AddParameter(comm, "@FileId", SqlDbType.Int, fileId);
return(DHelper.ExecuteNonQuery(comm));
}
/// <summary>
/// 通过角色删除
/// </summary>
/// yaoy 15.11.26
/// qiy 16.03.08
/// <param name="roleId"></param>
/// <returns></returns>
public void DeleteByRole(int roleId)
{
SqlCommand comm = DHelper.GetSqlCommand(
"DELETE USER_Permissions WHERE RoleId = @RoleId"
);
DHelper.AddParameter(comm, "@RoleId", SqlDbType.Int, roleId);
DHelper.ExecuteNonQuery(comm);
}
/// <summary>
/// 删除
/// </summary>
/// qiy 16.04.11
/// <param name="financeId">融资标识</param>
/// <returns></returns>
public int Delete(int financeId)
{
SqlCommand comm = DHelper.GetSqlCommand(@"
DELETE FANC_VehicleInfo WHERE FinanceId = @FinanceId
" );
DHelper.AddParameter(comm, "@FinanceId", SqlDbType.Int, financeId);
return(DHelper.ExecuteNonQuery(comm));
}
/// <summary>
/// 删除菜单
/// </summary>
/// yand 15.11.24
/// <param name="menuId"></param>
/// <returns></returns>
public void Delete(int menuId)
{
SqlCommand comm = DHelper.GetSqlCommand(
"Delete SYS_Menu WHERE MN_ID = @MenuId"
);
DHelper.AddParameter(comm, "@MenuId", SqlDbType.Int, menuId);
DHelper.ExecuteNonQuery(comm);
}
/// <summary>
/// 更新临时数据
/// </summary>
/// yaoy 16.07.25
/// <param name="instanceId"></param>
/// <param name="data"></param>
/// <returns></returns>
public int ModifyTempData(int instanceId, string data)
{
SqlCommand comm = DHelper.GetSqlCommand(
"UPDATE FLOW_Instance SET InstanceData = @InstanceData WHERE InstanceId = @InstanceId"
);
DHelper.AddParameter(comm, "@InstanceId", SqlDbType.Int, instanceId);
DHelper.AddParameter(comm, "@InstanceData", SqlDbType.NVarChar, data);
return(Convert.ToInt32(DHelper.ExecuteNonQuery(comm)));
}
/// <summary>
/// 更新数据
/// </summary>
/// qiy 16.03.08
/// yand 16.07.25（增加keyXML字段）
/// yaoy 16.07.27 (删除更新InstanceData字段)
/// <param name="instanceId">实例标识</param>
/// <param name="data">数据</param>
/// <param name = "KeyXML">XML数据</param>
public void UpdateData(int instanceId, string KeyXML)
{
SqlCommand comm = DHelper.GetSqlCommand(
"UPDATE FLOW_Instance SET KeyXML = @KeyXML WHERE InstanceId = @InstanceId"
);
DHelper.AddParameter(comm, "@InstanceId", SqlDbType.Int, instanceId);
DHelper.AddParameter(comm, "@KeyXML", SqlDbType.Xml, KeyXML);
DHelper.ExecuteNonQuery(comm);
}
/// <summary>
/// 根据流程实例ID删除最后一次日志记录
/// </summary>
/// yaoy 16.09.13
/// <param name="instanceId"></param>
/// <returns></returns>
public int Delete(int instanceId)
{
SqlCommand comm = DHelper.GetSqlCommand(@"
DELETE FROM FLOW_Log WHERE LogId = (
SELECT TOP(1) LogId FROM FLOW_Log WHERE InstanceId = @InstanceId
ORDER BY LogId DESC)
");
DHelper.AddParameter(comm, "@InstanceId", SqlDbType.Int, instanceId);
return(DHelper.ExecuteNonQuery(comm));
}
/// <summary>
/// 插入
/// </summary>
/// qiy 16.03.30
/// <param name="value">值</param>
public void Insert(AccountInfo value)
{
SqlCommand comm = DHelper.GetSqlCommand(@"
INSERT INTO CRET_Account (UserId, CreditId)
VALUES (@UserId, @CreditId)
" );
DHelper.AddParameter(comm, "@UserId", SqlDbType.Int, value.UserId);
DHelper.AddParameter(comm, "@CreditId", SqlDbType.Int, value.CreditId);
DHelper.ExecuteNonQuery(comm);
}
/// <summary>
/// 删除一条临时数据
/// </summary>
/// yangj 16.09.21
/// <param name="infoTypeId">信息揭露类型标识</param>
/// <param name="reportId">报文标识</param>
/// <param name="userId">用户ID</param>
/// <returns></returns>
public int Delete(int infoTypeId, int reportId, int userId)
{
SqlCommand comm = DHelper.GetSqlCommand(@"
DELETE Bank_TempRecord WHERE BIT_ID = @BIT_ID AND ReportID = @ReportID AND UI_ID = @UI_ID
");
DHelper.AddInParameter(comm, "@BIT_ID", SqlDbType.Int, infoTypeId);
DHelper.AddInParameter(comm, "@ReportID", SqlDbType.Int, reportId);
DHelper.AddInParameter(comm, "@UI_ID", SqlDbType.Int, userId);
return(Convert.ToInt32(DHelper.ExecuteNonQuery(comm)));
}
/// <summary>
/// 更新状态
/// </summary>
/// yand 16.06.14
/// <param name="value"></param>
/// <returns></returns>
public int UpdateState(ReportFilesInfo value)
{
SqlCommand comm = DHelper.GetSqlCommand(@"
UPDATE BANK_ReportFiles SET
ReportState = @ReportState
WHERE FileID = @FileId
");
DHelper.AddInParameter(comm, "@FileId", SqlDbType.Int, value.FileID);
DHelper.AddInParameter(comm, "@ReportState", SqlDbType.Int, value.ReportState);
return(Convert.ToInt32(DHelper.ExecuteNonQuery(comm)));
}
/// <summary>
/// 插入
/// </summary>
/// yaoy 15.12.01
/// qiy 15.12.03
/// <param name="value"></param>
/// <returns></returns>
public void Insert(DictionaryInfo value)
{
SqlCommand comm = DHelper.GetSqlCommand(
"INSERT INTO SYS_DicCommon (Type, Code, Name, Remarks)" +
"VALUES (@Type, @Code, @Name, @Remarks)"
);
DHelper.AddParameter(comm, "@Type", SqlDbType.Int, value.Type);
DHelper.AddParameter(comm, "@Code", SqlDbType.Int, value.Code);
DHelper.AddParameter(comm, "@Name", SqlDbType.NVarChar, value.Name);
DHelper.AddParameter(comm, "@Remarks", SqlDbType.NVarChar, value.Remarks);
DHelper.ExecuteNonQuery(comm);
}
/// <summary>
/// 保存
/// </summary>
/// <param name="value"></param>
/// <returns></returns>
public int UpdateRemarks(ReportFilesInfo value)
{
SqlCommand comm = DHelper.GetSqlCommand(@"
UPDATE BANK_ReportFiles SET
FilesName = @FilesName,
Remarks = @Remarks
WHERE FileID = @FileId
");
DHelper.AddInParameter(comm, "@FileId", SqlDbType.Int, value.FileID);
DHelper.AddInParameter(comm, "@Remarks", SqlDbType.NVarChar, value.Remarks);
DHelper.AddInParameter(comm, "@FilesName", SqlDbType.NVarChar, value.FilesName);
return(Convert.ToInt32(DHelper.ExecuteNonQuery(comm)));
}
/// <summary>
/// 修改
/// </summary>
/// yaoy 16.05.26
/// <param name="value"></param>
/// <returns></returns>
public int Modify(ReportInfo value)
{
SqlCommand comm = DHelper.GetSqlCommand(@"
UPDATE BANK_Reports SET
MessageTypeID = @MessageTypeID,
ReportFileID = @ReportFileID
WHERE ReportID = @ReportId
");
DHelper.AddParameter(comm, "@ReportId", SqlDbType.Int, value.ReportID);
DHelper.AddParameter(comm, "@MessageTypeID", SqlDbType.Int, value.MessageTypeID);
DHelper.AddParameter(comm, "@ReportFileID", SqlDbType.Int, value.ReportFileID);
return(Convert.ToInt32(DHelper.ExecuteNonQuery(comm)));
}
/// <summary>
/// 更新
/// </summary>
/// yangj 16.07.01
/// <param name="value">字典类型实体</param>
/// <returns></returns>
public int Update(DictionaryTypeInfo value)
{
SqlCommand comm = DHelper.GetSqlCommand(@"
UPDATE BANK_DictionaryType SET
Name=@Name,
ParentType=@ParentType
WHERE BDT_ID=@DictionaryTypeId
");
DHelper.AddParameter(comm, "@DictionaryTypeId", SqlDbType.Int, value.DictionaryTypeId);
DHelper.AddParameter(comm, "@Name", SqlDbType.NVarChar, value.Name);
DHelper.AddParameter(comm, "@ParentType", SqlDbType.Int, value.ParentType);
return(Convert.ToInt32(DHelper.ExecuteNonQuery(comm)));
}
/// <summary>
/// 更新
/// zouql 16.09.20
/// </summary>
/// <param name="value">值</param>
/// <returns>结果</returns>
public int Update(RuleTypeInfo value)
{
SqlCommand comm = DHelper.GetSqlCommand(@"
UPDATE BANK_RuleType SET
MoneyType = @MoneyType, TimeType = @TimeType, IntegerType = @IntegerType,
WHERE RuleTypeId = @RuleTypeId
");
DHelper.AddInParameter(comm, "@RuleTypeId", SqlDbType.Int, value.RuleTypeId);
DHelper.AddInParameter(comm, "@MoneyType", SqlDbType.Bit, value.MoneyType);
DHelper.AddInParameter(comm, "@TimeType", SqlDbType.Bit, value.TimeType);
DHelper.AddInParameter(comm, "@IntegerType", SqlDbType.Bit, value.IntegerType);
return(Convert.ToInt32(DHelper.ExecuteNonQuery(comm)));
}
/// <summary>
/// 通过字典代码修改字典代码表
/// </summary>
/// zouql 2016-07-05
/// <param name="dictionaryCode"></param>
/// <returns>修改结果</returns>
public int Modify(DictionaryCodeInfo dictionaryCode)
{
string sqlcmd =
@"UPDATE BANK_DictionaryCode
SET Name=@Name,
ParentCode=@ParentCode
WHERE Code=@Code AND BDT_ID=@BDT_ID";
SqlCommand comm = DHelper.GetSqlCommand(sqlcmd);
DHelper.AddInParameter(comm, "@Code", SqlDbType.NChar, dictionaryCode.Code);
DHelper.AddInParameter(comm, "@Name", SqlDbType.NChar, dictionaryCode.Name);
DHelper.AddInParameter(comm, "@ParentCode", SqlDbType.Int, dictionaryCode.ParentCode);
DHelper.AddInParameter(comm, "@BDT_ID", SqlDbType.Int, dictionaryCode.DictionaryTypeId);
return(Convert.ToInt32(DHelper.ExecuteNonQuery(comm)));
}