/// <summary>
/// 檢查是否投相關險種
/// </summary>
/// <param name="model">輔助資料 model</param>
/// <returns></returns>
public DataTable GetAssistInsureContent(AssistModel model)
{
List <SqlParameter> paramL = new List <SqlParameter>();
paramL.Add(new SqlParameter("@iTxNo", SqlDbType.VarChar)
{
Value = model.txNo
});
DataTable dt = DBHelper.SPGetDataTable("[ERP].dbo.[usp_getAssistInsureContent]", paramL);
return(dt);
}
/// <summary>
/// 查詢[輔助平台其他資料]資料表
/// </summary>
/// <param name="assistData">輔助資料 model</param>
/// <returns></returns>
public DataTable GetQuoteAssist(AssistModel assistData)
{
List <SqlParameter> paramL = new List <SqlParameter>();
paramL.Add(new SqlParameter("@iTxNo", SqlDbType.VarChar)
{
Value = assistData.txNo
});
DataTable dt = DBHelper.SPGetDataTable("[ERP].dbo.[usp_getQuoteAssist]", paramL);
return(dt);
}
/// <summary>
/// 儲存輔助平台其餘資料
/// </summary>
/// <param name="assistData">輔助資料 model</param>
/// <param name="sProgCode">創建程式</param>
/// <param name="sProgCode">sLoginID</param>
/// <returns></returns>
public DataTable SaveQuoteAssist(AssistModel assistData, string sProgCode, string sLoginID)
{
List <SqlParameter> paramL = new List <SqlParameter>();
paramL.Add(new SqlParameter("@iTxNo", SqlDbType.VarChar)
{
Value = assistData.txNo
});
paramL.Add(new SqlParameter("@iQuotNo", SqlDbType.VarChar)
{
Value = assistData.QuotNo
});
paramL.Add(new SqlParameter("@iCollectionType", SqlDbType.VarChar)
{
Value = assistData.collectionType
});
paramL.Add(new SqlParameter("@iViolateExtraFee", SqlDbType.VarChar)
{
Value = assistData.violateExtraFee
});
paramL.Add(new SqlParameter("@iViolateTimes", SqlDbType.VarChar)
{
Value = assistData.violateTimes
});
paramL.Add(new SqlParameter("@iStsseIno", SqlDbType.VarChar)
{
Value = assistData.StsseIno
});
paramL.Add(new SqlParameter("@iBizKind", SqlDbType.VarChar)
{
Value = assistData.bizKind
});
paramL.Add(new SqlParameter("@iTradingCompCode", SqlDbType.VarChar)
{
Value = assistData.tradingCompCode
});
paramL.Add(new SqlParameter("@iTradingCompUnitedNo", SqlDbType.VarChar)
{
Value = assistData.tradingCompUnitedNo
});
paramL.Add(new SqlParameter("@iTradingCompName", SqlDbType.VarChar)
{
Value = assistData.tradingCompName
});
paramL.Add(new SqlParameter("@iSiteNo", SqlDbType.VarChar)
{
Value = assistData.siteNo
});
paramL.Add(new SqlParameter("@iEreUser", SqlDbType.VarChar)
{
Value = assistData.EreUser
});
paramL.Add(new SqlParameter("@iCompTypeNo", SqlDbType.VarChar)
{
Value = assistData.compTypeNo
});
paramL.Add(new SqlParameter("@iOrgGrade", SqlDbType.VarChar)
{
Value = assistData.orgGrade
});
paramL.Add(new SqlParameter("@iProposalDate", SqlDbType.VarChar)
{
Value = assistData.proposalDate
});
paramL.Add(new SqlParameter("@iPaperOrNot", SqlDbType.VarChar)
{
Value = assistData.paperOrNot
});
paramL.Add(new SqlParameter("@iUserID", SqlDbType.VarChar)
{
Value = sLoginID
}); //創建者
paramL.Add(new SqlParameter("@iProgCode", SqlDbType.VarChar)
{
Value = sProgCode
}); //創建程式
DataTable dt = DBHelper.SPGetDataTable("[ERP].dbo.[usp_ins-altQuoteAssist]", paramL);
return(dt);
}
