private void BindGridView() { CommonDao<Safezhuan> newmgr = new CommonDao<Safezhuan>(); DataTable dt = new DataTable(); dt = newmgr.FindDataTableByCondition(""); if (dt.Rows.Count == 0) { dt.Rows.Add(dt.NewRow()); GridViewEmployee.DataSource = dt; GridViewEmployee.DataBind(); int columnCount = dt.Columns.Count; GridViewEmployee.Rows[0].Cells.Clear(); GridViewEmployee.Rows[0].Cells.Add(new TableCell()); GridViewEmployee.Rows[0].Cells[0].ColumnSpan = columnCount + 1; GridViewEmployee.Rows[0].Cells[0].Text = "没有记录"; GridViewEmployee.Rows[0].Cells[0].Style.Add("text-align", "center"); } else { GridViewEmployee.DataSource = dt; GridViewEmployee.DataBind(); } }
public void OrderDataBind() { CommonDao<HealthSchedule> OrderSchMgr = new CommonDao<HealthSchedule>(); HealthSchedule healthuserorder = OrderSchMgr.FindById(SchedulId); this.LabelDoctor.Text = healthuserorder.orderdoctor.ToString(); this.LabelDateTime.Text = healthuserorder.orderdate.Substring(0, 3).ToString() + "  " + healthuserorder.ordertime.ToString(); DataTable dtu = UI.GetInfo("CN_ID = " + userid); string[] depts = dtu.Rows[0]["CN_DEPTINFO"].ToString().Split('/'); string dept = ""; for (int i = 0; i < depts.Count(); i++) { if (i != 0) { dept += depts[i] + "/"; } } //if(dept.Length>0) // dept = dept.Remove(dept.Length - 1); if (dept.Length > 0) dept = dept.Trim('/'); this.LabelUser.Text = username; this.LabelDept.Text = dept; this.TextBoxTel.Text = dtu.Rows[0]["CN_O_PHONE"].ToString(); }
private void InfoBind() { CommonDao<SafePitFalls> newmgr = new CommonDao<SafePitFalls>(); string condition = " 1=1 "; if (TextBoxyh.Text.Trim().Length > 0) { condition = condition + " and PitContents like '%" + this.TextBoxyh.Text.Trim().ToString() + "%'"; } if (TextBoxdept.Text.Trim().Length > 0) { condition = condition + " and dept like '%" + this.TextBoxdept.Text.Trim().ToString() + "%'"; } if (TextBoxperson.Text.Trim().Length > 0) { condition = condition + " and person like '%" + this.TextBoxperson.Text.Trim().ToString() + "%'"; } if (TextBoxqy.Text.Trim().Length > 0) { condition = condition + " and Area like '%" + this.TextBoxqy.Text.Trim().ToString() + "%'"; } if (TextBoxtime.Text.Trim().Length > 0) { condition = condition + " and time = '" + this.TextBoxtime.Text.Trim().ToString()+"'"; } Pager.RecordCount = int.Parse(newmgr.GetTotalCount(condition)); RepeaterPubGG.DataSource = newmgr.FindAllByPageDesc(((Pager.CurrentPageIndex - 1) * Pager.PageSize).ToString(), Pager.PageSize.ToString(), condition); RepeaterPubGG.DataBind(); }
//删除 protected void btnDelete_Clik(object sender, CommandEventArgs e) { string fid = e.CommandName; CommonDao<SafeRewards> newmgr = new CommonDao<SafeRewards>(); CommonDao<SafeDeptMoney> moneymgr=new CommonDao<SafeDeptMoney>(); SafeRewards sf = newmgr.FindById(fid); CommonDao<SafeRewards> rewardmgr = new CommonDao<SafeRewards>(); SafeDeptMoney sm = moneymgr.FindByConditions(" deptname='" + sf.dept + "' and deptyear=datepart(yy,'"+sf.createtime.ToString()+"') "); sm.currentmoney = sm.currentmoney - sf.rewards; if (sm != null && sf != null) { if (moneymgr.Update(sm)) { if (newmgr.Del(sf)) { MsgShow("恭喜您,删除记录成功!"); InfoBind(); } } else { MsgShow("Sorry,删除记录失败!"); } } else { MsgShow("Sorry,未找到对应部门金额,删除记录失败!"); } }
public void UserDateBind() { CommonDao<HealthUserOrder> HealthUserOrdermgr = new CommonDao<HealthUserOrder>(); CommonDao<HealthAdmin> healadminmgr = new CommonDao<HealthAdmin>(); string condition = " 1=1 "; if (this.TextBox1.Text.Trim() != "") { condition = condition + " and USERNAME like '%" + this.TextBox1.Text.ToString() + "%'"; } if (this.TextBox2.Text.Trim() != "") { condition = condition + " and STARTTIME >'" + this.TextBox2.Text.ToString() + "'"; } if (this.TextBox3.Text.Trim() != "") { condition = condition + " and STARTTIME <'" + this.TextBox3.Text.ToString() + "'"; } if (this.DropDownList2.Text.Trim() != "") { condition = condition + " and USERDOCTOR ='" + this.DropDownList2.Text.ToString() + "'"; } if (this.DropDownList1.Text.Trim() != "") { condition = condition + " and userstate='" + this.DropDownList1.Text.ToString() + "'"; } AspNetPager1.RecordCount = int.Parse(HealthUserOrdermgr.GetTotalCount(condition)); Repeater1.DataSource = HealthUserOrdermgr.FindAllByPageDesc(((AspNetPager1.CurrentPageIndex - 1) * AspNetPager1.PageSize).ToString(), AspNetPager1.PageSize.ToString(), condition); Repeater1.DataBind(); }
private void Login(string id, string password) { if (String.IsNullOrEmpty(id)) { txtUserId.Focus(); return; } else if (String.IsNullOrEmpty(password)) { txtPassword.Focus(); return; } // // // string user = CommonDao.GetInstance().PasswordCheck(id, password); if (user == null) { DialogHelper.ShowDialog("로그인 실패!", DialogType.OkOnly); txtPassword.Focus(); } else { SharedCache.UserId = user; this.DialogResult = DialogResult.OK; this.Close(); } }
protected void DoneClick(object sender, EventArgs e) { if (DoProc("PROC_UPDATE_ORDERTIME")) { MsgShow("执行成功!"); CommonDao<HealthAdmin> healadminmgr = new CommonDao<HealthAdmin>(); IList<HealthAdmin> listhealthadmin = healadminmgr.FindByCondition(" works=1 "); if (listhealthadmin != null) { foreach (HealthAdmin healthadmin in listhealthadmin) { UI.AddAmDetail(healthadmin.username, "保健预约", "排班完成"); } } } else { MsgShow("执行失败!"); } }
private void SetDefaultdata() { if (Request.QueryString["fid"] != null) { CommonDao<Model.SafeRewards> newmgr = new CommonDao<SafeRewards>(); SafeRewards sres = newmgr.FindById(Request.QueryString["fid"]); if (sres != null) { SetDropValueDefault(sres.dept, sres.person); //ListItem itmSelected = DropDownListQuyu.Items.FindByValue(sres.area); //if (itmSelected != null) { itmSelected.Selected = true; } this.TextAreaQuyu.InnerText = sres.area; ListItem itmSelected1 = DropDownListDept.Items.FindByValue(sres.dept); if (itmSelected1 != null) { itmSelected1.Selected = true; } ListItem itmSelected2 = DropDownListPerson.Items.FindByValue(sres.person); if (itmSelected2 != null) { itmSelected2.Selected = true; } this.TextBoxReward.Text = sres.rewards.ToString(); } else { MessageBox.ShowAndRedirect(this, "出错了,资源未找到!", "SafeAdmin.aspx"); } } else { } }
public PharmaBusinessObjects.Common.AccountLedgerType GetAccountLedgerTypeByName(string name) { var accountLedgerTypes = new CommonDao().GetAccountLedgerTypes() ?? new List <PharmaBusinessObjects.Common.AccountLedgerType>();; PharmaBusinessObjects.Common.AccountLedgerType accountLedger = accountLedgerTypes.FirstOrDefault(p => p.AccountLedgerTypeName.ToLower() == name.ToLower()); return(accountLedger); }
protected void AddValue(object sender, EventArgs e) { CommonDao<Safezhuan> newmgr = new CommonDao<Safezhuan>(); Safezhuan safezhuan = new Safezhuan(); safezhuan.ZhuanName = this.TextBoxName.Text.Trim().ToString(); int count =int.Parse(newmgr.GetTotalCount("zhuanname='"+safezhuan.ZhuanName.ToString()+"'")); if (count == 0) { if (newmgr.Add(safezhuan)) { Alert("热点专题添加成功!"); BindGridView(); } else { Alert("热点专题添加失败!请重试。"); } } else { Alert("热点专题名称不能重复。"); } }
private FormAuthCollection GetAuthCollection(BaseMdiChildForm form) { if (this.FormAuthCollection != null && this.FormAuthCollection.Changed == false) { return(this.FormAuthCollection); } // // 로그인 유저의 화면별 권한정보 // this.FormAuthCollection = form.AuthCollection; DataTable dt = CommonDao.GetInstance().AuthInfoSelect(); List <FormAuthInfo> authInfoList = new List <FormAuthInfo>(); foreach (DataRow row in dt.Rows) { FormAuthInfo authInfo = new FormAuthInfo( viewId: row["VIEW_ID"].ToString(), authKind: row["AUTH_KIND"].ToString(), value: row["AUTH_YN"].ToString() == "Y" ? true : false); authInfoList.Add(authInfo); } authInfoList = authInfoList.FindAll(view => view.ViewId == form.Name); this.FormAuthCollection = new FormAuthCollection(authInfoList); this.FormAuthCollection.Changed = false; return(this.FormAuthCollection); }
private void SetDefaultdata() { if (Request.QueryString["fid"] != null) { CommonDao<SafeDuty> newmgr = new CommonDao<SafeDuty>(); SafeDuty sduty = newmgr.FindById(Request.QueryString["fid"]); if (sduty != null) { this.TextAreaQuyu.InnerText = sduty.area; this.TextBoxFenlei.Text = sduty.areatype; this.TextBoxDept.Text = sduty.dept; this.TextBoxDeptLeader.Text = sduty.deptleader; this.DropDownListImportant.SelectedValue = sduty.isimportant; this.DropDownListYear.Text = sduty.time.ToString(); this.TextBoxPerson.Text = sduty.person; } else { MessageBox.ShowAndRedirect(this, "出错了,资源未找到!", "SafeAdmin.aspx"); } } }
private void GetZhuanTiList() { string fid = ""; string condition = ""; if (Request["ZhuanName"] != null) { fid = Request["ZhuanName"].ToString(); CommonDao<Safezhuan> sugmgr = new CommonDao<Safezhuan>(); Safezhuan safezhuan = sugmgr.FindByConditions(" fid='"+fid+"' "); this.lableType.InnerHtml = " <span style='color: #0087ce;'>" +safezhuan.ZhuanName.ToString() + "</span>"; condition = condition + " NewsZhuan ='" + fid + "' "; } CommonDao<SafeNews> newmgr = new CommonDao<SafeNews>(); SafeNews s = new SafeNews(); if (TextBoxSearch.Text.Trim().Length > 0) { condition = condition + " and newstitle like '%" + this.TextBoxSearch.Text.Trim().ToString() + "%'"; } Pager.RecordCount = int.Parse(newmgr.GetTotalCount(condition)); RepeaterPubGG.DataSource = newmgr.FindAllByPageDesc(((Pager.CurrentPageIndex - 1) * Pager.PageSize).ToString(), Pager.PageSize.ToString(), condition); RepeaterPubGG.DataBind(); }
private void GetSafeZhuan() { CommonDao<Safezhuan> sugmgr = new CommonDao<Safezhuan>(); RepeaterSafeZhuanTi.DataSource = sugmgr.FindAll(); RepeaterSafeZhuanTi.DataBind(); }
private void InfoBind() { string Infotype = Request.QueryString["Infotype"]; string type = Request.QueryString["type"]; if (Infotype == null && type == null) { Infotype = "安全新闻"; } string condition = ""; CommonDao<SafeNews> newmgr = new CommonDao<SafeNews>(); if (Infotype == "安全新闻") { condition = " NewsInfoType = '" + Infotype + "' "; } else { condition = " NewsInfoType = '" + Infotype + "' and NewsType='" + type + "' "; } if (TextBoxSearch.Text.Trim().Length > 0) { condition = condition + " and newstitle like '%" + this.TextBoxSearch.Text.Trim().ToString() + "%'"; } Pager.RecordCount = int.Parse(newmgr.GetTotalCount(condition)); RepeaterPubGG.DataSource = newmgr.FindAllByPageDesc(((Pager.CurrentPageIndex - 1) * Pager.PageSize).ToString(), Pager.PageSize.ToString(), condition); RepeaterPubGG.DataBind(); }
private void PageAccess() { CommonDao<SafePageAccess> Pagemgr = new CommonDao<SafePageAccess>(); SafePageAccess pa = new SafePageAccess(); pa.createtime = DateTime.Now.ToString(); pa.pagename = Request.RawUrl; if (Tools.CookieHelper.GetCookie("CN_ID") != null) { EPReper.BLL.Userinfo UI = new EPReper.BLL.Userinfo(); string userid = Tools.CookieHelper.GetCookie("CN_ID").ToString(); pa.userinfo = UI.GetList("CN_ID = " + userid).Tables[0].Rows[0]["CN_LOGIN"].ToString(); } else { pa.userinfo = "匿名 IP:" + Request.UserHostAddress; } if (int.Parse(Pagemgr.GetTotalCount(" pagename='" + pa.pagename + "' and userinfo ='" + pa.userinfo + "'")) <= 0) { Pagemgr.Add(pa); CommonDao<SafeNews> newmgr = new CommonDao<SafeNews>(); SafeNews safenew = newmgr.FindById(Request["fid"].ToString()); safenew.newskits++; newmgr.Update(safenew); } }
public MainController(ILogger <MainController> logger, AppSoftDbContext context) { _logger = logger; _context = context; _commonDao = new CommonDao(context); _codeMngTool = new CodeMngTool(context); }
public void UserDateBind() { CommonDao<HealthUserOrder> HealthUserOrdermgr = new CommonDao<HealthUserOrder>(); CommonDao<HealthAdmin> healadminmgr = new CommonDao<HealthAdmin>(); string username = UI.GetList("CN_ID = " + userid).Tables[0].Rows[0]["CN_LOGIN"].ToString(); if (int.Parse(healadminmgr.GetTotalCount(" username='******' and works=2 ")) > 0) { string condition = " userid in('other','" + userid + "') "; if (this.DropDownList1.Text.Trim() != "") { condition = condition + " and userstate='" + this.DropDownList1.Text.ToString() + "'"; } AspNetPager1.RecordCount = int.Parse(HealthUserOrdermgr.GetTotalCount(condition)); Repeater1.DataSource = HealthUserOrdermgr.FindAllByPageDesc(((AspNetPager1.CurrentPageIndex - 1) * AspNetPager1.PageSize).ToString(), AspNetPager1.PageSize.ToString(), condition); Repeater1.DataBind(); } else { string condition = " username='******'"; if (this.DropDownList1.Text.Trim() != "") { condition = condition + " and userstate='" + this.DropDownList1.Text.ToString() + "'"; } AspNetPager1.RecordCount = int.Parse(HealthUserOrdermgr.GetTotalCount(condition)); Repeater1.DataSource = HealthUserOrdermgr.FindAllByPageDesc(((AspNetPager1.CurrentPageIndex - 1) * AspNetPager1.PageSize).ToString(), AspNetPager1.PageSize.ToString(), condition); Repeater1.DataBind(); } }
public OracleDbSource(DateTime jobExecTime, FsETLJob etlJob, FsETLSetting setting) : base(jobExecTime, etlJob, setting) { logger.InfoFormat("Connection to db . IP: [{0}], Port: [{1}], Service Name: [{2}], user: [{3}]", setting.IP, setting.Port, setting.DbServiceName, setting.UserName); OracleDatabase db = DatabaseFactory.GetOracleDatabase(setting.IP, setting.Port, setting.DbServiceName, setting.UserName, setting.Pwd); comDao = new CommonDao(db); }
public RecsroomController(ILogger <RecsroomController> logger, AppSoftDbContext context) { _logger = logger; _context = context; _commonDao = new CommonDao(context); _codeMngTool = new CodeMngTool(context); _fileMngTool = new FileMngTool(context); }
public void init() { //var connection = System.Configuration.ConfigurationManager.ConnectionStrings["SFCS"].ConnectionString; OracleDatabase db = DatabaseFactory.GetOracleDatabaseByConfigEncrypt("SFCS"); cmmDao = new CommonDao(db); }
/// <summary> /// Get System Date /// </summary> /// <param name="systemDate">DateTime value</param> /// <returns> /// 0: Search successful /// others: Sql Exception /// </returns> public static DateTime GetSystemDate() { CommonDao commonDao = new CommonDao(); DateTime systemDate = new DateTime(); commonDao.GetSystemDate(out systemDate); return(systemDate); }
public List <PharmaBusinessObjects.Common.AccountLedgerType> GetAccountLedgerTypesWithAll() { var accountLedgerTypes = new CommonDao().GetAccountLedgerTypes() ?? new List <PharmaBusinessObjects.Common.AccountLedgerType>();; accountLedgerTypes.Insert(0, new PharmaBusinessObjects.Common.AccountLedgerType() { AccountLedgerTypeID = 0, AccountLedgerTypeName = "All" }); return(accountLedgerTypes); }
public void T() { #region 市政取芯数据录入求值 sql = $"select m.*,s.jcxm,s.BZMD_S1 from {ysjbmc} m inner join {sjbmc} e on e.recid = m.sysjbrecid inner join s_lqx s on s.recid = e.sysjbrecid where m.sysjbrecid = '{recid}' "; dt = CommonDao.GetDataTableTran(sql); if (dt.Count > 0) { var dic = dt[0]; string jcxm = "、" + dic["jcxm"].Replace(',', '、') + "、"; if (jcxm.Contains("、厚度、")) { dic["hd"] = Math.Round((dic["schd1"].GetSafeDouble() + dic["schd2"].GetSafeDouble() + dic["schd3"].GetSafeDouble() + dic["schd4"].GetSafeDouble()) / 4, 2).ToString("0.00"); } else { dic["hd"] = "----"; } if (jcxm.Contains("、密度(表干法、水中法、蜡封法)、")) { if (dic["syff"] == "表干法" || dic["syff"] == "水中重法") { dic["md"] = Math.Round(dic["kqzzl"].GetSafeDouble() / (dic["bgzl"].GetSafeDouble() - dic["szzl"].GetSafeDouble()) * 0.9771, 3).ToString("F3"); } else if (dic["syff"] == "蜡封法") { if (dic["sfhs"] == "是") //用滑石粉 { dic["md"] = Math.Round(dic["sjkz"].GetSafeDouble() / ((dic["lkzl"].GetSafeDouble() - dic["lszl"].GetSafeDouble()) - ((dic["lkzl"].GetSafeDouble() - dic["thkz"].GetSafeDouble()) / dic["slmd"].GetSafeDouble() + (dic["thkz"].GetSafeDouble() - dic["sjkz"].GetSafeDouble()) / dic["hsmd"].GetSafeDouble())) * 0.9771, 3).ToString("F3"); } else { dic["md"] = Math.Round(dic["sjkz"].GetSafeDouble() / ((dic["lkzl"].GetSafeDouble() - dic["lszl"].GetSafeDouble()) - (dic["lkzl"].GetSafeDouble() - dic["sjkz"].GetSafeDouble()) / dic["slmd"].GetSafeDouble()) * 0.9771, 3).ToString("F3"); } } else { dic["syff"] = "----"; } if (MatchValue.IsNumeric(dic["md"]) && MatchValue.IsNumeric(dic["BZMD_S1"])) { dic["YSD"] = Math.Round(dic["md"].GetSafeDouble() / dic["BZMD_S1"].GetSafeDouble() * 100, 2).GetSafeString(); } } else { dic["syff"] = "----"; } upsqls.Add($"update {ysjbmc} set hd = '{dic["hd"]}',ysd = '{dic["ysd"]}' where sysjbrecid = '{recid}'"); upsqls.Add($"update {sjbmc} set SCHD = '{dic["hd"]}',SCYSD = '{dic["ysd"]}',MD = '{dic["md"]}' where recid = '{recid}'"); } #endregion }
private void TopNewThemes() { string type = "安全公文"; if (Request["type"] != null) { type = Request["type"].ToString(); } CommonDao<SafeNews> newmgr = new CommonDao<SafeNews>(); RepeaterDianJi.DataSource = newmgr.FindByIDdesc("10", " NewsInfoType = '安全信息' and newstype ='" + type + "'"); RepeaterDianJi.DataBind(); }
public int SelectCommonData(string code, out List <IModel> lstResult) { CommonDao commonDao = new CommonDao(); SYS_CommonModel commonDto = new SYS_CommonModel(); commonDto.Code = CommonMethod.ParseString(code); commonDto.LangId = UserSession.LangId == null?CommonData.Language.English.ConvertCultureLanguageToDB() : UserSession.LangId.ConvertCultureLanguageToDB(); //commonDto.LangId = UserSession.LangId == null ? CommonData.Language.English : UserSession.LangId; return(commonDao.SelectCommonData(commonDto, out lstResult)); }
public List <PharmaBusinessObjects.Common.AccountType> GetAccountTypes() { List <PharmaBusinessObjects.Common.AccountType> accountTypes = new CommonDao().GetAccountTypes(); foreach (var accountType in accountTypes) { accountType.AccountTypeDisplayName = accountType.AccountTypeShortName + " - " + accountType.AccountTypeName; } return(accountTypes); }
public List <PharmaBusinessObjects.Common.RecordType> GetRecordTypesWithAll() { var recordTypes = new CommonDao().GetRecordTypes() ?? new List <PharmaBusinessObjects.Common.RecordType>(); recordTypes.Insert(0, new PharmaBusinessObjects.Common.RecordType() { RecordTypeId = 0, RecordTypeName = "All" }); return(recordTypes); }
public static void cleanDataBase() { CommonDao commonDao = new CommonDao(); commonDao.cleanTable("KHACH_HANG"); commonDao.cleanTable("DON_DAT_HANG"); commonDao.cleanTable("DON_DAT_HANG_SP"); commonDao.cleanTable("LICH_SU_TRA_TRUOC"); commonDao.cleanTable("LIEN_HE"); commonDao.cleanTable("SAN_PHAM"); commonDao.cleanTable("SAN_PHAM_CHI_TIET"); }
internal PharmaBusinessObjects.Master.AccountLedgerMaster GetAccountLedgerById(int accountLedgerID) { CommonDao commonDao = new CommonDao(); PharmaBusinessObjects.Master.AccountLedgerMaster accountLedger = new AccountLedgerMasterDao(this.LoggedInUser).GetAccountLedgerById(accountLedgerID); accountLedger.AccountLedgerTypeList = commonDao.GetAccountLedgerTypes() ?? new List <PharmaBusinessObjects.Common.AccountLedgerType>(); accountLedger.AccountTypeList = new CommonBiz().GetAccountTypes() ?? new List <PharmaBusinessObjects.Common.AccountType>(); accountLedger.CreditControlCodeList = commonDao.GetAccountLedgerTypes().Where(p => p.AccountLedgerTypeSystemName == "ControlCodes").ToList() ?? new List <PharmaBusinessObjects.Common.AccountLedgerType>(); accountLedger.DebitControlCodeList = commonDao.GetAccountLedgerTypes().Where(p => p.AccountLedgerTypeSystemName == "ControlCodes").ToList() ?? new List <PharmaBusinessObjects.Common.AccountLedgerType>(); return(accountLedger); }
private void CheckOther() { CommonDao<HealthAdmin> healadminmgr = new CommonDao<HealthAdmin>(); string username = UI.GetList("CN_ID = " + userid).Tables[0].Rows[0]["CN_LOGIN"].ToString(); if (int.Parse(healadminmgr.GetTotalCount(" username='******' and works=2 ")) > 0) { this.TextBoxOther.Visible = true; healthother1.Visible = true; } }
public static void restoreDatabase(String path) { cleanDataBase(); CommonDao commonDao = new CommonDao(); String[] listFile = Directory.GetFiles(path); foreach (String file in listFile) { DataTable data = GetDataTabletFromCSVFile(file); String fileName = Path.GetFileName(file); commonDao.insertDatabase(data, fileName.Split('.')[0]); } }
public void GetAdmin() { EPReper.BLL.Userinfo UI = new EPReper.BLL.Userinfo(); CommonDao<HealthAdmin> healadminmgr = new CommonDao<HealthAdmin>(); string username = UI.GetList("CN_ID = " + userid).Tables[0].Rows[0]["CN_LOGIN"].ToString(); if (int.Parse(healadminmgr.GetTotalCount(" username='******' ")) > 0) { admins.Visible = true; admins1.Visible = true; admins2.Visible = true; } }
private void GetInfo() { CommonDao<SafeBook> newmgr = new CommonDao<SafeBook>(); SafeBook safebook = newmgr.FindById(Request["fid"].ToString()); if (safebook == null) { this.lbtitle.Text = "无法找到该记录,可能已经被删除!"; return; } this.lbtitle.Text = safebook.booktitle; this.Title = safebook.booktitle + "--安全新闻管理"; this.lbcontent.Text = safebook.bookcontents; this.lbAinfo.Text = " 作者:" + safebook.createperson + " 最后修改:" + safebook.createtime + " 有效访问量:" + safebook.bookkits.ToString(); }
private void InfoBind() { CommonDao<SafeRewards> newmgr = new CommonDao<SafeRewards>(); string condition = " "; if (TextBoxSearch.Text.Trim().Length > 0) { condition = condition + " Area like '%" + this.TextBoxSearch.Text.Trim().ToString() + "%'"; } Pager.RecordCount = int.Parse(newmgr.GetTotalCount(condition)); RepeaterPubGG.DataSource = newmgr.FindAllByPageDesc(((Pager.CurrentPageIndex - 1) * Pager.PageSize).ToString(), Pager.PageSize.ToString(), condition); RepeaterPubGG.DataBind(); }
public void SetComboBoxValue(string colName, string masterCode) { DataTable dt = CommonDao.GetInstance().ComboBoxCodeSelect(masterCode); if (dt == null) { return; } foreach (DataRow row in dt.Rows) { this.AddComboBoxValue(colName, row); } }
private void TopNewThemes() { CommonDao<SafeNews> newmgr = new CommonDao<SafeNews>(); //RpNewReplay.DataSource = newmgr.FindByIDdesc("10", " NewsInfoType = '安全新闻' "); //RpNewReplay.DataBind(); this.RepeaterBenYue.DataSource = newmgr.FindBydesc("10", " NewsInfoType = '安全新闻' ", "newskits"); RepeaterBenYue.DataBind(); this.RepeaterDianJi.DataSource = newmgr.FindBydesc("10", " NewsInfoType = '安全新闻' ", "newskits"); RepeaterDianJi.DataBind(); this.RepeaterPicNews.DataSource = newmgr.FindByIDdesc("10", " NewsInfoType = '安全新闻' and newstype = '图片新闻'"); RepeaterPicNews.DataBind(); }
private void InfoBind() { CommonDao<SafeNews> newmgr = new CommonDao<SafeNews>(); string condition = " NewsInfoType = '安全新闻' "; if (TextBoxSearch.Text.Trim().Length > 0) { condition = condition + " and newstitle like '%" + this.TextBoxSearch.Text.Trim().ToString() + "%'"; } Pager.RecordCount = int.Parse(newmgr.GetTotalCount(condition)); RpNewReplay.DataSource = newmgr.FindAllByPageDesc(((Pager.CurrentPageIndex - 1) * Pager.PageSize).ToString(), Pager.PageSize.ToString(), condition); RpNewReplay.DataBind(); }
private void InfoBind(string dept) { CommonDao<SafePitFalls> newmgr = new CommonDao<SafePitFalls>(); string condition = " datediff (month,time,getdate())=0 "; if (dept.Length > 0) { condition = condition + " and dept like '%" + dept + "%'"; } Pager.RecordCount = int.Parse(newmgr.GetTotalCount(condition)); Repeateryhxx.DataSource = newmgr.FindAllByPageDesc(((Pager.CurrentPageIndex - 1) * Pager.PageSize).ToString(), Pager.PageSize.ToString(), condition); Repeateryhxx.DataBind(); }
protected void GetValue(object sender, EventArgs e) { CommonDao<Model.SafeRewards> newmgr = new CommonDao<SafeRewards>(); SafeRewards srew = new SafeRewards(); if (Request.QueryString["fid"] != null) { srew = newmgr.FindById(Request.QueryString["fid"].ToString()); } srew.area = this.TextAreaQuyu.InnerText.ToString();// this.DropDownListQuyu.Text.Trim().ToString(); srew.dept = this.DropDownListDept.Text.Trim().ToString(); srew.person = this.DropDownListPerson.Text.Trim().ToString(); srew.rewards = int.Parse(this.TextBoxReward.Text.Trim().ToString()); srew.createtime = DateTime.Now.ToString(); CommonDao<SafeDeptMoney> moneymgr = new CommonDao<SafeDeptMoney>(); SafeDeptMoney sm = moneymgr.FindByConditions(" deptname='" + srew.dept + "' and deptyear=datepart(yy,'" + srew.createtime.ToString() + "') "); if (sm == null) { MessageBox.ShowAndRedirect(this, "未对该部门设置初始金额无法进行奖惩,请设置!", "SafeMoney.aspx"); return; } sm.currentmoney = sm.currentmoney+srew.rewards; srew.totals = sm.currentmoney; if (Request.QueryString["fid"] != null) { if( moneymgr.Update(sm)&&newmgr.Update(srew)) { MessageBox.ShowAndRedirect(this, "恭喜您,安全奖惩修改成功!", "SafeRewAdd.aspx"); } MessageBox.Show(this, "Sorry,安全奖惩修改失败!请您重试!"); } else { if (moneymgr.Update(sm) && newmgr.Add(srew)) { MessageBox.ShowAndRedirect(this, "恭喜您,安全奖惩添加成功!", "SafeRewAdd.aspx"); } MessageBox.Show(this, "Sorry,安全奖惩添加失败!请您重试!"); } }
private void LoadFormMenuInfo() { menuCollection = new FormMenuInfoCollection(); DataTable menuData = CommonDao.GetInstance().MenuSelect(); foreach (DataRow rowMenu in menuData.Rows) { FormMenuInfo info = new FormMenuInfo(rowMenu["MENU_ID"].ToString() , rowMenu["MENU_DESC"].ToString() , rowMenu["PARENT_ID"].ToString() , rowMenu["VIEW_ID"].ToString() , rowMenu["ASSEMBLY_NAME"].ToString() , "" , rowMenu["ORDER_SEQ"].ToString() , rowMenu["USE_YN"].ToString()); menuCollection.Add(info); } }
//删除 protected void btnDelete_Clik(object sender, CommandEventArgs e) { string fid = e.CommandName; CommonDao<SafeBook> newmgr = new CommonDao<SafeBook>(); SafeBook sf = newmgr.FindById(fid); if (newmgr.Del(sf)) { MsgShow("恭喜您,删除记录成功!"); InfoBind(); } else { MsgShow("Sorry,删除记录失败!"); } }
private void GetInfo() { CommonDao<SafeNews> newmgr = new CommonDao<SafeNews>(); CommonDao<SafePinJia> Pinjiamgr = new CommonDao<SafePinJia>(); SafeNews safenew = newmgr.FindById(Request["fid"].ToString()); if (safenew == null) { this.lbtitle.Text = "无法找到该记录,可能已经被删除!"; return; } this.lbtitle.Text = safenew.newstitle; this.Title = safenew.newstitle + "--安全新闻管理"; this.lbcontent.Text = safenew.newscontents; this.lbAinfo.Text = " 作者:" + safenew.createperson + " 最后修改:" + safenew.createtime + " 有效访问量:" + safenew.newskits.ToString(); this.RPMsgs.DataSource = Pinjiamgr.FindByCondition(" masterfid='" + safenew.fid + "'"); this.RPMsgs.DataBind(); }
public void UserDateBind() { CommonDao<V_HealthScoreHistory> HealthUserScoremgr = new CommonDao<V_HealthScoreHistory>(); string condition = " 1=1 "; if (this.TextBox1.Text.Trim() != "") { condition = condition + " and USERNAME like '%" + this.TextBox1.Text.ToString() + "%'"; } if (this.TextBox2.Text.Trim() != "") { condition = condition + " and STARTTIME >'" + this.TextBox2.Text.ToString() + "'"; } if (this.TextBox3.Text.Trim() != "") { condition = condition + " and STARTTIME <'" + this.TextBox3.Text.ToString() + "'"; } if (this.DropDownList2.Text.Trim() != "") { condition = condition + " and USERDOCTOR ='" + this.DropDownList2.Text.ToString() + "'"; } if (this.TextBox4.Text.Trim() != "") { string value = this.TextBox4.Text.ToString(); condition = condition + " and ( LIDAO <" + value + " or SHUSHIDU <" + value + " or LIAOXIAO <" + value + " or JIFA <" + value + " or FUWUTAIDU <" + value + ")"; } if (this.TextBox5.Text.Trim() != "") { string value = this.TextBox5.Text.ToString(); condition = condition + " and ( TOTALSUM < " + value + ")"; } //if (this.DropDownList1.Text.Trim() != "") //{ // condition = condition + " and userstate='" + this.DropDownList1.Text.ToString() + "'"; //} AspNetPager1.RecordCount = int.Parse(HealthUserScoremgr.GetTotalCount(condition)); Repeater1.DataSource = HealthUserScoremgr.FindAllByPageDesc(((AspNetPager1.CurrentPageIndex - 1) * AspNetPager1.PageSize).ToString(), AspNetPager1.PageSize.ToString(), condition); Repeater1.DataBind(); }
private void GetInfoImgs() { CommonDao<SafeNews> newmgr = new CommonDao<SafeNews>(); IList<SafeNews> list = newmgr.FindByIDdesc("5", " NewsInfoType = '安全新闻' and newstype = '图片新闻'"); foreach (SafeNews sn in list) { string img = GetFirstImg(sn.newspics); if (img != "") { pics += img + "|"; links += "Details.aspx?fid=" + sn.fid.ToString() + "|"; texts += (sn.newstitle.Length > 16 ? sn.newstitle.Substring(0, 16) + "..." : sn.newstitle) + "|"; } } pics = pics.TrimEnd('|') + "'"; links = links.TrimEnd('|') + "'"; texts = texts.TrimEnd('|') + "'"; }
protected void btn2_Clik(object sender, CommandEventArgs e) { CommonDao<HealthIPAddress> ipmgr = new CommonDao<HealthIPAddress>(); IList<HealthIPAddress> listhealthip = ipmgr.FindAll(); int count1 = 0; string clientIP = HttpContext.Current.Request.UserHostAddress.ToString(); count1 = int.Parse(ipmgr.GetTotalCount(" style='health' and left(IPAddress, len(IPAddress)-2)='" + ReturnIP(clientIP) + "'")); if (count1 > 0) { Response.Redirect("View/Default.aspx"); } else { MsgShow("对不起,该功能未对您开通。"); } }
internal List <PharmaBusinessObjects.Master.AccountLedgerMaster> GetAccountLedgerByLedgerTypeIdAndSearch(int ledgerTypeID, string searchString = null) { CommonDao commonDao = new CommonDao(); var accountLedgerMasterList = new AccountLedgerMasterDao(this.LoggedInUser).GetAccountLedgerByLedgerTypeIdAndSearch(ledgerTypeID, searchString); var accountLedgerTypeList = commonDao.GetAccountLedgerTypes() ?? new List <PharmaBusinessObjects.Common.AccountLedgerType>(); var AccountTypeList = new CommonBiz().GetAccountTypes() ?? new List <PharmaBusinessObjects.Common.AccountType>(); var creditControlCodeList = commonDao.GetAccountLedgerTypes().Where(p => p.AccountLedgerTypeSystemName == "ControlCodes").ToList() ?? new List <PharmaBusinessObjects.Common.AccountLedgerType>(); var debitControlCodeList = commonDao.GetAccountLedgerTypes().Where(p => p.AccountLedgerTypeSystemName == "ControlCodes").ToList() ?? new List <PharmaBusinessObjects.Common.AccountLedgerType>(); foreach (var accountLedger in accountLedgerMasterList) { accountLedger.AccountLedgerTypeList = accountLedgerTypeList ?? new List <PharmaBusinessObjects.Common.AccountLedgerType>(); accountLedger.AccountTypeList = AccountTypeList ?? new List <PharmaBusinessObjects.Common.AccountType>(); accountLedger.CreditControlCodeList = creditControlCodeList ?? new List <PharmaBusinessObjects.Common.AccountLedgerType>(); accountLedger.DebitControlCodeList = debitControlCodeList ?? new List <PharmaBusinessObjects.Common.AccountLedgerType>(); } return(accountLedgerMasterList); }
private void InfoBind() { string type = "安全公文"; if (Request["type"] != null) { type = Request["type"].ToString(); this.lableType.InnerHtml = " <span style='color: #0087ce;'>" + type + "</span>"; } CommonDao<SafeNews> newmgr = new CommonDao<SafeNews>(); string condition = " NewsInfoType = '安全信息' and newstype ='" + type + "' "; if (TextBoxSearch.Text.Trim().Length > 0) { condition = condition + " and newstitle like '%" + this.TextBoxSearch.Text.Trim().ToString() + "%'"; } Pager.RecordCount = int.Parse(newmgr.GetTotalCount(condition)); RepeaterPubGG.DataSource = newmgr.FindAllByPageDesc(((Pager.CurrentPageIndex - 1) * Pager.PageSize).ToString(), Pager.PageSize.ToString(), condition); RepeaterPubGG.DataBind(); }
// // GET: /Adopt/ /// <summary> /// 获取领养宠物信息 /// </summary> /// <param name="pageIndex">当前页码</param> /// <param name="limit">每页显示条数</param> /// <returns></returns> public JsonResult Index(int pageIndex, int limit) { AdoptPet adoption = new AdoptPet(); PagingModel <WebCommonModel> _pageKnowledge = new PagingModel <WebCommonModel>(); List <WebCommonModel> commonList = new List <WebCommonModel>(); List <CVAdoptPet> adoptList = new List <CVAdoptPet>(); //获取总页数 int count = 0; try { adoptList = adoption.GetPetAdoptPerPageList(pageIndex, limit, out count); commonList = CommonDao.DataTransferToAdoptionWebCommonModelList(adoptList); _pageKnowledge.total = count; _pageKnowledge.records = commonList; } catch (Exception ex) { throw ex; } return(Json(_pageKnowledge, JsonRequestBehavior.AllowGet)); }
private void SetDefaultdata() { if (Request.QueryString["fid"] != null) { CommonDao<SafePitFalls> newmgr = new CommonDao<SafePitFalls>(); SafePitFalls spf = newmgr.FindById(Request.QueryString["fid"]); if (spf != null) { this.TextBoxDate.Text = DateTime.Parse(spf.time).ToShortDateString(); SetDropValueDefault(spf.dept, spf.person); //ListItem itmSelected = DropDownListQuyu.Items.FindByValue(spf.area); //if (itmSelected != null) { itmSelected.Selected = true; } ListItem itmSelected1 = DropDownListDept.Items.FindByValue(spf.dept); if (itmSelected1 != null) { itmSelected1.Selected = true; } ListItem itmSelected2 = DropDownListPerson.Items.FindByValue(spf.person); if (itmSelected2 != null) { itmSelected2.Selected = true; } this.TextBoxfk.Text = spf.Fine == null ? "" : spf.Fine.ToString(); this.TextAreaQuYu.InnerText = spf.area == null ? "" : spf.area.ToString(); this.TextAreaJieguo.InnerHtml = spf.pitresult == null ? "" : spf.pitresult.ToString(); this.TextAreaYijian.InnerHtml = spf.pitsuggestion == null ? "" : spf.pitsuggestion.ToString(); this.TextAreaYinhuan.InnerHtml = spf.pitcontents.ToString(); } else { MessageBox.ShowAndRedirect(this, "出错了,资源未找到!", "SafeAdmin.aspx"); } } }
private static void exportCSV(String path, String tableName) { CommonDao commonDao = new CommonDao(); SqlDataReader reader = commonDao.getAllData(tableName); StringBuilder sb = new StringBuilder(); StreamWriter sw = new StreamWriter(path + "\\" + tableName + ".csv", false, Encoding.UTF8); //Get All column var columnNames = Enumerable.Range(0, reader.FieldCount) .Select(reader.GetName) //OR .Select("\""+ reader.GetName"\"") .ToList(); //Create headers sb.Append(string.Join(",", columnNames)); //Append Line sb.AppendLine(); while (reader.Read()) { for (int i = 0; i < reader.FieldCount; i++) { string value = reader[i].ToString(); if (value.Contains(",")) { value = "\"" + value + "\""; } sb.Append(value.Replace(Environment.NewLine, " ") + ","); } sb.Length--; // Remove the last comma sb.AppendLine(); } sw.Write(sb.ToString()); sw.Close(); reader.Close(); }
/// <summary> /// Update user's skin /// </summary> /// <param name="skin"></param> /// <returns></returns> public int UpdateUserSkin(string skin) { CommonDao commonDao = new CommonDao(); return(commonDao.UpdateUserSkin(UserSession.UserCode, skin)); }
public LoginController(ILogger <LoginController> logger, AppSoftDbContext context) { _logger = logger; _context = context; _commonDao = new CommonDao(context); }
/// <summary> /// Select user's skin /// </summary> /// <param name="skin"></param> /// <returns></returns> public int SelectUserSkinData(out string skin) { CommonDao commonDao = new CommonDao(); return(commonDao.SelectUserSkinData(UserSession.UserCode, out skin)); }
public FileController(AppSoftDbContext context) { _context = context; _fileMngTool = new FileMngTool(context); _commonDao = new CommonDao(context); }
public FileMngTool(AppSoftDbContext context) { _context = context; _commonDao = new CommonDao(context); }
public StandInqireController(ILogger <StandInqireController> logger, AppSoftDbContext context) { _logger = logger; _context = context; _commonDao = new CommonDao(context); }