JLApi.git - Gitblit

			@@ -32,7 +32,7 @@
			sql = @"select code,name,'1' as isGroup,data_sources from TUnitGroup ";
			var data = DapperHelper.selecttable(sql);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			LogHelper.OperateLog("999", "查询", "计量单位组查询数据为：" + JsonConvert.SerializeObject(data), "PC");
			}
			@@ -40,7 +40,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -93,7 +93,7 @@
			var total = 0; //总条数
			data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.count = total;
			mes.data = data.ToList();
			LogHelper.OperateLog("999", "查询", "查询了计量单位", "PC");
			@@ -102,7 +102,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -123,14 +123,14 @@
			dynamicParams.Add("@tunitgroupcode", unitcode);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -162,7 +162,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "计量单位的名称不能重复,请重新输入!";
			mes.message = "计量单位的名称不能重复,请重新输入!";
			mes.data = null;
			return mes;
			}
			@@ -176,7 +176,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "计量单位组的名称不能重复,请重新输入!";
			mes.message = "计量单位组的名称不能重复,请重新输入!";
			mes.data = null;
			return mes;
			}
			@@ -230,14 +230,14 @@
			LogHelper.DbOperateLog(us.usercode, "新增", "新增了计量单位："+ tunittype == "S" ? ((List<string>)mes.data)[0].ToString() : string.Join(",", listjson[0].children.Select(m => m.unitcode)), us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "新增操作成功!";
			mes.message = "新增操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "新增操作失败!";
			mes.message = "新增操作失败!";
			mes.data = null;
			}
			}
			@@ -253,7 +253,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "计量单位的名称不能重复,请重新输入!";
			mes.message = "计量单位的名称不能重复,请重新输入!";
			mes.data = null;
			return mes;
			}
			@@ -286,7 +286,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "计量单位组的名称不能重复,请重新输入!";
			mes.message = "计量单位组的名称不能重复,请重新输入!";
			mes.data = null;
			return mes;
			}
			@@ -347,14 +347,14 @@
			LogHelper.DbOperateLog(us.usercode, "修改", "修改了计量单位：" + tunittype == "S" ? ((List<string>)mes.data)[0].ToString() : string.Join(",", listjson[0].children.Select(m => m.unitcode)), us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "修改操作成功!";
			mes.message = "修改操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "修改操作失败!";
			mes.message = "修改操作失败!";
			mes.data = null;
			}
			}
			@@ -363,7 +363,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -387,7 +387,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "单计量单位已被使用,不允许删除!";
			mes.message = "单计量单位已被使用,不允许删除!";
			mes.data = null;
			return mes;
			}
			@@ -414,7 +414,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "多计量单位组中有计量单位被使用,不允许删除!";
			mes.message = "多计量单位组中有计量单位被使用,不允许删除!";
			mes.data = null;
			return mes;
			}
			@@ -453,7 +453,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "多计量单位已被使用,不允许删除!";
			mes.message = "多计量单位已被使用,不允许删除!";
			mes.data = null;
			return mes;
			}
			@@ -477,14 +477,14 @@
			LogHelper.DbOperateLog(us.usercode, "新增", "新增了计量单位：" + tunittype == "S" ? tunitcode : tunittype == "M"&& (tunitgroupcode != "" \|\| tunitgroupcode != null) && (tunitcode == "" \|\| tunitcode == null)? tunitgroupcode: tunitgroupcode+"-->"+tunitcode, us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "删除操作成功!";
			mes.message = "删除操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "删除操作失败!";
			mes.message = "删除操作失败!";
			mes.data = null;
			}
			}
			@@ -492,7 +492,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -510,7 +510,7 @@
			sql = @"select code,name,idparent,data_sources from TMateriel_Class ";
			var data = DapperHelper.selecttable(sql);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			LogHelper.OperateLog("999", "查询", "存货分类查询数据为：" + JsonConvert.SerializeObject(data), "PC");
			}
			@@ -518,7 +518,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -542,7 +542,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "存货分类上级不能是已有存货的分类，请重新输入！";
			mes.message = "存货分类上级不能是已有存货的分类，请重新输入！";
			mes.data = null;
			return mes;
			}
			@@ -557,7 +557,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "存货分类编码已存在,请重新输入!";
			mes.message = "存货分类编码已存在,请重新输入!";
			mes.data = null;
			return mes;
			}
			@@ -569,7 +569,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "存货分类名称已存在,请重新输入!";
			mes.message = "存货分类名称已存在,请重新输入!";
			mes.data = null;
			return mes;
			}
			@@ -596,14 +596,14 @@
			LogHelper.DbOperateLog(us.usercode, "新增", "新增了存货分类:"+ inventoryclasscode, us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "新增操作成功!";
			mes.message = "新增操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "新增操作失败!";
			mes.message = "新增操作失败!";
			mes.data = null;
			}
			}
			@@ -618,7 +618,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "存货分类名称已存在,请重新输入!";
			mes.message = "存货分类名称已存在,请重新输入!";
			mes.data = null;
			return mes;
			}
			@@ -644,14 +644,14 @@
			LogHelper.DbOperateLog(us.usercode, "修改", "修改了存货分类:"+ inventoryclasscode, us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "修改操作成功!";
			mes.message = "修改操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "修改操作失败!";
			mes.message = "修改操作失败!";
			mes.data = null;
			}
			}
			@@ -660,7 +660,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -684,7 +684,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前存货分类或下级被引用不允许删除！";
			mes.message = "当前存货分类或下级被引用不允许删除！";
			mes.data = null;
			return mes;
			}
			@@ -705,14 +705,14 @@
			LogHelper.DbOperateLog(us.usercode, "删除", "删除了存货分类"+classcode, us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "删除操作成功!";
			mes.message = "删除操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "删除操作失败!";
			mes.message = "删除操作失败!";
			mes.data = null;
			}
			}
			@@ -720,7 +720,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -779,7 +779,7 @@
			var total = 0; //总条数
			data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.count = total;
			mes.data = data.ToList();
			}
			@@ -787,7 +787,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -812,7 +812,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "存货档案编码已存在,请重新输入!";
			mes.message = "存货档案编码已存在,请重新输入!";
			mes.data = null;
			return mes;
			}
			@@ -824,7 +824,7 @@
			//{
			// mes.code = "300";
			// mes.count = 0;
			// mes.Message = "存货档案名称已存在,请重新输入!";
			// mes.message = "存货档案名称已存在,请重新输入!";
			// mes.data = null;
			// return mes;
			//}
			@@ -836,7 +836,7 @@
			//{
			// mes.code = "300";
			// mes.count = 0;
			// mes.Message = "存货档案规格已存在,请重新输入!";
			// mes.message = "存货档案规格已存在,请重新输入!";
			// mes.data = null;
			// return mes;
			//}
			@@ -881,14 +881,14 @@
			LogHelper.DbOperateLog(us.usercode, "新增", "新增了存货档案:"+ partcode, us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "新增操作成功!";
			mes.message = "新增操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "新增操作失败!";
			mes.message = "新增操作失败!";
			mes.data = null;
			}
			}
			@@ -903,7 +903,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "存货档案名称已存在,请重新输入!";
			mes.message = "存货档案名称已存在,请重新输入!";
			mes.data = null;
			return mes;
			}
			@@ -916,7 +916,7 @@
			//{
			// mes.code = "300";
			// mes.count = 0;
			// mes.Message = "存货档案规格型号已存在,请重新输入!";
			// mes.message = "存货档案规格型号已存在,请重新输入!";
			// mes.data = null;
			// return mes;
			//}
			@@ -959,14 +959,14 @@
			LogHelper.DbOperateLog(us.usercode, "修改", "修改了存货档案:"+ partcode, us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "修改操作成功!";
			mes.message = "修改操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "修改操作失败!";
			mes.message = "修改操作失败!";
			mes.data = null;
			}
			}
			@@ -975,7 +975,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -998,7 +998,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前存货分已被引用[生产订单]不允许删除！";
			mes.message = "当前存货分已被引用[生产订单]不允许删除！";
			mes.data = null;
			return mes;
			}
			@@ -1010,7 +1010,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前存货已被引用[生产工单]不允许删除！";
			mes.message = "当前存货已被引用[生产工单]不允许删除！";
			mes.data = null;
			return mes;
			}
			@@ -1032,14 +1032,14 @@
			LogHelper.DbOperateLog(us.usercode, "删除", "删除了存货档案:"+partcode, us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "删除操作成功!";
			mes.message = "删除操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "删除操作失败!";
			mes.message = "删除操作失败!";
			mes.data = null;
			}
			}
			@@ -1047,7 +1047,38 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion


			#region[工单产品信息下拉框查询]
			public static ToMessage PartSelect()
			{
			string sql = "";
			try
			{
			//获取物料数据
			sql = @"select M.partcode,M.partname,M.partspec,M.idunit as uom_code,T.name as uom_name,
			M.idunitgroup as stocktype_code,D.name as stocktype_name,
			M.idwarehouse as stck_code,S.name as stck_name
			from TMateriel_Info M
			left join TUnit T on M.idunit=T.code
			left join TUnitGroup D on M.idunitgroup=D.code
			left join TSecStck S on M.idwarehouse=S.code ";
			var data = DapperHelper.selecttable(sql);
			mes.code = "200";
			mes.message = "查询成功!";
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;