public Response SaveItemClassMaintainData(string token, [FromBody] SaveItemClassMaintainDataParam param)
{
Response response = new Response();
if (string.IsNullOrEmpty(token) || !token.Equals(_token))
{
response.code = "404";
response.message = "Invild token";
}
else
{
int result = CClassSupplierHelper.SaveItemClassMaintainData(param);
if (result == 0)
{
response.code = "500";
response.message = "No Data";
}
else
{
response.code = "200";
response.content = result;
}
}
return(response);
}
/// <summary>
/// 保存修改的ItemClassMapping数据
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public static int SaveItemClassMaintainData(SaveItemClassMaintainDataParam param)
{
try
{
int result = cClassSupplierFactory.SaveItemClassMaintainData(param);
if (result == 0)
{
throw new Exception("DAL.MastData.cClassSupplierFactory.SaveItemClassMaintainData()==0");
}
return(result);
}
catch (Exception ex)
{
LogHelper.WriteLog(new Log()
{
message = ex.Message
}, "result");
return(0);
}
}
/// <summary>
/// 保存修改的ItemClassMapping数据
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public int SaveItemClassMaintainData(SaveItemClassMaintainDataParam param)
{
int result = 0;
string strType = "RMClassMapping";
StringBuilder sbSqlFinal = new StringBuilder();
string strSqlUpdate = " UPDATE TBLDATAMAPPING " +
" SET DELETETIME = '{0}' " +
" , DELETEUSER = '******' " +
" WHERE DBCODE = '{2}' " +
" AND CODE2 IN {3} " +
" AND DELETEUSER IS NULL ";
string strSqlInsert = " INSERT INTO TBLDATAMAPPING " +
" ( TYPE " +
" , DBCODE " +
" , CODE1 " +
" , NAME1 " +
" , CODE2 " +
" , NAME2 " +
" , CREATETIME " +
" , CREATEUSER ) " +
" VALUES " +
" ( '{0}' " +
" , '{1}' " +
" , '{2}' " +
" , '{3}' " +
" , '{4}' " +
" , '{5}' " +
" , '{6}' " +
" , '{7}' ) ";
// Item数据
List <ItemClass> lstItemClassData = (new ItemFactory()).getItemClass(param.dbCode);
// 当前时间
string strDateTime = SalesOrder.Common.convertDateTime(DateTime.Now.ToString());
// ItemCode Sql条件
string strItemCodesString = string.Empty;
var linq = param.lstTalDataMapping.GroupBy(q => new { q.p_code }).ToList();
foreach (var lq in linq)
{
// 取得ItemCode Sql条件
strItemCodesString = GetItemCodesString(lq.Key.p_code, lstItemClassData);
// 父级Item为组进行删除
sbSqlFinal.Append(string.Format(strSqlUpdate, strDateTime, param.userId, param.dbCode, strItemCodesString));
// 父级为组进行新增
foreach (tblDataMapping map in lq.ToList())
{
if (!string.IsNullOrWhiteSpace(map.delFlag))
{
continue;
}
sbSqlFinal.Append(string.Format(strSqlInsert, strType, param.dbCode, map.code1, map.name1, map.code2, map.name2, strDateTime
, param.userId));
}
}
result = SqlServerHelper.Execute(SqlServerHelper.salesorderConn(), sbSqlFinal.ToString());
return(result);
}
