protected override string AddData() { RDFNew.Module.Admin.Bas.Bas_Employee obj = new RDFNew.Module.Admin.Bas.Bas_Employee(); DataTable dt = RDFNew.Module.DALHelper.GetMasterEmpty(null, "Bas_Employee"); DataRow dr; dr = dt.NewRow(); dr["EmployeeID"] = App_Com.Helper.InputText(this.txtEmployeeID.Text, 500); dr["EmployeeName"] = App_Com.Helper.InputText(this.txtEmployeeName.Text, 500); dr["NameE"] = App_Com.Helper.InputText(this.txtNameE.Text, 500); dr["Enabled"] = this.ckbEnabled.Checked; dr["IsUser"] = this.ckbIsUser.Checked; dr["Remark"] = App_Com.Helper.InputText(this.txtRemark.Text, 500); dr["Phone"] = App_Com.Helper.InputText(this.txtPhone.Text, 500); dr["Email"] = App_Com.Helper.InputText(this.txtEmail.Text, 500); dr["DeptID"] = App_Com.Helper.InputText(this.txtDeptID.Text, 500); if (this.idFile.FileName != "") { object[] os = App_Com.ImageHelper.UploadImage(this.idFile, String.Format("~/_Upload/Images/{0}/", this.GetType().BaseType.Name),"SML"); if (os[0].ToString() == "0") { dr["ImageL"] = os[1]; dr["ImageM"] = os[2]; dr["ImageS"] = os[3]; } } dr["CrtBy"] = App_Com.Sys_User.GetUserInfo("UserID"); dr["CrtOn"] = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); dt.Rows.Add(dr); object[] data = obj.ApplyMaster(dt.GetChanges(DataRowState.Added), App_Com.Helper.BuildLog("Bas_Employee", "add")); if (data[0].ToString() != "0") //正常 throw data[1] as Exception; else return data[1].ToString(); }
protected override void OnInit(EventArgs e) { base.OnInit(e); B_ModuleID = "Bas_Employee"; B_ModuleName = "雇员"; B_PageDetail = "Bas_Employee.aspx"; B_ToolBar1 = this.Toolbar1; B_Window1 = this.Window1; B_Grid1 = this.Grid1; B_IDAL = new RDFNew.Module.Admin.Bas.Bas_Employee(); B_TableKey = "Bas_Employee.EmployeeID"; B_OrderBy = " Bas_Employee.CrtOn Desc "; }
void WebReport1_StartReport(object sender, EventArgs e) { RDFNew.Module.Admin.Bas.Bas_Employee obj = new RDFNew.Module.Admin.Bas.Bas_Employee(); RDFNew.Module.DALEntity.QuerySet qs = new RDFNew.Module.DALEntity.QuerySet(); qs.QueryInfos = GetQueryInfo(); qs.OrderBy = " Bas_Employee.EmployeeID "; object[] data = obj.GetMaster(qs); if (data[0].ToString() == "0") //正常 { DataTable dt = data[1] as DataTable; Report FReport = (sender as FastReport.Web.WebReport).Report; FReport.RegisterData(dt, "Table"); } }
protected override void OnInit(EventArgs e) { base.OnInit(e); B_ModuleID = "Bas_Employee"; B_ModuleName = "雇员"; B_ToolBar1 = this.Toolbar1; B_IDAL = new RDFNew.Module.Admin.Bas.Bas_Employee(); }
protected override string UpdateData() { RDFNew.Module.Admin.Bas.Bas_Employee obj = new RDFNew.Module.Admin.Bas.Bas_Employee(); object[] data = obj.GetMaster(B_Keyword); if (data[0].ToString() == "0") //正常 { DataTable dt = data[1] as DataTable; if (dt.Rows.Count > 0) { DataRow dr; dr = dt.Rows[0]; dr["EmployeeName"] = App_Com.Helper.InputText(this.txtEmployeeName.Text, 500); dr["NameE"] = App_Com.Helper.InputText(this.txtNameE.Text, 500); dr["Enabled"] = this.ckbEnabled.Checked; dr["IsUser"] = this.ckbIsUser.Checked; dr["Remark"] = App_Com.Helper.InputText(this.txtRemark.Text, 500); dr["Phone"] = App_Com.Helper.InputText(this.txtPhone.Text, 500); dr["Email"] = App_Com.Helper.InputText(this.txtEmail.Text, 500); dr["DeptID"] = App_Com.Helper.InputText(this.txtDeptID.Text, 500); dr["ModBy"] = App_Com.Sys_User.GetUserInfo("UserID"); dr["ModOn"] = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); if (this.idFile.FileName != "") { object[] os = App_Com.ImageHelper.UploadImage(this.idFile, String.Format("~/_Upload/Images/{0}/", this.GetType().BaseType.Name), "SML"); if (os[0].ToString() == "0") { dr["ImageL"] = os[1]; dr["ImageM"] = os[2]; dr["ImageS"] = os[3]; } } if (this.ckbDeleteImg.Checked) App_Com.ImageHelper.DeleteImage(dr, true); data = obj.ApplyMaster(dt.GetChanges(DataRowState.Modified), App_Com.Helper.BuildLog("Bas_Employee", "edit")); if (data[0].ToString() != "0") //正常 throw data[1] as Exception; else { if (this.idFile.FileName != "") //删除旧图片 App_Com.ImageHelper.DeleteImage(dr, false); return data[1].ToString(); } } else { throw new Exception("需要修改的记录已不存在,请刷新后再试."); } } else { throw data[1] as Exception; } }