public JsonResult UpdMemberSalesContract(SalesContractModel salesContract)
{
Result data = null;
try
{
strLoginID = HttpContext.Session.GetString("loginid");
data = new Result();
string spName = "UP_SALES_CONTRACT_TX_INS_BULK";
string[] spParamName = new string[] {
"@pi_intMemberStoreNo", "@pi_intSalesStoreNoList", "@pi_strAdminID", "@po_intRetVal", "@po_strErrMsg"
};
object[] spParamValue = new object[] {
salesContract.MemberStoreNo, salesContract.SalesStoreNo, strLoginID, DBNull.Value, DBNull.Value
};
data = dbConn.SqlExecuteSPReturnValue(spName, spParamName, spParamValue);
}
catch (Exception ex)
{
data.RetVal = 930;
data.ErrMsg = "Exception in UpdMemberSalesContract : " + ex.Message;
return(Json(data));
}
return(Json(new { data }));
}
///---------------------------------------
/// <summary>
/// 판매처 DDLB (For 판매처 연계)
/// </summary>
///---------------------------------------
public static string ServicedSalesStoreDDLB(SalesContractModel salesContract)
{
StringBuilder sb = new StringBuilder();
string spName = "UP_MEMBERSTORE_SALES_CONTRACT_AR_LST";
string[] spParamName = new string[] {
"@pi_intMemberStoreNo"
};
object[] spParamValue = new object[] {
salesContract.MemberStoreNo
};
Result <DataTable> result = dbConn.SqlExecuteSPReturnTable(spName, spParamName, spParamValue);
if (result.RetVal.Equals(0))
{
foreach (DataRow row in result.data.Rows)
{
if (Convert.ToInt64(row["CONTRACTNO"]).Equals(0)) //매핑 안 된 판매처
{
sb.Append(PrintDDLBOption(row["SALESSTORENO"].ToString(), row["SALESSTORENAME"].ToString()));
}
else //매핑 된 판매처
{
sb.Append(PrintDDLBSelectedOption(row["SALESSTORENO"].ToString(), row["SALESSTORENAME"].ToString()));
}
}
}
return(sb.ToString());
}
public JsonResult ServicedSalesStoreDDLB(SalesContractModel salesContract)
{
string ServicedSalesStoreDDLB = CommonDDLB.ServicedSalesStoreDDLB(salesContract);
return(Json(ServicedSalesStoreDDLB));
}
