/// <summary>
/// 按揭资料修改
/// </summary>
/// <param name="bankdataid">按揭资料ID</param>
/// <param name="buycount">买方资料</param>
/// <param name="sellcount">卖方资料</param>
/// <param name="contrsctid">合同ID</param>
/// <param name="codetype">缺失/收到</param>
public void updatecode(string bankdataid, string buycount, string sellcount)
{
SqlAgent sa = new SqlAgent(SysConfiguration.GetErpSqlConn());
sa.addParameterString("F_8100_03", buycount, 2000, false, "");
sa.addParameterString("F_8100_04", sellcount, 2000, false, "");
sa.addParameterString("F_998", DateTime.Now.ToString(), 100, false, "");
sa.addCondition("F_8100_01", bankdataid, CompareType.Equal, LogicType.none, "");
sa.update("T_8100");
}
/// <summary>
/// 添加按揭数据到 T_8057
/// </summary>
/// <param name="contactid">合同ID</param>
/// <param name="inbuycode">收到的买方资料</param>
/// <param name="insellcode">收到的卖方资料</param>
/// <param name="upbuycode">缺失的买方资料</param>
/// <param name="upsellcode">缺失的卖方资料</param>
public void insertbankcode(string contactid, string inbuycode, string insellcode, string upbuycode, string upsellcode)
{
SqlAgent sa = new SqlAgent(SysConfiguration.GetErpSqlConn());
sa.addParameterString("F_8057_80", inbuycode, 8000, false, "");
sa.addParameterString("F_8057_90", insellcode, 8000, false, "");
sa.addParameterString("F_8057_81", upbuycode, 8000, false, "");
sa.addParameterString("F_8057_91", upsellcode, 8000, false, "");
sa.addCondition("F_8057_02", contactid, CompareType.Equal, LogicType.none, "");
sa.insert("T_8057");
}
/// <summary>
/// 添加按揭数据到 T_8057
/// </summary>
/// <param name="contactid">合同ID</param>
/// <param name="inbuycode">收到的买方资料</param>
/// <param name="insellcode">收到的卖方资料</param>
/// <param name="upbuycode">缺失的买方资料</param>
/// <param name="upsellcode">缺失的卖方资料</param>
public void updatebankdata(string contactid, string inbuycode, string insellcode, string upbuycode, string upsellcode)
{
SqlAgent sa = new SqlAgent(SysConfiguration.GetErpSqlConn());
sa.addParameterString("F_8057_80", inbuycode, 8000, false, "");
sa.addParameterString("F_8057_90", insellcode, 8000, false, "");
sa.addParameterString("F_8057_81", upbuycode, 8000, false, "");
sa.addParameterString("F_8057_91", upsellcode, 8000, false, "");
sa.addCondition("F_8057_02", contactid, CompareType.Equal, LogicType.none, "");
sa.addCondition("F_8057_78", ElectroniContracType.其他.GetHashCode(), CompareType.Equal, LogicType.And, "");
sa.update("T_8057");
}
/// <summary> 修改登陆密码
/// </summary>
/// <param name="subbranchID">支行id</param>
/// <param name="newpwd">密码</param>
public string updatePwd(string subbranchID, string newpwd, string oldpwd)
{
SqlAgent sa = new SqlAgent(SysConfiguration.GetErpSqlConn());
sa.addCondition("F_0120_01", subbranchID, CompareType.Equal, LogicType.none, "");
sa.addCondition("F_0120_10", oldpwd, CompareType.Equal, LogicType.And, "");
if (!sa.selectOne("T_0120"))
{
return("输入密码错误!");
}
sa.addParameterString("F_0120_10", newpwd, 200, false, "");
sa.update("T_0120");
return("");
}
/// <summary>
/// 按揭资料数据添加
/// </summary>
/// <param name="buycode">买方资料</param>
/// <param name="sellcode">卖方资料</param>
/// <param name="contrsctid">合同ID</param>
/// <param name="codetype">缺失/收到</param>
public void insertcode(string buycode, string sellcode, string contrsctid, string codetype)
{
SqlAgent sa = new SqlAgent(SysConfiguration.GetErpSqlConn());
Guid id = Guid.NewGuid();
sa.addParameterString("F_8100_01", id.ToString(), 50, false, "");
sa.addParameterString("F_8100_02", contrsctid, 50, false, "");
sa.addParameterString("F_8100_03", buycode, 2000, false, "");
sa.addParameterString("F_8100_04", sellcode, 2000, false, "");
if (codetype != "")
{
sa.addParameterDB("F_8100_05", codetype, "");
}
sa.addParameterString("F_8100_08", DateTime.Now.ToString(), 100, false, "");
sa.addParameterString("F_992", DateTime.Now.ToString(), 100, false, "");
sa.addParameterString("F_993", "0", 10, false, "");
sa.insert("T_8100");
}
/// <summary> 更改流程内容
/// </summary>
/// <param name="cid">合同id</param>
/// <param name="plan">进度</param>
public string updateFlow(string cid, string plan)
{
try
{
SqlAgent sa = new SqlAgent(SysConfiguration.GetErpSqlConn());
sa.addParameterDB("F_3517_09", "getdate()", "");
sa.addParameterString("F_3517_22", "系统自动完成", 100, false, "");
sa.addParameterNumber("F_3517_18", 1, "");
sa.addCondition("F_3517_03", cid, CompareType.Equal, LogicType.none, "");
sa.addCondition("F_3517_18", 1, CompareType.NotEqual, LogicType.And, "");
if (plan == emContractSpan.资料收齐.GetHashCode().ToString())
{
sa.addCondition("F_3517_06", "备齐按揭资料", CompareType.Equal, LogicType.And, "");
}
if (plan == emContractSpan.审批通过.GetHashCode().ToString())
{
//sa.addDBCondition("F_3517_06", "'按揭审批通过领取按揭合同','商业按揭审批通过'", CompareType.In, "");
//sa.addCondition("F_3517_06", "商业按揭审批通过", CompareType.Equal, LogicType.And, "");
sa.whereAppend = " (F_3517_06 = '商业按揭审批通过' or F_3517_06 = '按揭审批通过')";
}
sa.update("T_3517");
sa.addSelect("F_3517_04");
DataTable dt = sa.@select("T_3517");
sa.whereAppend = "";
if (dt == null || dt.Rows.Count < 1)
{
return("");
}
sa = new SqlAgent(SysConfiguration.GetErpSqlConn());
sa.addParameterDB("F_3517_08", "DATEADD(day,1,getdate())", "");
sa.addCondition("F_3517_03", cid, CompareType.Equal, LogicType.none, "");
sa.addCondition("F_3515_07", dt.Rows[0]["F_3517_04"].ToString(), CompareType.Equal, LogicType.And, "");
return(sa.update("T_3517"));
}
catch (Exception ex)
{
return(ex.ToString());
}
}
/// <summary> 修改合同进度
/// </summary>
/// <param name="contactid"></param>
/// <param name="plan"></param>
public string updatePlan(string contactid, string plan, string username)
{
try
{
SqlAgent sa = new SqlAgent(SysConfiguration.GetErpSqlConn());
sa.addParameterNumber("F_8057_71", int.Parse(plan), "");
if (int.Parse(plan) == emContractSpan.已接收.GetHashCode())
{
sa.addParameterString("F_8057_87", username, 100, false, "");
sa.addParameterString("F_8057_85", DateTime.Now.ToString(), 100, false, "");
}
if (int.Parse(plan) == emContractSpan.揭办理.GetHashCode())
{
sa.addParameterString("F_8057_95", DateTime.Now.ToString(), 100, false, "");
}
if (int.Parse(plan) == emContractSpan.资料收齐.GetHashCode())
{
sa.addParameterString("F_8057_96", DateTime.Now.ToString(), 100, false, "");
}
if (int.Parse(plan) == emContractSpan.审批通过.GetHashCode())
{
sa.addParameterString("F_8057_97", DateTime.Now.ToString(), 100, false, "");
}
if (int.Parse(plan) == emContractSpan.借款合同已移交.GetHashCode())
{
sa.addParameterString("F_8057_98", DateTime.Now.ToString(), 100, false, "");
}
if (int.Parse(plan) == emContractSpan.已退件.GetHashCode())
{
sa.addParameterString("F_8057_99", DateTime.Now.ToString(), 100, false, "");
}
sa.addCondition("F_8057_02", contactid, CompareType.Equal, LogicType.none, "");
sa.addCondition("F_8057_78", ElectroniContracType.其他.GetHashCode(), CompareType.Equal, LogicType.And, "");
return(sa.update("T_8057"));
}
catch (Exception ex)
{
return(ex.Message);
}
}