public static string deleteData(string strDelIDs) { if (strDelIDs.Length == 0) { return("0"); } string[] arrDelIDs = strDelIDs.Split(','); bool isSuccess = true; for (int i = 0; i < arrDelIDs.Length; i++) { TOaPartInfoVo objPart = new TOaPartInfoVo(); objPart.ID = arrDelIDs[i]; objPart.IS_DEL = "1"; isSuccess = new TOaPartInfoLogic().Edit(objPart); } if (isSuccess) { return("1"); } else { return("0"); } }
/// <summary> /// 加载数据 /// </summary> /// <returns></returns> public string frmLoadData_PART_NAME() { if (strPartId.Length == 0) { return(""); } TOaPartInfoVo objPart = new TOaPartInfoLogic().Details(strPartId); return(objPart.PART_NAME); }
/// <summary> /// 加载数据 /// </summary> /// <returns></returns> public string frmLoadData() { if (strPartId.Length == 0) { return(""); } TOaPartInfoVo objPart = new TOaPartInfoLogic().Details(strPartId); return(objPart.INVENTORY); }
public static string EditData(string strID, string strPART_CODE, string strPART_NAME, string strPART_TYPE, string strUNIT, string strMODELS, string strINVENTORY, string strMEDIUM, string strPURE, string strALARM, string strUSEING, string strREQUEST, string strNARURE, string isCheck) { bool isSuccess = true; string Msg = "0"; if (isCheck == "true") { TOaPartInfoVo obj = new TOaPartInfoVo(); obj.PART_CODE = strPART_CODE; obj.PART_NAME = strPART_NAME; obj.MODELS = strMODELS; obj.IS_DEL = "0"; obj = new TOaPartInfoLogic().SelectByObject(obj); if (obj.ID != "") { Msg = "存在相同的物料信息,请检查"; } } if (Msg == "0") { TOaPartInfoVo objPart = new TOaPartInfoVo(); objPart.ID = strID; objPart.IS_DEL = "0"; objPart.PART_CODE = strPART_CODE; objPart.PART_NAME = strPART_NAME; objPart.PART_TYPE = strPART_TYPE; objPart.UNIT = strUNIT; objPart.MODELS = strMODELS; objPart.INVENTORY = strINVENTORY; objPart.MEDIUM = strMEDIUM; objPart.PURE = strPURE; objPart.ALARM = strALARM; objPart.USEING = strUSEING; objPart.REQUEST = strREQUEST; objPart.NARURE = strNARURE; isSuccess = new TOaPartInfoLogic().Edit(objPart); if (isSuccess) { Msg = "1"; } else { Msg = "0"; } } return(Msg); }
public static string AddData(string strPART_CODE, string strPART_NAME, string strPART_TYPE, string strUNIT, string strMODELS, string strINVENTORY, string strMEDIUM, string strPURE, string strALARM, string strUSEING, string strREQUEST, string strNARURE) { bool isSuccess = true; string Msg = "0"; TOaPartInfoVo obj = new TOaPartInfoVo(); obj.PART_CODE = strPART_CODE; obj.PART_NAME = strPART_NAME; obj.MODELS = strMODELS; obj.IS_DEL = "0"; obj = new TOaPartInfoLogic().SelectByObject(obj); if (obj.ID == "") { TOaPartInfoVo objPart = new TOaPartInfoVo(); objPart.ID = GetSerialNumber("t_oa_part_info_id"); objPart.IS_DEL = "0"; objPart.PART_CODE = strPART_CODE; objPart.PART_NAME = strPART_NAME; objPart.MODELS = strMODELS; objPart.PART_TYPE = strPART_TYPE; objPart.UNIT = strUNIT; objPart.INVENTORY = strINVENTORY; objPart.MEDIUM = strMEDIUM; objPart.PURE = strPURE; objPart.ALARM = strALARM; objPart.USEING = strUSEING; objPart.REQUEST = strREQUEST; objPart.NARURE = strNARURE; isSuccess = new TOaPartInfoLogic().Create(objPart); if (isSuccess) { Msg = "1"; } else { Msg = "0"; } } else { Msg = "存在相同的物料信息,请检查"; } return(Msg); }
//获取数据 private void GetData() { string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; int intPageIdx = Convert.ToInt32(Request.Params["page"]); int intPagesize = Convert.ToInt32(Request.Params["pagesize"]); string strSrhPART_CODE = (Request.Params["SrhPART_CODE"] != null) ? Request.Params["SrhPART_CODE"] : ""; string strSrhPART_NAME = (Request.Params["SrhPART_NAME"] != null) ? Request.Params["SrhPART_NAME"] : ""; string strSrhPART_TYPE = (Request.Params["SrhPART_TYPE"] != null) ? Request.Params["SrhPART_TYPE"] : ""; if (strSrhPART_TYPE == "" && Request.Params["type"] != null) { if (Request.Params["type"].ToString() == "other") { strSrhPART_TYPE = "03,04,05,07"; } else if (Request.Params["type"].ToString() == "drugs") { strSrhPART_TYPE = "01,02"; } else if (Request.Params["type"].ToString() == "office") { strSrhPART_TYPE = "06"; } } TOaPartInfoVo objPart = new TOaPartInfoVo(); objPart.IS_DEL = "0"; objPart.PART_CODE = strSrhPART_CODE; objPart.PART_NAME = strSrhPART_NAME; objPart.PART_TYPE = strSrhPART_TYPE; objPart.SORT_FIELD = "PART_NAME asc,MODELS"; objPart.SORT_TYPE = "asc"; objPart.REMARK1 = "query";//huangjinjun add TOaPartInfoLogic logicPart = new TOaPartInfoLogic(); int intTotalCount = logicPart.GetSelectResultCount(objPart);;//总计的数据条数 DataTable dt = logicPart.SelectByTable_ByJoin(objPart, intPageIdx, intPagesize); string strJson = CreateToJson(dt, intTotalCount); Response.Write(strJson); }
protected void btnImport_Click(object sender, EventArgs e) { bool isSuccess = false; if (this.importFiles.PostedFile.ContentLength <= 0) { this.lable.Text = "请选择文件!"; this.lable.Visible = true; return; } Stream stream = this.importFiles.FileContent; HSSFWorkbook hssfworkbook = new HSSFWorkbook(stream); ISheet sheet = hssfworkbook.GetSheet("Sheet1"); sheet.Autobreaks = true; int rowNumber = sheet.LastRowNum; for (int i = 1; i <= rowNumber; i++) { string strPART_CODE = sheet.GetRow(i).GetCell(2).ToString(); string strPART_NAME = sheet.GetRow(i).GetCell(3).ToString(); string strMODELS = sheet.GetRow(i).GetCell(6).ToString(); if (string.IsNullOrEmpty(strPART_CODE) && string.IsNullOrEmpty(strPART_NAME) && string.IsNullOrEmpty(strMODELS)) { break; } TOaPartInfoVo obj = new TOaPartInfoVo(); obj.PART_CODE = strPART_CODE; obj.PART_NAME = strPART_NAME; obj.MODELS = strMODELS; obj.IS_DEL = "0"; obj = new TOaPartInfoLogic().SelectByObject(obj); if (obj.ID == "") { TOaPartInfoVo objPart = new TOaPartInfoVo(); objPart.ID = GetSerialNumber("t_oa_part_info_id"); objPart.IS_DEL = "0"; objPart.PART_CODE = strPART_CODE; objPart.PART_NAME = strPART_NAME; objPart.MODELS = strMODELS; objPart.PART_TYPE = GetDict(sheet.GetRow(i).GetCell(5).ToString()); objPart.UNIT = sheet.GetRow(i).GetCell(7).ToString(); objPart.INVENTORY = sheet.GetRow(i).GetCell(10).ToString(); objPart.MEDIUM = ""; objPart.PURE = ""; objPart.ALARM = sheet.GetRow(i).GetCell(11).ToString(); objPart.USEING = ""; objPart.REQUEST = ""; objPart.NARURE = ""; objPart.REMARK1 = sheet.GetRow(i).GetCell(4).ToString(); objPart.REMARK2 = sheet.GetRow(i).GetCell(8).ToString(); objPart.REMARK3 = sheet.GetRow(i).GetCell(9).ToString(); isSuccess = new TOaPartInfoLogic().Create(objPart); } else { continue; } } if (isSuccess) { this.lable.Text = "导入成功!"; this.lable.Visible = true; } else { this.lable.Text = "导入失败!"; this.lable.Visible = true; } }