/// <summary>
/// 获取授信信息列表
/// </summary>
/// yaoy 16.03.30
/// <param name="data"></param>
/// <param name="page"></param>
/// <returns></returns>
public DataTable List(Pagination page, NameValueCollection data)
{
SqlCommand comm = DHelper.GetSqlCommand(@"
SELECT temp.rownum,ui.*,cci.Name,cci.CreditId,dbo.Dic(2, ui.Status) AS StatusDesc,rol.Name AS RoleName FROM USER_UserInfo AS ui
RIGHT JOIN (
SELECT TOP(@End) ROW_NUMBER() OVER(ORDER BY UserId DESC) AS rownum, UserId, CreditId FROM CRET_Account AS ca
WHERE (@CreditId IS NULL OR ca.CreditId = @CreditId)
) AS temp ON temp.UserId = ui.UI_ID
LEFT JOIN CRET_CreditInfo AS cci ON cci.CreditId = temp.CreditId
LEFT JOIN USER_Relation AS ur ON ur.UserId = ui.UI_ID
LEFT JOIN USER_Role AS rol ON rol.UR_ID = ur.RoleId
WHERE temp.rownum> @Begin ORDER BY cci.CreditId DESC
");
DHelper.AddInParameter(comm, "@CreditId", SqlDbType.Int, data["CreditId"]);
DHelper.AddInParameter(comm, "@Begin", SqlDbType.Int, page.Begin);
DHelper.AddInParameter(comm, "@End", SqlDbType.Int, page.End);
SqlCommand commPage = DHelper.GetSqlCommand(@"
SELECT COUNT(UserId) FROM CRET_Account
WHERE (@CreditId IS NULL OR CreditId = @CreditId)
");
DHelper.AddInParameter(commPage, "@CreditId", SqlDbType.Int, data["CreditId"]);
page.Total = Convert.ToInt32(DHelper.ExecuteScalar(commPage));
return(DHelper.ExecuteDataTable(comm));
}
/// <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.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>
/// yangj 16.07.01
/// <param name="dictionaryTypeId">字典类型ID</param>
/// <returns></returns>
public DataTable List(Models.Pagination page, NameValueCollection filter)
{
SqlCommand comm = DHelper.GetSqlCommand(@"
SELECT tmp.rownum, bdt.BDT_ID,bdt.Name, temp.Name AS ParentName
FROM BANK_DictionaryType AS bdt
RIGHT JOIN (SELECT TOP (@End) ROW_NUMBER() OVER (ORDER BY BDT_ID DESC) AS rownum,BDT_ID FROM BANK_DictionaryType
)AS tmp ON bdt.BDT_ID = tmp.BDT_ID
LEFT JOIN BANK_DictionaryType
AS temp ON bdt.ParentType = temp.BDT_ID
WHERE tmp.rownum > @Begin
" );
DHelper.AddParameter(comm, "@Begin", SqlDbType.Int, page.Begin);
DHelper.AddParameter(comm, "@End", SqlDbType.Int, page.End);
SqlCommand commPage = DHelper.GetSqlCommand(
@"SELECT COUNT(*) FROM BANK_DictionaryType
" );
page.Total = Convert.ToInt32(DHelper.ExecuteScalar(commPage));
DataTable dt = DHelper.ExecuteDataTable(comm);
return(dt);
}
/// <summary>
/// 查找所有借贷信息
/// </summary>
/// zouql 16.08.30
/// <returns>借贷信息List</returns>
public List <BorrowInfo> FindAll()
{
SqlCommand comm = new SqlCommand(@"
SELECT
BI_ID,
FinanceId,
ApprovalPrincipal,
InterestRate,
FinancingPeriods,
RepaymentInterval,
RepaymentMethod,
RepaymentDate,
FinanceAddDate,
[State],
OncePayMonths,
FinalRatio,
CustomerBailRatio,
FinalCost,
ExtralCost
FROM FANC_Borrow
WHERE FinanceId=@financeId
");
var dt = DHelper.ExecuteDataTable(comm);
return(LoadAll(dt.Rows));
}
/// <summary>
/// 创建实例集合视图
/// </summary>
protected override void BuildContentsView()
{
base.BuildContentsView();
DispatcherOperation operation = DHelper.InvokeOnMain(() => TreeView = Contents.Where(t => t.IsFirstLevel).AsICV());
operation.Wait();
}
public static string GetSQLString <TC>(TC qc, string dicomString)
where TC : MappingItem, IDicomMappingItem
{
string str = dicomString;
if (str == null)
{
str = "";
}
if (qc == null || !DHelper.IsStringLike(qc.DPath.VR))
{
return(str);
}
if (str.Length < 1)
{
return(SQLMatchChar);
}
if (SQLMatchChar.Length > 0)
{
str = str.Replace(SQLMatchChar, "[" + SQLMatchChar + "]");
}
if (DicomMatchChar.Length > 0)
{
str = str.Replace(DicomMatchChar, SQLMatchChar);
}
return(str);
}
/// <summary>
/// 产品筛选(产品名)
/// </summary>
/// yangj 16.08.02
/// <returns></returns>
public List <ComboInfo> FindByProduceName(int creditId)
{
SqlCommand comm = DHelper.GetSqlCommand(@"
SELECT DISTINCT Name
FROM PROD_ProduceInfo AS A
LEFT JOIN CRET_BindProduce AS B
ON A.ProduceId = B.ProduceId
WHERE B.CreditId = @CreditId;");
DHelper.AddParameter(comm, "@CreditId", SqlDbType.Int, creditId);
DataTable dt = DHelper.ExecuteDataTable(comm);
List <ComboInfo> list = new List <ComboInfo>();
foreach (DataRow dr in dt.Rows)
{
ComboInfo cbi = new ComboInfo(dr["Name"].ToString(), dr["Name"].ToString());
list.Add(cbi);
}
return(list);
}
/// <summary>
/// 产品筛选
/// </summary>
/// yangj 16.08.02
/// <param name="produceName">产品名</param>
/// <param name="repaymentMethod">还款方式</param>
/// <param name="financingPeriods">融资期限</param>
/// <returns></returns>
public List <ComboInfo> FindProduct(string produceName, string repaymentMethod, string financingPeriods, int creditId)
{
SqlCommand comm = DHelper.GetSqlCommand(@"
SELECT A.ProduceId,
Code
FROM PROD_ProduceInfo AS A
LEFT JOIN CRET_BindProduce AS B
ON A.ProduceId = B.ProduceId
WHERE B.CreditId = @CreditId
AND (@Name IS NULL OR Name=@Name)
AND (@RepaymentMethod IS NULL OR RepaymentMethod=@RepaymentMethod)
AND (@FinancingPeriods IS NULL OR FinancingPeriods=@FinancingPeriods)");
DHelper.AddParameter(comm, "@CreditId", SqlDbType.Int, creditId);
DHelper.AddParameter(comm, "@Name", SqlDbType.NVarChar, produceName);
DHelper.AddParameter(comm, "@RepaymentMethod", SqlDbType.Int, repaymentMethod);
DHelper.AddParameter(comm, "@FinancingPeriods", SqlDbType.Int, financingPeriods);
DataTable dt = DHelper.ExecuteDataTable(comm);
List <ComboInfo> list = new List <ComboInfo>();
foreach (DataRow dr in dt.Rows)
{
ComboInfo cbi = new ComboInfo(dr["ProduceId"].ToString(), dr["Code"].ToString());
list.Add(cbi);
}
return(list);
}
/// <summary>
/// 产品列表查询方法
/// </summary>
/// cais 16.03.28
/// <param name="pagination">分页</param>
/// <param name="filter">参数</param>
/// <returns></returns>
public DataTable Find(Models.Pagination pagination, NameValueCollection filter)
{
SqlCommand comm = DHelper.GetSqlCommand(@"
SELECT
Produce.ProduceId,Code,Name,(InterestRate * 12) as InterestRate,(Rate * 12) as Rate,MinFinancingRatio,MaxFinancingRatio,FinalRatio,FinancingPeriods,RepaymentInterval,CustomerBailRatio,CustomerPoundage,AddDate,Remarks,AdditionalGPSCost,AdditionalOtherCost, dbo.Dic(3,RepaymentMethod) AS paymothed FROM PROD_ProduceInfo
AS Produce LEFT JOIN (SELECT TOP (@End) ROW_NUMBER() OVER (ORDER BY ProduceId DESC) AS rownum,ProduceId FROM PROD_ProduceInfo
WHERE @Code_Name IS NULL OR (Code like '%'+@Code_Name+'%' OR Name like '%'+@Code_Name+'%')) AS TMP
ON Produce.ProduceId=TMP.ProduceId WHERE TMP.rownum>@Begin
");
DHelper.AddParameter(comm, "@Begin", SqlDbType.Int, pagination.Begin);
DHelper.AddParameter(comm, "@End", SqlDbType.Int, pagination.End);
DHelper.AddParameter(comm, "@Code_Name", SqlDbType.VarChar, filter["ProductCodeOrName"]);
SqlCommand commPage = DHelper.GetSqlCommand(@"SELECT Count(*) FROM PROD_ProduceInfo WHERE @Code_Name IS NULL OR (Code like '%'+@Code_Name+'%' OR Name like '%'+@Code_Name+'%')");
DHelper.AddParameter(commPage, "@Code_Name", SqlDbType.NVarChar, filter["ProductCodeOrName"]);
pagination.Total = Convert.ToInt32(DHelper.ExecuteScalar(commPage));
DataTable dt = DHelper.ExecuteDataTable(comm);
return(dt);
}
/// <summary>
/// 模糊查询元代码名称集合()
/// </summary>
/// <param name="value">查询值</param>
/// <param name="type">类型</param>
/// <returns>集合</returns>
public List <ComboInfo> GetComListMateName(string value, string type)
{
var sql =
@"
SELECT MetaCode,Name FROM BANK_Meta WHERE [Type]=@t AND Name LIKE @value
";
SqlCommand cmd = DHelper.GetSqlCommand(sql);
DHelper.AddInParameter(cmd, "@value", SqlDbType.NVarChar, "%" + value + "%");
DHelper.AddInParameter(cmd, "@t", SqlDbType.TinyInt, byte.Parse(type));
var table = DHelper.ExecuteDataTable(cmd);
var list = new List <ComboInfo>();
for (var i = 0; i < table.Rows.Count; i++)
{
var p1 = table.Rows[i]["MetaCode"];
var p2 = table.Rows[i]["Name"];
if (p1 == null)
{
p1 = string.Empty;
}
if (p2 == null)
{
p2 = string.Empty;
}
list.Add(new ComboInfo(p1.ToString(), p2.ToString()));
}
return(list);
}
/// <summary>
/// 实例集合需要刷新
/// <para>触发</para>
/// </summary>
protected void RaiseContentsNeedRefresh()
{
if (IsContentsNeedRefresh)
{
DHelper.InvokeOnMain(() => OnContentsNeedRefresh?.Invoke());
}
}
/// <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>
/// 弹窗显示错误信息
/// </summary>
/// <param name="ex"></param>
/// <param name="title"></param>
protected void ShowEx(Exception ex, string title)
{
if (IsShowMsg)
{
Task.Factory.StartNew(() => DHelper.ShowEx(ex, title)).Wait();
}
}
/// <summary>
/// 弹窗显示提示信息
/// </summary>
/// <param name="msg"></param>
/// <param name="title"></param>
protected void ShowMsg(string msg, string title)
{
if (IsShowMsg)
{
Task.Factory.StartNew(() => DHelper.ShowMsg(msg, title)).Wait();
}
}
/// <summary>
/// 分页查询
/// </summary>
/// qiy 16.03.29
/// <param name="page">分页信息</param>
/// <param name="filter">筛选条件</param>
/// <returns></returns>
public DataTable List(Models.Pagination page, NameValueCollection filter)
{
SqlCommand comm = DHelper.GetSqlCommand(@"
SELECT tmp.rownum, ci.CreditId,
ci.Name, ci.Type, dbo.Dic(4, ci.Type) AS TypeDesc, ci.LineOfCredit, ci.AddDate, ci.Remarks,
cpi.Bail, cpi.ControllerName, cpi.ControllerTelephone
FROM CRET_CreditInfo AS ci
RIGHT JOIN (
SELECT TOP (@End) ROW_NUMBER() OVER (ORDER BY CreditId DESC) AS rownum, CreditId FROM CRET_CreditInfo
) AS tmp ON ci.CreditId = tmp.CreditId
LEFT JOIN CRET_PartnerInfo AS cpi ON ci.CreditId = cpi.CreditId
WHERE tmp.rownum > @Begin
" );
DHelper.AddParameter(comm, "@Begin", SqlDbType.Int, page.Begin);
DHelper.AddParameter(comm, "@End", SqlDbType.Int, page.End);
SqlCommand commPage = DHelper.GetSqlCommand(@"
SELECT COUNT(*) FROM CRET_CreditInfo
" );
page.Total = Convert.ToInt32(DHelper.ExecuteScalar(commPage));
return(DHelper.ExecuteDataTable(comm));
}
/// <summary>
/// 查找指定的借贷信息
/// </summary>
/// zouql 16.08.30
/// <param name="financeId">融资标识</param>
/// <returns>借贷信息</returns>
public BorrowInfo Find(int financeId)
{
SqlCommand comm = new SqlCommand(@"
SELECT
BI_ID,
FinanceId,
ApprovalPrincipal,
InterestRate,
FinancingPeriods,
RepaymentInterval,
RepaymentMethod,
RepaymentDate,
FinanceAddDate,
[State],
OncePayMonths,
FinalRatio,
CustomerBailRatio,
FinalCost,
ExtralCost
FROM
FANC_Borrow
WHERE FinanceId=@financeId
");
DHelper.AddParameter(comm, "@financeId", SqlDbType.Int, financeId);
var dt = DHelper.ExecuteDataTable(comm);
return(Load(dt.Rows[0]));
}
public override void Refresh()
{
StringBuilder sb = new StringBuilder();
sb.Append("(").Append(DHelper.Int2HexString((int)(0x0000FFFF & Tag)));
sb.Append(",").Append(DHelper.Int2HexString((int)(Tag >> 16))).Append(")");
string strTag = sb.ToString();
if (SubItems.Count < 2)
{
SubItems.Add(strTag);
}
else
{
SubItems[1].Text = strTag;
}
string strDescription = DHelper.GetTagName(Tag);
if (SubItems.Count < 3)
{
SubItems.Add(strDescription);
}
else
{
SubItems[2].Text = strDescription;
}
base.Refresh();
}
/// <summary>
/// 提取父节点（无重复）
/// </summary>
/// zouql 16.07.06
/// <returns></returns>
public List <ComboInfo> GetComList()
{
SqlCommand comm = DHelper.GetSqlCommand(@"
SELECT DISTINCT Code,Name
FROM BANK_DictionaryCode
");
DataTable dt = DHelper.ExecuteDataTable(comm);
List <ComboInfo> list = new List <ComboInfo>();
foreach (DataRow dr in dt.Rows)
{
var cbi = new ComboInfo(string.Empty, string.Empty);
object p1 = dr["Code"];
object p2 = dr["Name"];
if (p1 != null)
{
cbi.value = p1.ToString();
}
if (p2 != null)
{
cbi.text = p2.ToString();
}
list.Add(cbi);
}
return(list);
}
/// <summary>
/// 根据父节点查找字典
/// </summary>
/// <param name="parentCode"></param>
/// <param name="dictionaryTypeID"></param>
/// yand 16.07.18
/// <returns></returns>
public List <ComboInfo> GetComListByPanrentCode(int parentCode, int dictionaryTypeID)
{
SqlCommand comm = DHelper.GetSqlCommand(@"
SELECT Code,Name FROM BANK_DictionaryCode
WHERE ParentCode = @ParentCode AND BDT_ID = @dictionaryTypeID
");
DHelper.AddInParameter(comm, "@dictionaryTypeID", SqlDbType.Int, dictionaryTypeID);
DHelper.AddInParameter(comm, "@ParentCode", SqlDbType.NChar, parentCode);
DataTable dt = DHelper.ExecuteDataTable(comm);
List <ComboInfo> list = new List <ComboInfo>();
foreach (DataRow dr in dt.Rows)
{
var cbi = new ComboInfo(string.Empty, string.Empty);
object p1 = dr["Code"];
object p2 = dr["Name"];
if (p1 != null)
{
cbi.value = p1.ToString();
}
if (p2 != null)
{
cbi.text = p2.ToString();
}
list.Add(cbi);
}
return(list);
}
/// <summary>
/// 获取元代码名称集合
/// </summary>
/// zouql 16.07.07
/// <returns>集合</returns>
public List <ComboInfo> GetComListMateName()
{
var sql =
@"
SELECT MetaCode,Name FROM BANK_Meta
";
SqlCommand cmd = DHelper.GetSqlCommand(sql);
var table = DHelper.ExecuteDataTable(cmd);
var list = new List <ComboInfo>();
for (var i = 0; i < table.Rows.Count; i++)
{
var p1 = table.Rows[i]["MetaCode"];
var p2 = table.Rows[i]["Name"];
if (p1 == null)
{
p1 = string.Empty;
}
if (p2 == null)
{
p2 = string.Empty;
}
list.Add(new ComboInfo(p1.ToString(), p2.ToString()));
}
return(list);
}
/// <summary>
/// 获得凭证编号
/// </summary>
/// <param name="pzlx"></param>
/// <returns></returns>
public static string GetZWPZBH(ZWPZLX pzlx)
{
using (CtxRuntime ctxBase = new CtxRuntime())
{
string year = LoginInfo.LoginDate.Year.ToString();
string month = LoginInfo.LoginDate.Month.ToString("00");
ZWPZBH zWPZBH = (from t in ctxBase.ZWPZBH
where t.ZWPZBH_KJND == year
where t.ZWPZBH_KJQJ == month
where t.ZWPZBH_PZZ == pzlx.ZWPZLX_PZZ
select t).SingleOrDefault();
if (zWPZBH != null)
{
string result = $"{pzlx.ZWPZLX_PZZ}{zWPZBH.ZWPZBH_PZBH}";
zWPZBH.ZWPZBH_PZBH = (int.Parse(zWPZBH.ZWPZBH_PZBH) + 1).ToString("0000");
zWPZBH.ZWPZBH_PZRQ = DHelper.ConverToDateString(LoginInfo.LoginDate);
try
{
ctxBase.SaveChanges();
return(result);
}
catch
{
return(null);
}
}
return(null);
}
}
/// <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>
/// yaoy 15.11.30
/// qiy 15.12.04
/// <returns></returns>
public DataTable List()
{
SqlCommand comm = DHelper.GetSqlCommand(@"
SELECT DT_ID, Field, Name, IsCommon, Seed FROM SYS_DicType
");
return(DHelper.ExecuteDataTable(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>
/// 获取行业门类
/// </summary>
/// yand 16.05.31
/// <returns></returns>
public DataTable GetIndustry()
{
SqlCommand comm = DHelper.GetSqlCommand(@"
SELECT MainID,MainCode,MainName FROM BANK_Industry
");
return(DHelper.ExecuteDataTable(comm));
}
public void Refresh()
{
if (DHelper.IsStringLike(DPath.VR))
{
Operator = QueryCriteriaOperator.Like;
}
SourceField = DicomMappingHelper.DPath2DataColumnName(DPath);
}
/// <summary>
/// 获取行政区划第一级
/// </summary>
/// yand 16.05.25
/// <returns></returns>
public DataTable GetProvice()
{
SqlCommand comm = DHelper.GetSqlCommand(@"
SELECT Code,ProvincesOrCity FROM BANK_Administration WHERE Code like '%0000'
");
return(DHelper.ExecuteDataTable(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>
/// 集合
/// </summary>
/// yaoy 15.11.30
/// qiy 15.12.03
/// <returns></returns>
public DataTable List()
{
SqlCommand comm = DHelper.GetSqlCommand(@"
SELECT Field, Type, sdt.Name AS TypeName, Code, sdc.Name, Remarks FROM SYS_DicCommon AS sdc
LEFT JOIN SYS_DicType AS sdt ON sdt.DT_ID = sdc.Type
");
return(DHelper.ExecuteDataTable(comm));
}
