/// <summary> /// 初始化数据 /// </summary> /// <param name="ut"></param> private void OnStartData(T_ProjectBudgetEntity ut) { ProjectNO_Input.Text = ProjectNO_Disp.Text = ut.ProjectNO.ToString(); SubjectNO_Input.Text = SubjectNO_Disp.Text = ut.SubjectNO.ToString(); ClassNO_Input.Text = ClassNO_Disp.Text = ut.ClassNO.ToString(); AnnualNO_Input.Text = AnnualNO_Disp.Text = ut.AnnualNO.ToString(); BudgetRevenue_Input.Text = BudgetRevenue_Disp.Text = ut.BudgetRevenue.ToString(); BudgetExpenditure_Input.Text = BudgetExpenditure_Disp.Text = ut.BudgetExpenditure.ToString(); BalanceAmount_Input.Text = BalanceAmount_Disp.Text = ut.BalanceAmount.ToString(); Leader_Input.Text = Leader_Disp.Text = ut.Leader.ToString(); Undertaker_Input.Text = Undertaker_Disp.Text = ut.Undertaker.ToString(); State_Input.Text = State_Disp.Text = ut.State.ToString(); CreateTime_Input.Text = CreateTime_Disp.Text = ut.CreateTime.ToString(); UpdateTime_Input.Text = UpdateTime_Disp.Text = ut.UpdateTime.ToString(); Sort_Input.Text = Sort_Disp.Text = ut.Sort.ToString(); DepartmentID_Input.Text = DepartmentID_Disp.Text = ut.DepartmentID.ToString(); }
protected void Button2_Click(object sender, EventArgs e) { string Checkbox_Value = (string)Common.sink("Checkbox", MethodType.Post, 2000, 1, DataType.Str); string[] Checkbox_Value_Array = Checkbox_Value.Split(','); Int32 IDX = 0; for (int i = 0; i < Checkbox_Value_Array.Length; i++) { if (Int32.TryParse(Checkbox_Value_Array[i], out IDX)) { T_ProjectBudgetEntity et = new T_ProjectBudgetEntity(); et.DataTable_Action_ = DataTable_Action.Delete; et.ID = IDX; BusinessFacadeShanlitech_Location.T_ProjectBudgetInsertUpdateDelete(et); } } EventMessage.MessageBox(1, "批量删除成功", string.Format("批量删除({0})成功!", Checkbox_Value), Icon_Type.OK, Common.GetHomeBaseUrl("default.aspx")); }
/// <summary> /// 新增/删除/修改 T_ProjectBudgetEntity (项目预算) /// </summary> /// <param name="fam">T_ProjectBudgetEntity实体类</param> /// <returns>-1:存储过程执行失败,-2:存在相同的主键,Insert:返回插入自动ID,Update:返回更新记录数,Delete:返回删除记录数</returns> public static Int32 T_ProjectBudgetInsertUpdateDelete(T_ProjectBudgetEntity fam) { return DataProvider.Instance().T_ProjectBudgetInsertUpdateDelete(fam); }
/// <summary> /// 根据ID返回 T_ProjectBudgetEntity实体类 单笔资料 (项目预算) /// </summary> /// <param name="ID">ID 项目编号</param> /// <returns>返回 T_ProjectBudgetEntity实体类 ID为0则无记录</returns> public static T_ProjectBudgetEntity T_ProjectBudgetDisp(Int32 ID) { T_ProjectBudgetEntity fam = new T_ProjectBudgetEntity(); QueryParam qp = new QueryParam(); qp.PageIndex = 1; qp.PageSize = 1; qp.Where = string.Format(" Where {0}.{1} = {2}", "T_ProjectBudget", "ID", ID); int RecordCount = 0; List<T_ProjectBudgetEntity> lst = T_ProjectBudgetList(qp, out RecordCount); if (RecordCount > 0) { fam = lst[0]; } return fam; }
/// <summary> /// 将记录集转为T_ProjectBudgetEntity实体类 (项目预算) /// </summary> /// <param name="dr">记录集</param> /// <param name="Fileds">字段名列表</param> /// <returns>T_ProjectBudgetEntity</returns> protected T_ProjectBudgetEntity PopulateT_ProjectBudgetEntity(IDataReader dr, Dictionary<string, string> Fileds) { T_ProjectBudgetEntity nc = new T_ProjectBudgetEntity(); if (Fileds.ContainsKey("ID") && !Convert.IsDBNull(dr["ID"])) nc.ID = Convert.ToInt32(dr["ID"]); // 项目编号 if (Fileds.ContainsKey("ProjectNO") && !Convert.IsDBNull(dr["ProjectNO"])) nc.ProjectNO = Convert.ToString(dr["ProjectNO"]).Trim(); // 项目编号 if (Fileds.ContainsKey("SubjectNO") && !Convert.IsDBNull(dr["SubjectNO"])) nc.SubjectNO = Convert.ToString(dr["SubjectNO"]).Trim(); // 所属科目 if (Fileds.ContainsKey("ClassNO") && !Convert.IsDBNull(dr["ClassNO"])) nc.ClassNO = Convert.ToString(dr["ClassNO"]).Trim(); // 所属类别 if (Fileds.ContainsKey("AnnualNO") && !Convert.IsDBNull(dr["AnnualNO"])) nc.AnnualNO = Convert.ToString(dr["AnnualNO"]).Trim(); // 所属年度 if (Fileds.ContainsKey("BudgetRevenue") && !Convert.IsDBNull(dr["BudgetRevenue"])) nc.BudgetRevenue = Convert.ToDouble(dr["BudgetRevenue"]); // 预算收入 if (Fileds.ContainsKey("BudgetExpenditure") && !Convert.IsDBNull(dr["BudgetExpenditure"])) nc.BudgetExpenditure = Convert.ToDouble(dr["BudgetExpenditure"]); // 预算支出 if (Fileds.ContainsKey("BalanceAmount") && !Convert.IsDBNull(dr["BalanceAmount"])) nc.BalanceAmount = Convert.ToDouble(dr["BalanceAmount"]); // 经费余额 if (Fileds.ContainsKey("Leader") && !Convert.IsDBNull(dr["Leader"])) nc.Leader = Convert.ToInt32(dr["Leader"]); // 项目组长 if (Fileds.ContainsKey("Undertaker") && !Convert.IsDBNull(dr["Undertaker"])) nc.Undertaker = Convert.ToInt32(dr["Undertaker"]); // 指定承办人 if (Fileds.ContainsKey("State") && !Convert.IsDBNull(dr["State"])) nc.State = Convert.ToInt32(dr["State"]); // 状态(0为正常,9为删除) if (Fileds.ContainsKey("CreateTime") && !Convert.IsDBNull(dr["CreateTime"])) nc.CreateTime = Convert.ToDateTime(dr["CreateTime"]); // 创建时间 if (Fileds.ContainsKey("UpdateTime") && !Convert.IsDBNull(dr["UpdateTime"])) nc.UpdateTime = Convert.ToDateTime(dr["UpdateTime"]); // 更新时间 if (Fileds.ContainsKey("Sort") && !Convert.IsDBNull(dr["Sort"])) nc.Sort = Convert.ToInt32(dr["Sort"]); // 递增排序 if (Fileds.ContainsKey("DepartmentID") && !Convert.IsDBNull(dr["DepartmentID"])) nc.DepartmentID = Convert.ToInt32(dr["DepartmentID"]); // 所在部门 return nc; }
/// <summary> /// 新增/删除/修改 T_ProjectBudgetEntity (项目预算) /// </summary> /// <param name="fam">T_ProjectBudget实体类</param> /// <returns>-1:存储过程执行失败,-2:存在相同的主键,Insert:返回插入自动ID,Update:返回更新记录数,Delete:返回删除记录数</returns> public abstract Int32 T_ProjectBudgetInsertUpdateDelete(T_ProjectBudgetEntity fam);
/// <summary> /// 获得项目显示格式 /// </summary> /// <param name="entity"></param> /// <returns></returns> public static string GetProjectBudgetFormat(T_ProjectBudgetEntity entity) { string projectformat = string.Empty; if (entity == null) { return projectformat; } try { projectformat = string.Format("{0},{1},{2},{3}", BusinessFacadeShanlitech_Location.GetClassNameByID(Convert.ToInt32(entity.ClassNO)), BusinessFacadeShanlitech_Location.GetSubjectNameByID(Convert.ToInt32(entity.SubjectNO)), BusinessFacadeShanlitech_Location.GetProjectNameByID(Convert.ToInt32(entity.ProjectNO)), entity.AnnualNO); } catch (Exception ex) { AppLogger.Instance.Log.Error("GetProjectBudgetFormat抛出异常:" + ex); } return projectformat; }
/// <summary> /// 批量导入预算明细 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnImportYSMX_Click(object sender, EventArgs e) { #region 检查上传文件格式是否正确 sys_UserTable curruser = UserData.GetUserDate; if (curruser.U_LoginName != null) { try { string creatPath = System.Web.HttpContext.Current.Server.MapPath("/FJ/YSMX").ToString(); if (!System.IO.Directory.Exists(creatPath)) { System.IO.Directory.CreateDirectory(creatPath); } } catch { throw; } } string strBaseLocation = Server.MapPath("/FJ/YSMX/"); string LocalFile = string.Empty;//本地文件名 string newfilename = DateTime.Now.ToString("yyyyMMddHHmmss"); string clientFilename = System.IO.Path.GetFileName(Filename.PostedFile.FileName); string serverFilename = ""; if (clientFilename == "") { EventMessage.Show(this.Page, "您上传的文件名不能为空!"); return; } if (clientFilename.ToLower().IndexOf(".xlsx") > 0) { serverFilename = ".xlsx"; } else { if (clientFilename.ToLower().IndexOf(".xls") > 0 && clientFilename.EndsWith("xls")) { serverFilename = ".xls"; } else { EventMessage.Show(this.Page, "您上传的文件必须为Excel文件!"); return; } } //设置文件名 LocalFile = strBaseLocation + newfilename + serverFilename; //保存文件 Filename.PostedFile.SaveAs(LocalFile); #endregion #region 数据导入库中 StringBuilder msg = new StringBuilder(); DataTable dt = new DataTable(); if (this.Filename.HasFile) { try { //读取Excel资料流并转换成DataTable dt = ExcelHelper.RenderDataTableFromExcel(this.Filename.FileContent, 0, 4); int success = 0; //成功的个数 int unsucess = 0;//失败的个数 int t_proID=0; bool IsInsertTPro = true; foreach (DataRow dr in dt.Rows) { try { #region 给个字段赋值 string lbmc = ""; string kmmc = ""; string xmmc = ""; //判断此项目是否已添加到项目预算表中 if (!dr[2].ToString().Trim().Equals("")) { lbmc = BusinessFacadeShanlitech_Location.GetIDByClassName(dr[0].ToString().Trim()).ToString(); //类别ID kmmc = BusinessFacadeShanlitech_Location.GetIDBySubjectName(dr[1].ToString().Trim()).ToString();//科目名称 xmmc = BusinessFacadeShanlitech_Location.GetIDByProjectName(dr[2].ToString().Trim()).ToString();//项目名称 IsInsertTPro = true; } else { IsInsertTPro = false; } float xmje; if (dr[3].ToString().Trim().Length > 0) { xmje = float.Parse(dr[3].ToString().Trim());//项目金额 } else { xmje = 0f;//项目金额 } string qcmc = dr[4].ToString().Trim();//器材名称 float yssr; if (dr[5].ToString().Trim().Length > 0) { yssr = float.Parse(dr[5].ToString().Trim());//预算收入 } else { yssr = 0f;//预算收入 } string jldw = dr[6].ToString().Trim();//计量单位 float dj; if (dr[7].ToString().Trim().Length > 0) { dj = float.Parse(dr[7].ToString().Trim());//单价 } else { dj = 0f;//单价 } int sl; if (dr[8].ToString().Trim().Length > 0) { sl = Convert.ToInt32(dr[8].ToString().Trim());//数量 } else { sl = 0;//数量 } float je; if (dr[9].ToString().Trim().Length > 0) { je = float.Parse(dr[9].ToString().Trim());//金额 } else { je = 0f;//金额 } string ghdw = dr[10].ToString().Trim();//供货单位 float ysye; if (dr[11].ToString().Trim().Length > 0) { ysye = float.Parse(dr[11].ToString().Trim());//预算余额 } else { ysye = 0f;//预算余额 } string bz = dr[12].ToString().Trim();//备注 #endregion #region 项目预算表插入数据 if (IsInsertTPro) { T_ProjectBudgetEntity t_proEntity = new T_ProjectBudgetEntity(); t_proEntity.DataTable_Action_ = DataTable_Action.Insert; t_proEntity.ClassNO = lbmc; t_proEntity.SubjectNO = kmmc; t_proEntity.ProjectNO = xmmc; t_proEntity.BudgetExpenditure = xmje; t_proID = BusinessFacadeShanlitech_Location.T_ProjectBudgetInsertUpdateDelete(t_proEntity); } #endregion #region 预算明细表插入数据 if (t_proID > 0) { T_BudgetDetailEntity t_budEntity = new T_BudgetDetailEntity(); t_budEntity.DataTable_Action_ = DataTable_Action.Insert; t_budEntity.ProjID = t_proID; t_budEntity.EquipmentName = qcmc; t_budEntity.BudgetRevenue = yssr; t_budEntity.Measurement = jldw; t_budEntity.BudgetPrice = dj; t_budEntity.BudgetNumber = sl; t_budEntity.BudgetExpenditure = je; t_budEntity.Supplier = ghdw; t_budEntity.BalanceAmount = ysye; t_budEntity.Remark = bz; int t_budID = BusinessFacadeShanlitech_Location.T_BudgetDetailInsertUpdateDelete(t_budEntity); if (t_budID > 0) { success += 1; } } #endregion } catch (Exception) { unsucess += 1; continue; } } msg.Append("添加成功个数:" + success + "!\\n"); msg.Append("添加失败个数:" + unsucess + "!\\n"); EventMessage.Show(this.Page, "操作结果:\\n" + msg.ToString(), "Default.aspx"); this.TabOptionWebControls1.SelectIndex = 1; } catch (Exception ex) { EventMessage.MessageBox(1, "操作无效", "上传文件导入数据失败!", Icon_Type.Error, Common.GetHomeBaseUrl("Default.aspx")); } } else { EventMessage.Show(this.Page, "此文件为空!"); } #endregion }
/// <summary> /// 初始化数据 /// </summary> /// <param name="ut"></param> private void OnStartData(T_ProjectBudgetEntity ut) { //经费类别 if (!string.IsNullOrEmpty(ut.ClassNO)) { ListItem classitem = ClassNO_Input.Items.FindByValue(ut.ClassNO.ToString()); ClassNO_Input.ClearSelection(); if (classitem != null) classitem.Selected = true; ClassNO_Disp.Text = BusinessFacadeShanlitech_Location.GetClassNameByID(Convert.ToInt32(ut.ClassNO.ToString())); } //项目类别 if (!string.IsNullOrEmpty(ut.ProjectNO)) { ListItem projectitem = ProjectNO_Input.Items.FindByValue(ut.ProjectNO.ToString()); ProjectNO_Input.ClearSelection(); if (projectitem != null) projectitem.Selected = true; ProjectNO_Disp.Text = BusinessFacadeShanlitech_Location.GetProjectNameByID(Convert.ToInt32(ut.ProjectNO.ToString())); } //科目类别 if (!string.IsNullOrEmpty(ut.SubjectNO)) { ListItem subjectitem = SubjectNO_Input.Items.FindByValue(ut.SubjectNO.ToString()); SubjectNO_Input.ClearSelection(); if (subjectitem != null) subjectitem.Selected = true; SubjectNO_Disp.Text = BusinessFacadeShanlitech_Location.GetSubjectNameByID(Convert.ToInt32(ut.SubjectNO.ToString())); } AnnualNO_Input.Text = AnnualNO_Disp.Text = ut.AnnualNO.ToString(); BudgetRevenue_Input.Text = BudgetRevenue_Disp.Text = ut.BudgetRevenue.ToString(); BudgetExpenditure_Input.Text = BudgetExpenditure_Disp.Text = ut.BudgetExpenditure.ToString(); //BalanceAmount_Input.Text = BalanceAmount_Disp.Text = ut.BalanceAmount.ToString(); //项目组长 ListItem leaderitem = Leader_Input.Items.FindByValue(ut.Leader.ToString()); Leader_Input.ClearSelection(); if (leaderitem != null) leaderitem.Selected = true; Leader_Disp.Text = BusinessFacadeShanlitech_Location.GetUserNameByID(Convert.ToInt32(ut.Leader.ToString())); //项目承办人 ListItem Undertakeritem = Undertaker_Input.Items.FindByValue(ut.Undertaker.ToString()); Undertaker_Input.ClearSelection(); if (Undertakeritem != null) Undertakeritem.Selected = true; Undertaker_Disp.Text = BusinessFacadeShanlitech_Location.GetUserNameByID(Convert.ToInt32(ut.Undertaker.ToString())); }