| | |
|---|
| | | { |
|---|
| | | try |
|---|
| | | { |
|---|
| | | List<object> columnNameList = new List<object>(); //定义声明变量 ，把通过 new List<object>()创建的 实例，赋值给变量 |
|---|
| | | //判断查询权限 |
|---|
| | | if (!DBUtility.ClsPub.Security_Log("Xs_SeOrderBillQuery", 1, false, user)) |
|---|
| | | { |
|---|
| | |
|---|
| | | string sql = sql1 + sWhere+ " order by hmainid desc,hsubid asc"; |
|---|
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_SeOrderBillList"); |
|---|
| | | } |
|---|
| | | foreach (DataColumn col in ds.Tables[0].Columns)//遍历ds中第一个表（Tables[0]）的所有列（Columns）每次循环中，col变量会持有当前列的引用 |
|---|
| | | { |
|---|
| | | Type dataType = col.DataType; //获取当前数据类型传入 自定义变量datadataType |
|---|
| | | string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; //字符串拼接 // 将列名和数据类型信息拼接成一个JSON格式的字符串 |
|---|
| | | columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名 |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | objJsonResult.code = "1"; |
|---|
| | | objJsonResult.count = 1; |
|---|
| | | objJsonResult.Message = "Sucess！"; |
|---|
| | | objJsonResult.data = ds.Tables[0]; |
|---|
| | | objJsonResult.list = columnNameList;//将columnNameList赋值给objJsonResult的list属性 |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | catch (Exception e) |
|---|
| | |
|---|
| | | { |
|---|
| | | try |
|---|
| | | { |
|---|
| | | //LogService.Write("销售订单同步,保存方法执行完成异常：" + sMainSub.ToString()); |
|---|
| | | LogService.Write("销售订单同步：" + sMainSub.ToString()); |
|---|
| | | var model = sMainSub["model"].ToString(); |
|---|
| | | var entry = sMainSub["model"]["HENTRY"].ToString(); |
|---|
| | | |
|---|
| | |
|---|
| | | oCN.RunProc(sql); |
|---|
| | | sql = $"delete Xs_SeOrderBillSub where HinterID = {mainList[0].HInterID}"; |
|---|
| | | oCN.RunProc(sql); |
|---|
| | | |
|---|
| | | LogService.Write("销售订单同步：" + @"Insert Into Xs_SeOrderBillMain |
|---|
| | | (HInterID, HYear, HPeriod, HBillType, HBillSubType, HDate |
|---|
| | | , HBillNo, HBillStatus |
|---|
| | | , HAddress, HSSID, HSSDate, HCusID, HCurID, HExRate |
|---|
| | | , HEmpID, HManagerID, HDeptID, HExplanation, HRemark, HInnerBillNo |
|---|
| | | , HChecker, HCheckDate, HMaker, HMakeDate, HCloseMan, HCloseDate |
|---|
| | | , HERPInterID, HERPBillType, HSALEORGID, HSALEGROUPID, HRECEIVEID, HSETTLEID |
|---|
| | | , HCHARGEID, HHEADLOCID, HRECCONTACTID, HCORRESPONDORGID, HBUSINESSTYPE) |
|---|
| | | values(" + mainList[0].HInterID + ", " + DateTime.Now.Year + ", " + DateTime.Now.Month + ", '" + 1401 + "', '" + |
|---|
| | | mainList[0].HBillSubType + "','" + mainList[0].HDate + "','" + mainList[0].HBillNo + "','" + mainList[0].HBillStatus + "','" + mainList[0].HAddress + "'," + mainList[0].HSSID + |
|---|
| | | ",'" + mainList[0].HSSDate + "'," + mainList[0].HCusID + "," + mainList[0].HCurID + "," + mainList[0].HExRate + "," + mainList[0].HEmpID + "," + mainList[0].HManagerID + "," + mainList[0].HDeptID + ",'" + mainList[0].HExplanation + "','" + mainList[0].HRemark + "','" + |
|---|
| | | mainList[0].HInnerBillNo + "','" + mainList[0].HChecker + "','" + mainList[0].HCheckDate + "','" + mainList[0].HMaker + "','" + mainList[0].HMakeDate + "','" |
|---|
| | | + mainList[0].HCloseMan + "','" + mainList[0].HCloseDate + "'," + mainList[0].HERPInterID + ",'" |
|---|
| | | + mainList[0].HERPBillType + "'," + mainList[0].HSALEORGID + "," + mainList[0].HSALEGROUPID + "," + mainList[0].HRECEIVEID + "," + mainList[0].HSETTLEID + "," + mainList[0].HCHARGEID + "," + mainList[0].HHEADLOCID + "," + mainList[0].HRECCONTACTID + "," + mainList[0].HCORRESPONDORGID + ",'" + mainList[0].HBUSINESSTYPE + "'" + ")"); |
|---|
| | | //主表 |
|---|
| | | oCN.RunProc(@"Insert Into Xs_SeOrderBillMain |
|---|
| | | (HInterID,HYear,HPeriod,HBillType,HBillSubType,HDate |
|---|
