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); }