public bool Validate(string type, YwTxjs entity, ref string errmsg) { switch (type) { case "all": #region validate all if (entity.Txm.Trim() == "") { errmsg = "推修码不能为空"; return(false); } if (entity.Xs.Trim() == "") { entity.Xs = "0"; } else { try { decimal temp = decimal.Parse(entity.Xs); } catch { errmsg = "系数格式不正确,应该是为数字"; return(false); } } #endregion break; } return(true); }
public bool CheckExist(string Txm) { YwTxjs t1 = new YwTxjs(); t1.Txm = Txm; int count = baseDao.Count(t1); if (count > 0) { return(true); } return(false); }
public XSSFWorkbook Export() { XSSFWorkbook book = new XSSFWorkbook(); ISheet sheet = book.CreateSheet("specExport"); IRow row = sheet.CreateRow(0); CreateHead(row); YwTxjs param = new YwTxjs(); IList <YwTxjs> list = baseDao.List(param); int i = 0; foreach (YwTxjs temp in list) { i += 1; IRow rowT = sheet.CreateRow(i); CreateRow(rowT, temp); } return(book); }
private void CreateRow(IRow row, YwTxjs entity) { ICell cell = row.CreateCell(0); cell.SetCellValue(entity.Txm); cell.SetCellType(CellType.String); ICell cell1 = row.CreateCell(1); cell1.SetCellType(CellType.String); cell1.SetCellValue(entity.Xlc); ICell cell2 = row.CreateCell(2); cell2.SetCellType(CellType.String); cell2.SetCellValue(entity.Zy); ICell cell3 = row.CreateCell(3); cell3.SetCellType(CellType.String); cell3.SetCellValue(entity.Xs); }
private bool Save(Framework.Task.Task task, ref string errmsg) { bool result = true; YwTxjsService service = new YwTxjsService(); YwTxjs entity = task.Entity as YwTxjs; if (service.Validate("all", entity, ref errmsg) == false) { return(false); } BaseDao baseDao = new BaseDao(); if (entity.Did > 0) { baseDao.Update(entity); } else { YwTxjs temp = new YwTxjs(); temp.Txm = entity.Txm; int count = baseDao.Count(temp); if (count > 0) { errmsg = "该推修码已经被定义"; return(false); } baseDao.Insert(entity); } if (result == true) { errmsg = "保存成功"; task.ParentRebind = true; task.IsClose = true; } return(result); }
private bool Delete(Framework.Task.Task task, ref string errmsg) { YwTxjs delModel = new YwTxjs(); delModel.SysKey = task.CommandArgument; BaseDao baseDao = new BaseDao(); try { baseDao.Delete(delModel); } catch (Exception ex) { errmsg = ex.Message; return(false); } if (errmsg != "") { return(false); } errmsg = "删除成功"; task.Rebind = true; return(true); }
private void DealRow(int rowIndex, IRow row) { YwTxjs temp = new YwTxjs(); for (int index = 0; index < row.Cells.Count; index++) { ICell cell = row.GetCell(index); cell.SetCellType(CellType.String); switch (index) { case 0: try { if (cell.StringCellValue.Trim() == "") { return; } temp.Txm = cell.StringCellValue.Trim(); if (temp.Txm == "") { throw new Exception("第" + rowIndex + "行 推修码 不能为空"); } } catch { throw new Exception("第" + rowIndex + "行 推修码 不能为空"); } break; case 1: try { if (cell.StringCellValue.Trim() == "") { temp.Xlc = ""; } else { temp.Xlc = cell.StringCellValue.Trim(); } } catch { temp.Xlc = ""; } break; case 2: try { if (cell.StringCellValue.Trim() == "") { return; } temp.Zy = cell.StringCellValue.Trim(); if (temp.Zy == "") { throw new Exception("第" + rowIndex + "行 有无专员 不能为空"); } else { if (temp.Zy != "有" && temp.Zy != "无") { throw new Exception("第" + rowIndex + "行 有无专员 不能为空"); } } } catch { throw new Exception("第" + rowIndex + "行 有无专员 内容应该为 有 或者 无"); } break; case 3: decimal temp1 = 0; try { temp1 = decimal.Parse(cell.StringCellValue.Trim()); } catch (Exception ex) { throw new Exception("第" + rowIndex + "行 推修系数值格式不正确,应该在0和100之间的数字"); } temp.Xs = cell.StringCellValue.Trim(); break; } } if (this.CheckExist(temp.Txm) == true) { throw new Exception("第" + rowIndex + " 行 [" + temp.Txm + "]该推修码已经被定义"); } baseDao.Insert(temp); }