/// <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>
/// 按揭资料数据添加
/// </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");
}