MES-WEB-API.git

			@@ -8,6 +8,13 @@
			using System.Data.SqlClient;
			using System.Web.Http;
			using WebAPI.Models;
			using System.Text.RegularExpressions;
			using SyntacticSugar.constant;
			using System.Web;
			using WebAPI.Controllers.SCGL.日计划管理;
			//using WebAPI.WebBLL.JCJM.GYZL;
			//using WebAPI.WebBLL.JCJM.IMPL;
			using System.IO;
			namespace WebAPI.Controllers
			{
			public class Gy_CustomerController : ApiController
			@@ -18,9 +25,10 @@

			private json objJsonResult = new json();
			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
			//private Gy_CustomerService customerService = new Gy_CustomerImpl();
			DataSet ds;


			#region 返回客户列表
			/// <summary>
			/// 返回客户列表
			///参数：string sql。
			@@ -92,6 +100,74 @@
			return objJsonResult;
			}
			}
			#endregion

			#region 客户分页列表
			[Route("Gy_Customer/page")]
			[HttpGet]
			public json Gy_CustomerPage(string sWhere, string user, int page, int size, string Organization)
			{
			DataSet ds;
			json res = new json();
			try
			{
			List<object> columnNameList = new List<object>();
			//判断权限
			if (!DBUtility.ClsPub.Security_Log_second("Crm_CustomerFileList", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "无查看权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			//客户制定
			string sErr = "";
			if (oSystemParameter.ShowBill(ref sErr))
			{
			if (oSystemParameter.omodel.WMS_CampanyName != "乔一")
			{
			sWhere += ("and 组织名称 = '" + Organization + "'");
			}
			}


			sWhere = sWhere.Replace("'", "''");
			if (sWhere == null \|\| sWhere.Equals(""))
			{
			ds = oCN.RunProcReturn("exec h_p_Gy_CustomerList " + page + "," + size + ",''", "h_p_Gy_CustomerList");
			}
			else
			{
			ds = oCN.RunProcReturn("exec h_p_Gy_CustomerList " + page + "," + size + ",'" + sWhere + "'", "h_p_Gy_CustomerList");
			}

			//添加列名
			foreach (DataColumn col in ds.Tables[0].Columns)
			{
			Type dataType = col.DataType;
			string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
			columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
			}

			res.code = CodeConstant.SUCCEED;
			res.count = int.Parse(ds.Tables[1].Rows[0]["count"].ToString());
			res.Message = "Sucess！";
			res.list = columnNameList;
			res.data = ds.Tables[0];
			return res;
			}
			catch (Exception e)
			{
			res.code = CodeConstant.FAIL;
			res.count = CountConstant.FAIL;
			res.Message = "Exception！" + e.ToString();
			res.data = null;
			return objJsonResult;
			}
			}
			#endregion


			#region 客户子表[关联用户] 查询
			/// <summary>
			@@ -136,6 +212,7 @@
			}
			#endregion

			#region 客户列表修改按钮方法
			/// <summary>
			/// 客户列表修改按钮方法
			///参数：string sql。
			@@ -173,7 +250,7 @@
			return objJsonResult;
			}
			}

			#endregion

			#region 获取当前最大的客户代码
			[Route("Gy_Customer/getMaxCusNumber")]
			@@ -213,6 +290,7 @@
			}
			#endregion

			#region 获取最大资料ID参数
			/// <summary>
			/// 获取最大基础资料ID
			///参数：string sql。
			@@ -241,8 +319,86 @@
			return objJsonResult;
			}
			}
			#endregion

			#region 客户根据分类获取最大客户编码
			[Route("Gy_Customer/getMaxNum")]
			[HttpGet]
			public object getMaxNum(int HCusTypeID, string user, string Organization)
			{
			try
			{
			List<object> columnNameList = new List<object>();
			//编辑权限
			if (!DBUtility.ClsPub.Security_Log_second("Gy_Customer", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "无查看权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (HCusTypeID == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "没有选择具体分类！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			ds = oCN.RunProcReturn(@"select * from h_v_Gy_CustomerList where 组织名称='" + Organization + "'" + "and HCusTypeID = '" + HCusTypeID + "'" + " order by 客户代码 desc", "h_v_Gy_CustomerList");
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "没有找到该分类的客户编码请使用普通新增";
			objJsonResult.data = null;
			return objJsonResult;
			}
			string HNumber = ds.Tables[0].Rows[0]["客户代码"].ToString();
			// 使用正则表达式找到数字部分 (?<=\D)是一个零宽断言，表示前面的字符不是数字 (\d+)$表示后面跟着一连串字符串知道末尾
			Match match = Regex.Match(HNumber, @"(\d+)$");
			if (match.Success)
			{
			string prefix = HNumber.Substring(0, HNumber.Length - match.Length); // 提取前缀
			int number = int.Parse(match.Value); // 解析数字
			// 数字+1
			number++;
			// 格式化数字，保持原长度
			string formattedNumber = number.ToString().PadLeft(match.Length, '0');
			// 重新组合字符串
			string result = prefix + formattedNumber;

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "success";
			objJsonResult.data = result;
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "此分类客户编码格式有误";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region 客户列表树形结构
			/// <summary>
			/// 客户列表树形结构
			///参数：string sql。
			@@ -272,7 +428,9 @@
			return objJsonResult;
			}
			}
			#endregion

			#region 新增单据
			/// <summary>
			/// 新增单据-保存按钮
			///参数：string sql。
			@@ -428,9 +586,14 @@
			return objJsonResult;
			}
			}
			#endregion



			#region 保存客户列表
			/// <summary>
			/// 保存客户列表
			/// </summary>
			/// <param name="oMain"></param>
			/// <returns></returns>
			[Route("Gy_Customer/SaveGy_CustomerListApi")]
			[HttpPost]
			public object SaveGy_CustomerListApi([FromBody] JObject oMain)
			@@ -438,6 +601,7 @@
			try
			{
			var model = oMain["model"].ToString();
			LogService.Write("客户:" + model);
			var custLocationModel = oMain["model"]["HCustLocationEntry"].ToString();
			var custContactModel = oMain["model"]["HCustContactEntry"].ToString();
			//反序列化
			@@ -451,8 +615,8 @@
			oCN.RunProc(sql);
			sql = "set identity_insert gy_Customer on";
			oCN.RunProc(sql);
			//主表_客户
			oCN.RunProc("Insert into Gy_Customer " +

			LogService.Write("客户:" + "Insert into Gy_Customer " +
			" (HItemID,HNumber,HName,HHelpCode,HShortNumber,HParentID" +
			",HLevel,HEndFlag,HStopflag,HRemark" +
			",HShortName,HAddress,HLinkMan,HLinkPhone,HMobilePhone" +
			@@ -473,6 +637,28 @@
			"," + lsmain[0].HMonthUseQty + "," + lsmain[0].HForecastCreditRating + "," + lsmain[0].HCreditLevelID + "," + lsmain[0].HCountAccrualRating +
			"," + lsmain[0].HSubsidyAccrualRating + "," + lsmain[0].HCreditRating + "," + lsmain[0].HMaxCreditRating +
			", " + lsmain[0].HCusTypeID + ")");
			//主表_客户
			oCN.RunProc("Insert into Gy_Customer " +
			" (HItemID,HNumber,HName,HHelpCode,HShortNumber,HParentID" +
			",HLevel,HEndFlag,HStopflag,HRemark" +
			",HShortName,HAddress,HLinkMan,HLinkPhone,HMobilePhone" +
			",HFax,HPostalCode,HEmail,HBank,HBankAccount" +
			",HTaxNum,HTaxRate,HCountry,HCorMan,HEnglishName" +
			",HEnglishAddress,HCurID,HSSID,HAreaID,HCusStatus" +
			",HEmpID,HCreditDate,HCreditRatingDate,HMaxCreditRatingDate" +
			",HMonthUseQty,HForecastCreditRating,HCreditLevelID,HCountAccrualRating" +
			",HSubsidyAccrualRating,HCreditRating,HMaxCreditRating" +
			",HCusTypeID,HERPItemID) " +
			" Values('" + lsmain[0].HItemID + "','" + lsmain[0].HNumber + "','" + lsmain[0].HName + "','" + lsmain[0].HHelpCode + "','" + lsmain[0].HShortNumber + "'," + lsmain[0].HParentID +
			", " + lsmain[0].HLevel + ",0,'" + lsmain[0].HStopFlag + "','" + lsmain[0].HRemark + "'" +
			",'" + lsmain[0].HShortName + "','" + lsmain[0].HAddress + "','" + lsmain[0].HLinkMan + "','" + lsmain[0].HLinkPhone + "','" + lsmain[0].HMobilePhone + "'" +
			",'" + lsmain[0].HFax + "','" + lsmain[0].HPostalCode + "','" + lsmain[0].HEmail + "','" + lsmain[0].HBank + "','" + lsmain[0].HBankAccount + "'" +
			",'" + lsmain[0].HTaxNum + "'," + lsmain[0].HTaxRate + ",'" + lsmain[0].HCountry + "','" + lsmain[0].HCorMan + "','" + lsmain[0].HEnglishName + "'" +
			",'" + lsmain[0].HEnglishAddress + "'," + lsmain[0].HCurID + "," + lsmain[0].HSSID + "," + lsmain[0].HAreaID + ",'" + lsmain[0].HCusStatus + "'" +
			"," + lsmain[0].HEmpID + "," + lsmain[0].HCreditDate + "," + lsmain[0].HCreditRatingDate + "," + lsmain[0].HMaxCreditRatingDate +
			"," + lsmain[0].HMonthUseQty + "," + lsmain[0].HForecastCreditRating + "," + lsmain[0].HCreditLevelID + "," + lsmain[0].HCountAccrualRating +
			"," + lsmain[0].HSubsidyAccrualRating + "," + lsmain[0].HCreditRating + "," + lsmain[0].HMaxCreditRating +
			", " + lsmain[0].HCusTypeID + "," + lsmain[0].HItemID + ")");
			sql = "set identity_insert gy_Customer off";
			oCN.RunProc(sql);
			//客户_交货地点
			@@ -531,9 +717,9 @@
			return objJsonResult;
			}
			}
			#endregion



			#region 修改单据-保存按钮
			/// <summary>
			/// 修改单据-保存按钮
			///参数：string sql。
			@@ -704,9 +890,9 @@
			return objJsonResult;
			}
			}
			#endregion



			# region 客户列表删除按钮
			/// <summary>
			/// 客户列表删除按钮
			///参数：string sql。
			@@ -797,7 +983,7 @@
			return objJsonResult;
			}
			}

			#endregion

			#region 客户审核、反审核
			/// <summary>
			@@ -989,7 +1175,6 @@
			}
			#endregion


			#region [同步基础资料]
			[Route("Gy_Customer/Gy_CustomerViewApi")]
			[HttpGet]
			@@ -1124,7 +1309,7 @@
			,HLevel,HEndFlag,HStopflag,HRemark,HUseFlag,HMakeTime,HCREATEORGID,HUSEORGID
			)
			values
			({jsonData.HItemID},{jsonData.HERPItemID},'{jsonData.HNumber}','{jsonData.HName}',
			({jsonData.HItemID},{jsonData.HItemID},'{jsonData.HNumber}','{jsonData.HName}',
			'{jsonData.HShortNumber}',{jsonData.HParentID},{jsonData.HLevel},{jsonData.HEndFlag},{jsonData.HStopflag},'{jsonData.HRemark}','{jsonData.HUseFlag}','{jsonData.HMakeTime}',{jsonData.HCREATEORGID},{jsonData.HUSEORGID})";

			oCN.RunProc(sql);
			@@ -1152,5 +1337,237 @@
			}
			#endregion

			#region 客户分类树形图(根据代码展开树状图)

			[Route("Gy_BadReason/Gy_CusrTypeTreeList")]
			[HttpGet]
			public object Gy_CusrTypeTreeList()
			{
			try
			{
			string sql1 = string.Format("select hitemid,hnumber,hname from Gy_MaterType order by hnumber");

			ds = oCN.RunProcReturn(sql1, "Gy_MaterType");

			List<TreeModel> treeModels = new List<TreeModel>();
			TreeModel first = new TreeModel();
			first.id = "0";
			first.title = "客户分类设置";
			treeModels.Add(first);

			foreach (DataRow row in ds.Tables[0].Rows)
			{
			var strLen = row["hnumber"].ToString().Split('.');
			if (strLen.Length == 1)
			{
			TreeModel tree = new TreeModel();
			tree.id = row["hitemid"].ToString();
			tree.title = row["hname"].ToString();
			treeModels[0].children.Add(tree);
			}
			}
			digui(ds.Tables[0], treeModels[0].children, 2);

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucess！";
			objJsonResult.data = Newtonsoft.Json.JsonConvert.SerializeObject(treeModels);
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region 根据父id和等级获得树状图递归

			[Route("Gy_BadReason/Gy_CusTypeTreeListByLevel")]
			[HttpGet]
			public object Gy_CusTypeTreeListByLevel()
			{
			try
			{
			string sql1 = string.Format("select hitemid,hnumber,hname,hparentid,hlevel from Gy_CusType order by hnumber ");

			ds = oCN.RunProcReturn(sql1, "Gy_CusType");

			List<TreeModel> treeModels = new List<TreeModel>();
			TreeModel first = new TreeModel();
			first.id = "0";
			first.title = "客户分类设置";
			treeModels.Add(first);

			foreach (DataRow row in ds.Tables[0].Rows)
			{
			var HLevel = (int)row["hlevel"];
			if (HLevel == 1)
			{
			TreeModel tree = new TreeModel();
			tree.id = row["hitemid"].ToString();
			tree.title = row["hname"].ToString();
			treeModels[0].children.Add(tree);
			}
			}
			getTreeByLevel(ds.Tables[0], treeModels[0].children, 2);

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucess！";
			objJsonResult.data = Newtonsoft.Json.JsonConvert.SerializeObject(treeModels);
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region 客户列表文件上传
			//[Route("Gy_Customer/Gy_Process_Excel")]
			//[HttpPost]
			//public json Gy_Department_Excel()
			//{
			// json res = new json();
			// try
			// {
			// //获取文件名称
			// var file = HttpContext.Current.Request.Files[0];
			// //获取文件物理路径
			// string ExcelPath = HttpContext.Current.Server.MapPath("~/" + file.FileName);
			// //保存文件
			// file.SaveAs(ExcelPath);

			// NpoiHelper np = new NpoiHelper();
			// DataSet ExcelDs = np.ReadExcel(ExcelPath, 1, 1, "0");
			// //删除文件
			// File.Delete(ExcelPath);
			// DataTable provisional = customerService.UploadExcel(ExcelDs);

			// res.code = CodeConstant.SUCCEED;
			// res.count = CountConstant.SUCCEED;
			// res.Message = "上传成功";
			// res.data = provisional;
			// return res;
			// }
			// catch (Exception e)
			// {
			// res.code = "0";
			// res.count = 0;
			// res.Message = "Exception！" + e.ToString();
			// res.data = null;
			// return res;
			// }
			//}

			/// <summary>
			/// 判断当前职员是否存在
			/// </summary>
			/// <param name="HEmpNumber"></param>
			/// <param name="HEmpName"></param>
			/// <returns></returns>
			//private bool JudgeEmp(string HEmpNumber, string HEmpName)
			//{
			// if (!String.IsNullOrEmpty(HEmpNumber) && !String.IsNullOrEmpty(HEmpName))
			// {
			// DataSet emp = oCN.RunProcReturn("select * from Gy_Employee where HNumber = '" + HEmpNumber + "' and HName = '" + HEmpName + "'", "Gy_Employee");
			// return emp.Tables[0].Rows.Count <= EmptyConstant.EMPTY ? true : false;
			// }
			// return false;
			//}

			/// <summary>
			/// 判断列
			/// </summary>
			/// <param name="provisional"></param>
			/// <returns></returns>
			private static string JudgmentColumns(DataTable provisional)
			{
			var error = "";

			//查询没有的列
			if (!provisional.Columns.Contains("部门代码"))
			error += "没有找到【部门代码】的标题,";

			if (!provisional.Columns.Contains("部门名称"))
			error += "没有找到【部门名称】的标题,";
			return error;
			}
			#endregion

			#region 物料分类树形图(根据代码展开树状图)

			public void getTreeByLevel(DataTable dt, List<TreeModel> tree, int num)
			{
			for (int m = 0; m < tree.Count; m++)
			{
			tree[m].children = new List<TreeModel>();
			for (int i = 0; i < dt.Rows.Count; i++)//第一次循环，得到所有根节点的子集
			{
			var HLevel = (int)dt.Rows[i]["hlevel"];
			var HParentID = dt.Rows[i]["hparentid"].ToString();
			if (HLevel == num && HParentID == tree[m].id)
			{
			TreeModel tbjson = new TreeModel();
			tbjson.id = dt.Rows[i]["hitemid"].ToString();
			tbjson.title = dt.Rows[i]["hname"].ToString();
			tree[m].children.Add(tbjson);
			}
			}
			for (int i = 0; i < tree[m].children.Count; i++)
			{
			getTreeByLevel(dt, tree[m].children, num + 1);//再次用子集去循环，拿出子集的子集
			}
			}
			}
			public class TreeModel
			{
			public string id { get; set; }
			public string title { get; set; }
			public List<TreeModel> children = new List<TreeModel>();
			}

			#endregion

			#region 递归函数
			/// <summary>
			/// 递归函数
			/// </summary>
			public void digui(DataTable dt, List<TreeModel> tree, int num)
			{
			for (int m = 0; m < tree.Count; m++)
			{
			tree[m].children = new List<TreeModel>();
			for (int i = 0; i < dt.Rows.Count; i++)//第一次循环，得到所有根节点的子集
			{
			var strLen = dt.Rows[i]["hnumber"].ToString().Split('.');
			if (strLen.Length == num && dt.Rows[i]["hnumber"].ToString().Contains(tree[m].id + "."))
			{
			TreeModel tbjson = new TreeModel();
			tbjson.id = dt.Rows[i]["hitemid"].ToString();
			tbjson.title = dt.Rows[i]["hname"].ToString();
			tree[m].children.Add(tbjson);
			}
			}
			var strLens = tree[m].id.Split('.');
			for (int i = 0; i < tree[m].children.Count; i++)
			{
			digui(dt, tree[m].children, strLens.Length + 2);//再次用子集去循环，拿出子集的子集
			}
			}

			}

			}
			#endregion
			}