| | |
|---|
| | | using System.Net.Http; |
|---|
| | | using System.Web.Http; |
|---|
| | | using WebAPI.Models; |
|---|
| | | |
|---|
| | | using System.Web; |
|---|
| | | using WebAPI.Controllers.SCGL.日计划管理; |
|---|
| | | using System.IO; |
|---|
| | | using SyntacticSugar.constant; |
|---|
| | | namespace WebAPI.Controllers.MJGL |
|---|
| | | { |
|---|
| | | public class Sc_MouldDotCheckRuleBillController : ApiController |
|---|
| | |
|---|
| | | |
|---|
| | | string sql = "select * from h_v_Sc_MouldDotCheckRuleBillList where 1 = 1" + sWhere + " order by hmainid desc"; |
|---|
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldDotCheckRuleBillList"); |
|---|
| | | |
|---|
| | | //添加列名 |
|---|
| | | 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列对象的列名 |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | objJsonResult.code = "1"; |
|---|
| | | objJsonResult.count = 1; |
|---|
| | | objJsonResult.Message = "Sucess！"; |
|---|
| | | objJsonResult.data = ds.Tables[0]; |
|---|
| | | objJsonResult.list = columnNameList; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | catch (Exception ex) |
|---|
| | | { |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | | objJsonResult.count = 0; |
|---|
| | | objJsonResult.Message = "没有返回任何记录！" + ex.ToString(); |
|---|
| | | objJsonResult.data = null; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | #endregion |
|---|
| | | |
|---|
| | | #region 器具点检规程单列表 |
|---|
| | | [Route("Sc_MouldDotCheckRuleBill/Sc_MouldDotCheckRuleListPDA")] |
|---|
| | | [HttpGet] |
|---|
| | | public object Sc_MouldDotCheckRuleListPDA(string sWhere, string user) |
|---|
| | | { |
|---|
| | | try |
|---|
| | | { |
|---|
| | | List<object> columnNameList = new List<object>(); |
|---|
| | | //反序列化传递的值 |
|---|
| | | //HlpBill com = JsonConvert.DeserializeObject<HlpBill>(sWhere.ToString()); |
|---|
| | | //编辑权限 |
|---|
| | | if (!DBUtility.ClsPub.Security_Log("Sc_MouldDotCheckRuleBillList", 1, false, user)) |
|---|
| | | { |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | | objJsonResult.count = 0; |
|---|
| | | objJsonResult.Message = "无查看权限！"; |
|---|
| | | objJsonResult.data = null; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | |
|---|
| | | string sql = "select * from h_v_Sc_MouldDotCheckRuleListByMould where 1 = 1" + sWhere + " order by hmainid desc"; |
|---|
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldDotCheckRuleListByMould"); |
|---|
| | | |
|---|
| | | //添加列名 |
|---|
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
|---|
| | |
|---|
| | | } |
|---|
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
|---|
| | | //获取点检项目编辑数据 |
|---|
| | | string sql = "select 点检项目ID HDotCheckItemID,点检项目代码 HDotCheckItemNumber,点检项目 HDotCheckItem,点检部位 HDotCheckPart,具体要求 HClaim,负责人ID HManagerID,负责人代码 HManagerNumber,负责人名称 HManagerName,子备注2 HRemark from h_v_Sc_MouldDotCheckRuleBillSub where 1 = 1 " + Swhere + ""; |
|---|
| | | string sql = "select * from h_v_Sc_MouldDotCheckRuleBillSub where 1 = 1 " + Swhere + ""; |
|---|
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldDotCheckRuleBillSub"); |
|---|
| | | ////获取配件项目编辑数据 |
|---|
| | | //string sql1 = "select 配件ID HMaterID,配件代码 HMaterNumber,配件名称 HMaterName,单位ID HUnitID,计量单位代码 HUnitNumber,计量单位名称 HUnitName,用量 HQty,子备注1 HRemark,标准用量 HQtyMust from h_v_Sc_MouldDotCheckRuleBillSub_Item where 1 = 1 " + Swhere + ""; |
|---|
| | |
|---|
| | | objJsonResult.count = 1; |
|---|
| | | objJsonResult.Message = "获取信息成功！"; |
|---|
| | | objJsonResult.list = list; |
|---|
| | | objJsonResult.data = ds.Tables[0]; |
|---|
| | | } |
|---|
| | | catch (Exception e) |
|---|
| | | { |
|---|
| | |
|---|
| | | [HttpGet] |
|---|
| | | public object DeleteMouldDotCheckRuleBill(string HInterID, string user) |
|---|
| | | { |
|---|
| | | if (!DBUtility.ClsPub.Security_Log("Sc_MouldMaintainRuleBill_Delete", 1, false, user)) |
|---|
| | | if (!DBUtility.ClsPub.Security_Log("Sc_MouldDotCheckPlanBill_Delete", 1, false, user)) |
|---|
| | | { |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | | objJsonResult.count = 0; |
|---|
| | |
|---|
| | | } |
|---|
| | | } |
|---|
| | | #endregion |
|---|
| | | |
|---|
| | | #region[器具点检记录表，选点检计划获取点检计划清单信息] |
|---|
| | | [Route("Sc_MouldDotCheckPlanBill/Sc_MouldDotCheckPlanBill_PlanList")] |
|---|
| | | [HttpGet] |
|---|
| | | public object Sc_MouldDotCheckPlanBill_PlanList(string HInterID, string HDate) |
|---|
| | | { |
|---|
| | | DataSet ds; |
|---|
| | | try |
|---|
| | | { |
|---|
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
|---|
| | | |
|---|
| | | ds = oCN.RunProcReturn("exec h_p_Sc_MouldDotCheck_GetPlanList " + HInterID + ",'" + HDate + "'", "h_p_Sc_MouldDotCheck_GetPlanList"); |
|---|
| | | |
|---|
| | | if (ds.Tables[0].Rows.Count != 0 || ds != null) |
|---|
| | | { |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | | objJsonResult.count = 1; |
|---|
| | | objJsonResult.Message = "获取信息成功！"; |
|---|
| | | objJsonResult.data = ds.Tables[0]; |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | | objJsonResult.count = 0; |
|---|
| | | objJsonResult.Message = "没有查询到数据信息！"; |
|---|
| | | objJsonResult.data = ds.Tables[0]; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | catch (Exception e) |
|---|
| | | { |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | | objJsonResult.count = 0; |
|---|
| | | objJsonResult.Message = "发生异常，没有返回任何计划！" + e.ToString(); |
|---|
| | | objJsonResult.data = null; |
|---|
| | | } |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | #endregion |
|---|
| | | |
|---|
| | | |
|---|
| | | #region 器具点检规程 文件导入保存 |
|---|
| | | #region 器具点检规程 文件上传 |
|---|
| | | [Route("Sc_MouldDotCheckRuleBill/Sc_MouldDotCheckRuleBill_Excel")] |
|---|
| | | [HttpPost] |
|---|
| | | public object Sc_MouldDotCheckRuleBill_Excel() |
|---|
| | | { |
|---|
| | | 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 tb2 = new DataTable("dt2"); |
|---|
| | | |
|---|
| | | //添加列名 |
|---|
| | | for (int i = 0; i < ExcelDs.Tables[0].Columns.Count; i++) |
|---|
| | | { |
|---|
| | | tb2.Columns.Add(ExcelDs.Tables[0].Rows[0][i].ToString()); |
|---|
| | | } |
|---|
| | | |
|---|
| | | //模板缺少列 但需要从数据库中查询出来显示在页面的字段 |
|---|
| | | tb2.Columns.Add("HOrgID", typeof(Int32));//组织ID |
|---|
| | | tb2.Columns.Add("HDotCheckItemID", typeof(Int32));//点检项目ID |
|---|
| | | tb2.Columns.Add("HManagerID", typeof(Int32));//负责人ID |
|---|
| | | tb2.Columns.Add("HMouldID", typeof(Int32));//器具ID |
|---|
| | | tb2.Columns.Add("HDotCheckItemClassID", typeof(Int32));//点检项目分类 |
|---|
| | | //添加数据 |
|---|
| | | for (int i = 1; i < ExcelDs.Tables[0].Rows.Count; i++) |
|---|
| | | { |
|---|
| | | DataRow row = tb2.NewRow(); |
|---|
| | | for (int j = 0; j < ExcelDs.Tables[0].Columns.Count; j++) |
|---|
| | | { |
|---|
| | | row[j] = ExcelDs.Tables[0].Rows[i][j].ToString(); |
|---|
| | | } |
|---|
| | | tb2.Rows.Add(row); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | var error = ""; |
|---|
| | | |
|---|
| | | //查询没有的列 |
|---|
| | | if (!tb2.Columns.Contains("组织代码")) |
|---|
| | | error += "没有找到【组织代码】的标题,"; |
|---|
| | | |
|---|
| | | if (!tb2.Columns.Contains("组织名称")) |
|---|
| | | error += "没有找到【组织名称】的标题,"; |
|---|
| | | |
|---|
| | | if (!tb2.Columns.Contains("规程编号")) |
|---|
| | | error += "没有找到【规程编号】的标题,"; |
|---|
| | | |
|---|
| | | if (!tb2.Columns.Contains("规程名称")) |
|---|
| | | error += "没有找到【规程名称】的标题,"; |
|---|
| | | |
|---|
| | | if (!tb2.Columns.Contains("器具编码")) |
|---|
| | | error += "没有找到【器具编码】的标题,"; |
|---|
| | | |
|---|
| | | if (!tb2.Columns.Contains("器具名称")) |
|---|
| | | error += "没有找到【器具名称】的标题,"; |
|---|
| | | |
|---|
| | | if (!tb2.Columns.Contains("周期单位")) |
|---|
| | | error += "没有找到【周期单位】的标题,"; |
|---|
| | | |
|---|
| | | if (!tb2.Columns.Contains("点检周期")) |
|---|
| | | error += "没有找到【点检周期】的标题,"; |
|---|
| | | |
|---|
| | | if (!tb2.Columns.Contains("摘要")) |
|---|
| | | error += "没有找到【摘要】的标题,"; |
|---|
| | | |
|---|
| | | if (!tb2.Columns.Contains("表头备注")) |
|---|
| | | error += "没有找到【表头备注】的标题,"; |
|---|
| | | |
|---|
| | | if (!tb2.Columns.Contains("点检项目代码")) |
|---|
| | | error += "没有找到【点检项目代码】的标题,"; |
|---|
| | | |
|---|
| | | if (!tb2.Columns.Contains("点检项目名称")) |
|---|
| | | error += "没有找到【点检项目名称】的标题,"; |
|---|
| | | |
|---|
| | | if (!tb2.Columns.Contains("点检部位")) |
|---|
| | | error += "没有找到【点检部位】的标题,"; |
|---|
| | | |
|---|
| | | if (!tb2.Columns.Contains("具体要求")) |
|---|
| | | error += "没有找到【具体要求】的标题,"; |
|---|
| | | |
|---|
| | | if (!tb2.Columns.Contains("负责人代码")) |
|---|
| | | error += "没有找到【负责人代码】的标题,"; |
|---|
| | | |
|---|
| | | if (!tb2.Columns.Contains("负责人")) |
|---|
| | | error += "没有找到【负责人】的标题,"; |
|---|
| | | |
|---|
| | | if (!tb2.Columns.Contains("表体备注")) |
|---|
| | | error += "没有找到【表体备注】的标题,"; |
|---|
| | | |
|---|
| | | if (error.Length > 0) |
|---|
| | | { |
|---|
| | | objJsonResult.code = CodeConstant.FAIL; |
|---|
| | | objJsonResult.count = CountConstant.FAIL; |
|---|
| | | objJsonResult.Message = $"Excel模板存在错误,{error}\r\n"; |
|---|
| | | objJsonResult.data = null; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | |
|---|
| | | for (int i = 0; i <= tb2.Rows.Count - 1; i++) |
|---|
| | | { |
|---|
| | | string HName = ""; |
|---|
| | | string HNum = ""; |
|---|
| | | string HORGNumber = ""; |
|---|
| | | string HORGName = ""; |
|---|
| | | string HManagerName = ""; |
|---|
| | | string HManagerNumber = ""; |
|---|
| | | string HDotCheckItemNumber = ""; |
|---|
| | | string HDotCheckItemName = ""; |
|---|
| | | string HMouldNumber = ""; |
|---|
| | | string HMouldName = ""; |
|---|
| | | |
|---|
| | | HName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["规程编号"].ToString()); |
|---|
| | | HNum = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["规程名称"].ToString()); |
|---|
| | | HMouldNumber = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["器具编码"].ToString()); |
|---|
| | | HMouldName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["器具名称"].ToString()); |
|---|
| | | HORGNumber = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["组织代码"].ToString()); |
|---|
| | | HORGName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["组织名称"].ToString()); |
|---|
| | | HManagerNumber = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["负责人代码"].ToString()); |
|---|
| | | HManagerName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["负责人"].ToString()); |
|---|
| | | HDotCheckItemNumber = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["点检项目代码"].ToString()); |
|---|
| | | HDotCheckItemName = DBUtility.ClsPub.isStrNull(tb2.Rows[i]["点检项目名称"].ToString()); |
|---|
| | | |
|---|
| | | //检查 |
|---|
| | | int index = i + 1; |
|---|
| | | //组织 |
|---|
| | | if (HORGNumber != "") |
|---|
| | | { |
|---|
| | | //查询组织 |
|---|
| | | ds = oCN.RunProcReturn("select * from Xt_ORGANIZATIONS where HNumber='" + HORGNumber + "' and Hname='" + HORGName + "'", "Xt_ORGANIZATIONS"); |
|---|
| | | |
|---|
| | | if (ds.Tables[0].Rows.Count == 0) |
|---|
| | | { |
|---|
| | | objJsonResult.code = CodeConstant.FAIL; |
|---|
| | | objJsonResult.count = CountConstant.FAIL; |
|---|
| | | objJsonResult.Message = "第" + index + "行,组织不存在！"; |
|---|
| | | objJsonResult.data = null; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | tb2.Rows[i]["HOrgID"] = ds.Tables[0].Rows[0]["HItemID"].ToString(); |
|---|
| | | } |
|---|
| | | string HORGid = ds.Tables[0].Rows[0]["HItemID"].ToString(); |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | objJsonResult.code = CodeConstant.FAIL; |
|---|
| | | objJsonResult.count = CountConstant.FAIL; |
|---|
| | | objJsonResult.Message = "第" + index + "行,组织代码为空"; |
|---|
| | | objJsonResult.data = null; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | //器具 |
|---|
| | | if (HMouldNumber != "") |
|---|
| | | { |
|---|
| | | ds = oCN.RunProcReturn("select * from Gy_MouldFileMain where HMouldNo='" + HMouldNumber + "' and Hname='" + HMouldName + "'", "Gy_MouldFileMain"); |
|---|
| | | |
|---|
| | | if (ds.Tables[0].Rows.Count == 0) |
|---|
| | | { |
|---|
| | | objJsonResult.code = CodeConstant.FAIL; |
|---|
| | | objJsonResult.count = CountConstant.FAIL; |
|---|
| | | objJsonResult.Message = "第" + index + "行,器具不存在！"; |
|---|
| | | objJsonResult.data = null; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | tb2.Rows[i]["HMouldID"] = ds.Tables[0].Rows[0]["HInterID"].ToString(); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | objJsonResult.code = CodeConstant.FAIL; |
|---|
| | | objJsonResult.count = CountConstant.FAIL; |
|---|
| | | objJsonResult.Message = "第" + index + "行,器具代码为空"; |
|---|
| | | objJsonResult.data = null; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | //点检项目代码 |
|---|
| | | if (HDotCheckItemNumber != "") |
|---|
| | | { |
|---|
| | | |
|---|
| | | ds = oCN.RunProcReturn("select * from Gy_DotCheck where HNumber='" + HDotCheckItemNumber + "' and Hname='" + HDotCheckItemName + "'", "Gy_DotCheck"); |
|---|
| | | |
|---|
| | | if (ds.Tables[0].Rows.Count == 0) |
|---|
| | | { |
|---|
| | | objJsonResult.code = CodeConstant.FAIL; |
|---|
| | | objJsonResult.count = CountConstant.FAIL; |
|---|
| | | objJsonResult.Message = "第" + index + "行,点检项目不存在！"; |
|---|
| | | objJsonResult.data = null; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | tb2.Rows[i]["HDotCheckItemID"] = ds.Tables[0].Rows[0]["HItemID"].ToString(); |
|---|
| | | tb2.Rows[i]["HDotCheckItemClassID"] = ds.Tables[0].Rows[0]["HDotCheckItemClassID"].ToString(); |
|---|
| | | } |
|---|
| | | string HDotCheckItemID = ds.Tables[0].Rows[0]["HItemID"].ToString(); |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | objJsonResult.code = CodeConstant.FAIL; |
|---|
| | | objJsonResult.count = CountConstant.FAIL; |
|---|
| | | objJsonResult.Message = "第" + index + "行,点检项目代码为空"; |
|---|
| | | objJsonResult.data = null; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | //负责人代码 |
|---|
| | | if (HManagerNumber != "") |
|---|
| | | { |
|---|
| | | //查询组织 |
|---|
| | | ds = oCN.RunProcReturn("select * from Gy_Employee where HNumber='" + HManagerNumber + "' and Hname='" + HManagerName + "'", "Gy_Employee"); |
|---|
| | | |
|---|
| | | if (ds.Tables[0].Rows.Count == 0) |
|---|
| | | { |
|---|
| | | objJsonResult.code = CodeConstant.FAIL; |
|---|
| | | objJsonResult.count = CountConstant.FAIL; |
|---|
| | | objJsonResult.Message = "第" + index + "行,负责人不存在！"; |
|---|
| | | objJsonResult.data = null; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | tb2.Rows[i]["HManagerID"] = ds.Tables[0].Rows[0]["HItemID"].ToString(); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | //器具点检规程名称 |
|---|
| | | if (HName == "") |
|---|
| | | { |
|---|
| | | objJsonResult.code = CodeConstant.FAIL; |
|---|
| | | objJsonResult.count = CountConstant.FAIL; |
|---|
| | | objJsonResult.Message = "第" + index + "行,器具点检规程名称不能为空！"; |
|---|
| | | objJsonResult.data = null; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | |
|---|
| | | //器具点检规程代码 |
|---|
| | | if (HNum == "") |
|---|
| | | { |
|---|
| | | objJsonResult.code = CodeConstant.FAIL; |
|---|
| | | objJsonResult.count = CountConstant.FAIL; |
|---|
| | | objJsonResult.Message = "第" + index + "行,器具点检规程代码不能为空！"; |
|---|
| | | objJsonResult.data = null; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | objJsonResult.code = CodeConstant.SUCCEED; |
|---|
| | | objJsonResult.count = CountConstant.SUCCEED; |
|---|
| | | objJsonResult.Message = error; |
|---|
| | | objJsonResult.data = tb2; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | catch (Exception e) |
|---|
| | | { |
|---|
| | | objJsonResult.code = CodeConstant.FAIL; |
|---|
| | | objJsonResult.count = CountConstant.FAIL; |
|---|
| | | objJsonResult.Message = "Exception！" + e.ToString(); |
|---|
| | | objJsonResult.data = null; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | #endregion |
|---|
| | | |
|---|
| | | #region 器具点检规程项目 导入(保存) |
|---|
| | | [Route("Sc_MouldDotCheckRuleBill/Sc_MouldDotCheckRuleBill_btnSave")] |
|---|
| | | [HttpPost] |
|---|
| | | public object Sc_MouldDotCheckRuleBill_btnSave([FromBody] JObject sMainSub) |
|---|
| | | { |
|---|
| | | var _value = sMainSub["sMainSub"].ToString(); |
|---|
| | | string msg1 = _value.ToString(); |
|---|
| | | string[] sArray = msg1.Split(new string[] { "&和" }, StringSplitOptions.RemoveEmptyEntries); |
|---|
| | | string msg2 = sArray[0].ToString(); |
|---|
| | | string user = sArray[1].ToString(); |
|---|
| | | try |
|---|
| | | { |
|---|
| | | if (!DBUtility.ClsPub.Security_Log("Sc_MouldDotCheckRuleBill_Edit", 1, false, user)) |
|---|
| | | { |
|---|
| | | objJsonResult.code = CodeConstant.FAIL; |
|---|
| | | objJsonResult.count = CountConstant.FAIL; |
|---|
| | | objJsonResult.Message = "无保存权限！"; |
|---|
| | | objJsonResult.data = null; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | |
|---|
| | | List<object> Excel = Newtonsoft.Json.JsonConvert.DeserializeObject<List<object>>(msg2); |
|---|
| | | List<Dictionary<string, string>> list = new List<Dictionary<string, string>>(); |
|---|
| | | |
|---|
| | | foreach (JObject item in Excel) |
|---|
| | | { |
|---|
| | | Dictionary<string, string> dic = new Dictionary<string, string>(); |
|---|
| | | foreach (var itm in item.Properties()) |
|---|
| | | { |
|---|
| | | dic.Add(itm.Name, itm.Value.ToString()); |
|---|
| | | } |
|---|
| | | list.Add(dic); |
|---|
| | | } |
|---|
| | | |
|---|
| | | oCN.BeginTran(); |
|---|
| | | int i = 1; |
|---|
| | | foreach (Dictionary<string, string> item in list) |
|---|
| | | { |
|---|
| | | string HBillType = "3834"; |
|---|
| | | string HMaker = user;//制单人 |
|---|
| | | DateTime HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));// --日期 |
|---|
| | | long HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); |
|---|
| | | long HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month); |
|---|
| | | string HOrgID = item["HOrgID"].ToString();//组织ID |
|---|
| | | string HMouldID = item["HMouldID"].ToString();//器具ID |
|---|
| | | string HName = item["规程名称"].ToString(); |
|---|
| | | string HBillNo = item["规程编号"].ToString(); |
|---|
| | | string HCycleUnit = item["周期单位"].ToString(); |
|---|
| | | string HCheckCycle = item["点检周期"].ToString(); |
|---|
| | | string HExplanation = item["摘要"].ToString(); |
|---|
| | | string HRemark = item["表头备注"].ToString(); |
|---|
| | | //子表 |
|---|
| | | string HDotCheckItemID = item["HDotCheckItemID"].ToString();//点检项目 |
|---|
| | | string HDotCheckItemClassID = item["HDotCheckItemClassID"].ToString();//点检分类项目 |
|---|
| | | string HManagerID = item["HManagerID"].ToString()==""? "0": item["HManagerID"].ToString();//负责人 |
|---|
| | | string HDotCheckPart = item["点检部位"].ToString(); |
|---|
| | | string HClaim = item["具体要求"].ToString(); |
|---|
| | | string HSubRemark = item["表体备注"].ToString(); |
|---|
| | | string HDotCheckItem = item["点检项目名称"].ToString(); |
|---|
| | | ds = oCN.RunProcReturn("select * from Sc_MouldDotCheckRuleBillMain where HBillNo='" + HBillNo + "'", "Sc_MouldDotCheckRuleBillMain"); |
|---|
| | | |
|---|
| | | if (ds.Tables[0].Rows.Count == 0) |
|---|
| | | { |
|---|
| | | long HInterID = DBUtility.ClsPub.CreateBillID(HBillType, ref DBUtility.ClsPub.sExeReturnInfo); |
|---|
| | | //插入主表 |
|---|
| | | oCN.RunProc("Insert Into Sc_MouldDotCheckRuleBillMain " + |
|---|
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + |
|---|
| | | ",HYear,HPeriod,HRemark,HMaker,HMakeDate" + |
|---|
| | | ",HMouldID,HBeginDate,HEndDate,HCycleUnit,HCheckCycle,HExplanation,HInnerBillNo" + |
|---|
| | | ") " + |
|---|
| | | " values('" + HBillType + "','" + HBillType + "'," + HInterID.ToString() + ",'" + HBillNo + "','" + HDate + "'" + |
|---|
| | | ", " + HYear.ToString() + "," + HPeriod.ToString() + ",'" + HRemark + "','" + HMaker + "',getdate()" + |
|---|
| | | ", " + HMouldID.ToString() + ", '" + DateTime.Now.ToShortDateString() + "','" + DateTime.Now.AddMonths(1).ToShortDateString() + "','" + HCycleUnit + "', " + HCheckCycle.ToString() + ",'" + HExplanation + "','" + "" + "'" + |
|---|
| | | |
|---|
| | | ") "); |
|---|
| | | //插入子表 |
|---|
| | | oCN.RunProc("Insert into Sc_MouldDotCheckRuleBillSub " + |
|---|
| | | " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" + |
|---|
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + |
|---|
| | | ",HDotCheckItemID,HDotCheckItem,HDotCheckPart,HClaim,HManagerID,HDotCheckItemClassID,HDotCheckItemMethodID" + |
|---|
| | | ") values(" |
|---|
| | | + HInterID.ToString() + "," + 1 + ",'" + "" + "'," + DateTime.Now.ToShortDateString() + "," + Convert.ToString(false ? 1 : 0) + ",'" + HSubRemark + "'" + |
|---|
| | | "," + 0 + "," + 0 + ",'" + "" + "','" + "" + "'," + 0 + "," + 0 + |
|---|
| | | "," + HDotCheckItemID.ToString() + ",'" + HDotCheckItem + "','" + HDotCheckPart + "','" + HClaim + "'," + HManagerID.ToString() + "," + HDotCheckItemClassID + "," + 0 + |
|---|
| | | ") "); |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | long HInterID = long.Parse(ds.Tables[0].Rows[0]["HInterID"].ToString()); |
|---|
| | | //获取最大子id |
|---|
| | | DataSet ds2 = oCN.RunProcReturn("select max(HEntryID) HEntryID from Sc_MouldDotCheckRuleBillSub where HInterID='" + HInterID + "'", "Sc_MouldDotCheckRuleBillSub"); |
|---|
| | | long HEntryID = 1; |
|---|
| | | if (ds2.Tables[0].Rows.Count > 0) |
|---|
| | | { |
|---|
| | | HEntryID = long.Parse(ds2.Tables[0].Rows[0]["HEntryID"].ToString()) + 1; |
|---|
| | | } |
|---|
| | | //插入子表 |
|---|
| | | oCN.RunProc("Insert into Sc_MouldDotCheckRuleBillSub " + |
|---|
| | | " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" + |
|---|
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + |
|---|
| | | ",HDotCheckItemID,HDotCheckItem,HDotCheckPart,HClaim,HManagerID,HDotCheckItemClassID,HDotCheckItemMethodID" + |
|---|
| | | ") values(" |
|---|
| | | + HInterID.ToString() + "," + HEntryID + ",'" + "" + "'," + DateTime.Now.ToShortDateString() + "," + Convert.ToString(false ? 1 : 0) + ",'" + HSubRemark + "'" + |
|---|
| | | "," + 0 + "," + 0 + ",'" + "" + "','" + "" + "'," + 0 + "," + 0 + |
|---|
| | | "," + HDotCheckItemID.ToString() + ",'" + HDotCheckItem + "','" + HDotCheckPart + "','" + HClaim + "'," + HManagerID.ToString() + "," + HDotCheckItemClassID + "," + 0 + |
|---|
| | | ") "); |
|---|
| | | } |
|---|
| | | |
|---|
| | | i++; |
|---|
| | | } |
|---|
| | | |
|---|
| | | oCN.Commit(); |
|---|
| | | |
|---|
| | | objJsonResult.code = CodeConstant.SUCCEED; |
|---|
| | | objJsonResult.count = CountConstant.SUCCEED; |
|---|
| | | objJsonResult.Message = "导入成功!"; |
|---|
| | | objJsonResult.data = null; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | catch (Exception e) |
|---|
| | | { |
|---|
| | | LogService.Write(e); |
|---|
| | | oCN.RollBack(); |
|---|
| | | objJsonResult.code = CodeConstant.FAIL; |
|---|
| | | objJsonResult.count = CountConstant.FAIL; |
|---|
| | | objJsonResult.Message = "Exception！" + e.ToString(); |
|---|
| | | objJsonResult.data = null; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | #endregion |
|---|
| | | #endregion |
|---|
| | | |
|---|
| | | } |
|---|
| | | } |
|---|
