public List <ProjectCostModel> GetModels(SqlTransaction Transaction) { List <ProjectCostModel> list; try { list = new ProjectCostDAL(Transaction).Select(); } catch (Exception exception) { throw exception; } return(list); }
public ProjectCostModel GetModel(int Code, SqlTransaction Transaction) { ProjectCostModel model; try { model = new ProjectCostDAL(Transaction).GetModel(Code); } catch (Exception exception) { throw exception; } return(model); }
public List <ProjectCostModel> GetModels(ProjectCostQueryModel ObjQueryModel, SqlConnection Connection) { List <ProjectCostModel> list; try { list = new ProjectCostDAL(Connection).Select(ObjQueryModel); } catch (Exception exception) { throw exception; } return(list); }
public int Delete(int Code, SqlTransaction Transaction) { int num; try { num = new ProjectCostDAL(Transaction).Delete(Code); } catch (Exception exception) { throw exception; } return(num); }
public int Update(ProjectCostModel ObjModel, SqlTransaction Transaction) { int num; try { ProjectCostDAL tdal = new ProjectCostDAL(Transaction); ObjModel.InputDate = DateTime.Now; num = tdal.Update(ObjModel); } catch (Exception exception) { throw exception; } return(num); }
private string ImportSingle(string val) { try { string[] arr = ImportRule.SplitCsvLine(val); if (arr.Length < base.MinColCount) { return(string.Format("列不足{0}个", base.MinColCount)); } string text = arr[0].Trim(); if (text == "") { return("项目名称为空"); } string text2 = arr[1].Trim(); string text3 = ""; if (text2 != "") { DataRow[] rowArray = this.m_tbSystemGroup.Select("FullName = '" + text2 + "'"); if (rowArray.Length > 0) { text3 = rowArray[0]["GroupCode"].ToString(); } } if (text3 == "") { return(string.Format("未知的费用项“{0}”", text2)); } ProjectCostDAL tdal = new ProjectCostDAL(this.conn); ProjectCostModel mObj = new ProjectCostModel(); mObj.ProjectCostCode = int.Parse(SystemManageDAO.GetNewSysCode("ProjectCostCode")); mObj.ProjectName = text; mObj.GroupCode = text3; mObj.Unit = ConvertRule.ToString(ConvertRule.GetArrayItem(arr, 3)).Trim(); mObj.InputPerson = this.InputPerson; try { if (ConvertRule.ToString(ConvertRule.GetArrayItem(arr, 2)).Trim() == "") { mObj.Area = 0M; } else { mObj.Area = decimal.Parse(ConvertRule.ToString(ConvertRule.GetArrayItem(arr, 2)).Trim()); } } catch { return(string.Format("面积“{0}”不是有效的数值", ConvertRule.ToString(ConvertRule.GetArrayItem(arr, 2)).Trim())); } try { if (ConvertRule.ToString(ConvertRule.GetArrayItem(arr, 3)).Trim() == "") { mObj.Price = 0M; } else { mObj.Price = decimal.Parse(ConvertRule.ToString(ConvertRule.GetArrayItem(arr, 3)).Trim()); } } catch { return(string.Format("单方造价“{0}”不是有效的数值", ConvertRule.ToString(ConvertRule.GetArrayItem(arr, 3)).Trim())); } try { if (ConvertRule.ToString(ConvertRule.GetArrayItem(arr, 4)).Trim() == "") { mObj.Money = 0M; } else { mObj.Money = decimal.Parse(ConvertRule.ToString(ConvertRule.GetArrayItem(arr, 4)).Trim()); } } catch { return(string.Format("总价“{0}”不是有效的数值", ConvertRule.ToString(ConvertRule.GetArrayItem(arr, 4)).Trim())); } try { if (ConvertRule.ToString(ConvertRule.GetArrayItem(arr, 5)).Trim() == "") { mObj.Qty = 0M; } else { mObj.Qty = decimal.Parse(ConvertRule.ToString(ConvertRule.GetArrayItem(arr, 5)).Trim()); } } catch { return(string.Format("数量“{0}”不是有效的数值", ConvertRule.ToString(ConvertRule.GetArrayItem(arr, 5)).Trim())); } if (((mObj.Money == 0M) && (mObj.Price != 0M)) && (mObj.Area != 0M)) { mObj.Money = Math.Round((decimal)(mObj.Price * mObj.Area), 2); } if (((mObj.Price == 0M) && (mObj.Money != 0M)) && (mObj.Area != 0M)) { mObj.Price = Math.Round((decimal)(mObj.Money / mObj.Area), 2); } mObj.Remark = ConvertRule.ToString(ConvertRule.GetArrayItem(arr, 5)).Trim(); tdal.Insert(mObj); } catch (Exception exception) { throw exception; } return(""); }