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);
}
