public IActionResult Index() { try { //Get Daily string sp = "sp_DashboardDaily"; DataTable dt = SqlHelp.ExecQuery(sp, new List <Microsoft.Data.SqlClient.SqlParameter>()); // ViewBag.Trolley = dt.Rows[0]["Trolley"].ToString(); ViewBag.Kanban = dt.Rows[0]["Kanban"].ToString(); ViewBag.TrolleyDelay = dt.Rows[0]["TrolleyDelay"].ToString(); //For Chart Daily ViewBag.ChartDailyText = $"Trolley,Kanban,Delay"; ViewBag.ChartDailyVal = $"{Convert.ToInt32(dt.Rows[0]["Trolley"].ToString())},{Convert.ToInt32(dt.Rows[0]["Kanban"].ToString())},{Convert.ToInt32(dt.Rows[0]["TrolleyDelay"].ToString())}"; //Chart Monthly sp = "sp_DashboardMonthly"; dt = SqlHelp.ExecQuery(sp, new List <Microsoft.Data.SqlClient.SqlParameter>()); //For Chart Monthly ViewBag.ChartMonthlyText = string.Join(',', dt.AsEnumerable().Select(x => x.Field <DateTime>("Tgl").ToString("dd")).ToArray()); ViewBag.ChartMonthlyTrolley = string.Join(',', dt.AsEnumerable().Select(x => x.Field <int>("Trolley")).ToArray()); ViewBag.ChartMonthlyKanban = string.Join(',', dt.AsEnumerable().Select(x => x.Field <int>("Kanban")).ToArray()); ViewBag.ChartMonthlyDelay = string.Join(',', dt.AsEnumerable().Select(x => x.Field <int>("TrolleyDelay")).ToArray()); } catch (Exception ex) { LogHelp.WriteErrorLog(ex); } //Return IndexPrep(); return(View()); }
public IActionResult Detail(Int16 id) { try { SyUser data; if (id == 0) { data = new SyUser() { IsActive = true //default Active } } ; else { data = DbContext.SyUser.Where(a => a.UserId == id).FirstOrDefault(); if (data == null) { return(NotFound()); } else { data.Password = EncryptHelper.ConvertToDecrypt(data.Password); } } SetViewBag(); return(View(data)); } catch (Exception e) { LogHelp.WriteErrorLog(e); } return(View()); }
public async Task <IActionResult> Detail(int id) { IndexPrep(); try { KanbanRequest data = await DbContext.KanbanRequest.Where(a => a.KanbanReqId == id).FirstOrDefaultAsync(); if (id != 0 && data == null) { return(NotFound()); } if (id == 0) { data = new KanbanRequest(); data.RequestDateTime = DateTime.Now; data.StatusId = 1; data.LotNumber = 640; data.TagRequestNo = 0; } SetViewBag(data); //ViewBag.Message = ""; return(View(data)); } catch (Exception e) { LogHelp.WriteErrorLog(e); } return(View()); }
/// <summary> /// 开始处理 /// </summary> /// <param name="listenerInfo"></param> public void BeginProcess(ListenerInfo listenerInfo) { SocketHelper.ConfigInfo = listenerInfo; SocketHelper.MessageReviced += new EventHandler <MessageRevicedEventArgs>(SocketHelper_MessageReviced); try { SocketHelper.BeginListen(); } catch (Exception ex) { LogHelp.WriteErrorLog("异常:", ex.ToString()); } }
public string GetData(byte roleId) { try { string sp = "sp_UserGetData"; List <SqlParameter> param = new List <SqlParameter>(); DataTable dt = SqlHelp.ExecQuery(sp, param); string json = JsonConvert.SerializeObject(dt); return(json); } catch (Exception e) { LogHelp.WriteErrorLog(e); } return(""); }
/// <summary> /// 返回DataTable /// </summary> /// <param name="str"></param> /// <returns></returns> public DataTable GetDataTable(string sql) { try { SqlConnection con = new SqlConnection(connStr); SqlDataAdapter adp = new SqlDataAdapter(sql, con); DataSet ds = new DataSet(); adp.Fill(ds); return(ds.Tables[0]); } catch (Exception ex) { string s = ex.ToString(); LogHelp.WriteErrorLog(ex.ToString()); return(null); } }
/// <summary> /// 代理服务器设置 /// </summary> /// <param name="request"></param> /// <param name="ProxyAddress">代理服务地址</param> /// <param name="ProxyUser">用户</param> /// <param name="ProxyKey">密码</param> public void ProxySetting(WebRequest request, string ProxyAddress, string ProxyUser, string ProxyKey) { try { WebProxy proxy = new WebProxy(ProxyAddress, true); if (!string.IsNullOrEmpty(ProxyAddress) && !string.IsNullOrEmpty(ProxyUser) && !string.IsNullOrEmpty(ProxyKey)) //如果地址为空,则不需要代理服务器 { proxy.Credentials = new NetworkCredential(ProxyUser, ProxyKey); //从配置封装参数中创建 } request.Proxy = proxy; //赋予 request.Proxy LogHelp.WriteInfoLog("JLF.Form.WebService", "代理服务器设置成功!代理服务host和port:" + ProxyAddress + "用户名:" + ProxyUser); } catch (Exception ex) { LogHelp.WriteErrorLog("JLF.Form.WebService", "代理服务器设置失败!代理服务host和port:" + ProxyAddress + "用户名:" + ProxyUser + ",错误原因:" + ex.Message); } }
private int GenerateReqNo() { int maxReqNo = 0; try { KanbanRequest data = DbContext.KanbanRequest.Where(a => a.RequestDateTime.Year == DateTime.Today.Year && a.RequestDateTime.Month == DateTime.Today.Month) .OrderByDescending(a => a.TagRequestNo).FirstOrDefault(); if (data != null) { maxReqNo = data.TagRequestNo; } } catch (Exception e) { LogHelp.WriteErrorLog(e); } return(maxReqNo + 1); }
public IActionResult ItemDetail(int id, int kanbanReqId) { try { KanbanReqItem data = DbContext.KanbanReqItem.Where(a => a.ReqItemId == id).FirstOrDefault(); if (data == null) { data = new KanbanReqItem(); data.KanbanReqId = kanbanReqId; } SetViewBagItem(data); return(View(data)); } catch (Exception e) { LogHelp.WriteErrorLog(e); } return(View()); }
/// <summary> /// 返回第一行第一列 /// </summary> /// <param name="str"></param> /// <returns></returns> public object ExecuteScalar(string sql) { try { object obj = null; using (SqlConnection con = new SqlConnection(connStr)) { con.Open(); SqlCommand cmd = new SqlCommand(sql, con); obj = cmd.ExecuteScalar(); } return(obj); } catch (Exception ex) { LogHelp.WriteErrorLog(ex.ToString()); return(null); } }
/// <summary> /// 增删改、返回影响行数 /// </summary> /// <param name="str"></param> /// <returns></returns> public int ExecuteNonQuery(string sql) { try { int i = 0; using (SqlConnection con = new SqlConnection(connStr)) { con.Open(); SqlCommand cmd = new SqlCommand(sql, con); i = cmd.ExecuteNonQuery(); } return(i); } catch (Exception ex) { LogHelp.WriteErrorLog(ex.ToString()); return(0); } }
public string GetData(int lineId) { try { string sp = "sp_KanbanStatusGetData"; List <SqlParameter> param = new List <SqlParameter> { new SqlParameter("@lineId", lineId) }; DataTable dt = SqlHelp.ExecQuery(sp, param); string json = JsonConvert.SerializeObject(dt); return(json); } catch (Exception e) { LogHelp.WriteErrorLog(e); } return(""); }
public string GetData(int lineId, DateTime requestDate) { try { string sp = "sp_DailyReportGetData"; List <SqlParameter> param = new List <SqlParameter> { new SqlParameter("@lineId", lineId), new SqlParameter("@requestDate", requestDate) }; DataTable dt = SqlHelp.ExecQuery(sp, param); string json = JsonConvert.SerializeObject(dt); return(json); } catch (Exception e) { LogHelp.WriteErrorLog(e); } return(""); }
public async Task <IActionResult> CancelSave(KanbanRequest model) { bool status = false; if (string.IsNullOrEmpty(model.CancelNote)) { ModelState.AddModelError("CancelNote", "The Cancel Note field is required"); } //if (ModelState.IsValid) else { KanbanRequest data = await DbContext.KanbanRequest.Where(a => a.KanbanReqId == model.KanbanReqId).FirstOrDefaultAsync(); try { if (data == null) { return(NotFound()); } else { data.CancelNote = model.CancelNote; data.StatusId = 2; data.EditDate = DateTime.Now; data.EditBy = LoginInfo.UserId; DbContext.KanbanRequest.Update(data); DbContext.SaveChanges(); status = true; } } catch (Exception e) { LogHelp.WriteErrorLog(e); } } IndexPrep(); return(Json(new { status, html = ViewHelper.RenderRazorViewToString(this, "CancelNote", model) })); //return Json(new { status }); }
public async Task <IActionResult> Delete(int id) { KanbanRequest model = await DbContext.KanbanRequest.Where(a => a.KanbanReqId == id).FirstOrDefaultAsync(); try { ViewBag.PartFGNo = ""; ViewBag.PartFGName = ""; ViewBag.LineNo = ""; ViewBag.LineName = ""; ViewBag.StatusName = ""; if (model != null) { MsPartFG partFG = DbContext.MsPartFG.Where(a => a.PartFGId == model.PartFGId).FirstOrDefault(); if (partFG != null) { ViewBag.PartFGNo = partFG.PartFGNo; ViewBag.PartFGName = partFG.PartFGName; MsLine line = DbContext.MsLine.Where(a => a.LineId == partFG.LineId).FirstOrDefault(); if (line != null) { ViewBag.LineNo = line.LineNo; ViewBag.LineName = line.LineName; } } ViewBag.StatusName = FrmHelp.GetKanbanStatusName(model.StatusId); } else { return(NotFound()); } } catch (Exception e) { LogHelp.WriteErrorLog(e); } return(View(model)); }
/// <summary> /// 消息达到后交个Biz处理 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void SocketHelper_MessageReviced(object sender, MessageRevicedEventArgs e) { string sendingApp = AppSettingString.SendingApp; string recvApp = AppSettingString.RecvApp; //System.Configuration.ConfigurationManager.AppSettings["recvApp"]; try { DBConn dbcon = new DBConn(); PipeParser parser = new PipeParser(); //解析出消息类型,创建对应的Biz进行处理 string message = System.Text.Encoding.UTF8.GetString(e.Contents); message = MediII.Common.MLLPHelper.TrimMLLP(message, true, false); LogHelp.WriteLog(message); ////手术字典 //if (message.Contains(_AcceptTitleOperDic)) //{ // OperDicModel dic = HL7ToXmlConverter.ToOperDic(message); // dbcon.InsertOperDic(dic); //} if (message.Contains(_NewOperApply)) { OTypesetting paiban = null; paiban = HL7ToXmlConverter.toDataBae(message, paiban); if (dbcon.GetPaiban(paiban.PatZhuYuanID) == null) { dbcon.InsertPaiban(paiban); } } //修改 else if (message.Contains(_UpdateOperApply)) { string zhuyuanid = HL7ToXmlConverter.GetZhuyuanId(message); OTypesetting paiban = dbcon.GetPaiban(zhuyuanid); paiban = HL7ToXmlConverter.toDataBae(message, paiban); if (paiban != null) { if (paiban.Ostate == 0) { dbcon.UpdatePaiban(paiban); } } } else if (message.Contains(_CancelOperApply)) { string zhuyuanid = ""; message = message.Replace("ARQ", "\nARQ"); string[] sList = message.Split('\n'); foreach (string str in sList) { if (str.Contains("ARQ|")) { zhuyuanid = str.Split('|')[1].Replace("^", ""); } } dbcon.UpdatePaibanOstate(zhuyuanid, -1); } //string mesStruct = parser.GetMessageStructure(message).Substring(0, 3); string ackMsg = MediII.Common.MessageHelper.SetACK("ACK", "", "", recvApp, recvApp, sendingApp, sendingApp, Guid.NewGuid().ToString("N")); LogHelp.WriteLog(ackMsg); SocketHelper.SendAck(MediII.Common.MLLPHelper.AddMLLP(ackMsg), e.SocketHandler); } catch (Exception ex) { //出现异常需要返回,避免队列堵塞 string ackMsg = MediII.Common.MessageHelper.SetACK("ACK", "", "", recvApp, recvApp, sendingApp, sendingApp, Guid.NewGuid().ToString("N"), ex.Message); LogHelp.WriteErrorLog(ackMsg); SocketHelper.SendAck(MediII.Common.MLLPHelper.AddMLLP(ackMsg), e.SocketHandler); MediII.Common.LogHelper.LogError(ex, Common.LogCatagories.AdapterBiz); } }
/// <summary> /// 登录 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnLogin_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(Convert.ToString(cmbYiyuan.Text.Trim()))) { MessageBox.Show("请请选择医院代号!"); cmbYiyuan.Focus(); return; } if (string.IsNullOrEmpty(Convert.ToString(txtLoginName.Text.Trim()))) { MessageBox.Show("请输入 用户名!"); txtLoginName.Focus(); return; } if (string.IsNullOrEmpty(Convert.ToString(txtPassWord.Text.Trim()))) { MessageBox.Show("请输入 密码!"); txtPassWord.Focus(); return; } try { string uid = txtLoginName.Text.Trim(); string password = txtPassWord.Text.Trim(); DataTable dtUser = bll.Get_user_info(uid, password); if (dtUser.Rows.Count != 0) { LogHelp.SaveLoginConfigure(cmbYiyuan.Text); Program.Customer.user_name = dtUser.Rows[0][2].ToString(); Program.Customer.position = dtUser.Rows[0][3].ToString(); Program.Customer.userno = dtUser.Rows[0][4].ToString(); if (cmbYiyuan.Text.Trim() == "江苏盛泽医院") { Program.Customer.yiyuanType = "010601"; } else if (cmbYiyuan.Text.Trim() == "妇幼保健中心") { Program.Customer.yiyuanType = "010604"; } string jurisdiction = bll.Get_user_jurisdiction(Program.Customer); int jurisdiction_Length = jurisdiction.Length; Program.jurisdiction = new bool[jurisdiction_Length]; Char[] temp = new char[jurisdiction_Length]; temp = jurisdiction.ToCharArray(); for (int j = 0; j < jurisdiction.Length; j++) { Program.jurisdiction[j] = (temp[j] == '1') ? true : false; } DialogResult = DialogResult.OK; LockSet f1 = new LockSet(); f1.timer11.Start(); //定时锁定程序 loginCount++; } else { MessageBox.Show("账号或密码错误,请检查。"); txtPassWord.Text = string.Empty; } } catch (Exception ex) { string errorStr = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "服务器中断,登陆失败!!"; LogHelp.WriteErrorLog(errorStr); MessageBox.Show("登录失败!", ex.ToString()); this.txtPassWord.Text = string.Empty; } }
public async Task <IActionResult> Save(SyUser model) { bool status = false; //validation bool isExist; isExist = DbContext.SyUser.Any(a => a.UserId != model.UserId && a.UserName == model.UserName); if (isExist) { ModelState.AddModelError("UserName", "User " + model.UserName + " is already existed."); } if (ModelState.IsValid) { try { SyUser data; if (model.UserId == 0) { data = new SyUser(); } else { data = await DbContext.SyUser.FirstOrDefaultAsync(a => a.UserId == model.UserId); if (data == null) { return(NotFound()); } } data.UserName = model.UserName; data.Password = EncryptHelper.ConvertToEncrypt(model.Password); data.RealName = model.RealName; data.RoleId = model.RoleId; data.LineId = model.LineId; data.IsActive = model.IsActive; if (model.UserId == 0) { data.InsertDate = DateTime.Now; data.InsertBy = LoginInfo.UserId; DbContext.SyUser.Add(data); } else { data.EditDate = DateTime.Now; data.EditBy = LoginInfo.UserId; DbContext.SyUser.Update(data); } DbContext.SaveChanges(); status = true; } catch (Exception e) { LogHelp.WriteErrorLog(e); } return(Json(new { status })); } else { SetViewBag(); return(Json(new { status, html = ViewHelper.RenderRazorViewToString(this, "Detail", model) })); } }
public async Task <IActionResult> Detail(KanbanRequest model, string button) { ViewBag.Message = ""; if (button == "cancel" && string.IsNullOrEmpty(model.CancelNote)) { ModelState.AddModelError("CancelNote", "The Cancel Note field is required"); } if (ModelState.IsValid) { switch (button) { case "save": model.StatusId = 1; if (model.KanbanReqId == 0) { model.RequestDateTime = DateTime.Now; model.TagRequestNo = GenerateReqNo(); } break; case "cancel": model.StatusId = 2; break; case "send": model.StatusId = 3; model.SendDateTime = DateTime.Now; break; case "receive": model.StatusId = 5; model.ReceiveDateTime = DateTime.Now; break; } KanbanRequest data = await DbContext.KanbanRequest.Where(a => a.KanbanReqId == model.KanbanReqId).FirstOrDefaultAsync(); try { if (data == null) { model.InsertDate = DateTime.Now; model.InsertBy = LoginInfo.UserId; DbContext.KanbanRequest.Add(model); DbContext.SaveChanges(); GenerateItem(model.KanbanReqId, model.PartFGId, model.LotNumber); } else { data.RequestDateTime = model.RequestDateTime; data.TagRequestNo = model.TagRequestNo; data.StatusId = model.StatusId; data.PartFGId = model.PartFGId; data.LotNumber = model.LotNumber; data.TrolleyNo = model.TrolleyNo; data.SendDateTime = model.SendDateTime; data.ReceiveDateTime = model.ReceiveDateTime; data.EditDate = DateTime.Now; data.EditBy = LoginInfo.UserId; DbContext.KanbanRequest.Update(data); DbContext.SaveChanges(); } } catch (Exception e) { LogHelp.WriteErrorLog(e); } switch (button) { case "save": ViewBag.Message = "Data has been saved."; break; case "cancel": ViewBag.Message = "Data has been cancelled."; break; case "send": ViewBag.Message = "Kanban Request been sent to WH."; break; case "receive": ViewBag.Message = "Trolley has been received."; break; } //return RedirectToAction("Detail", "KanbanRequest", new { id = model.KanbanReqId }); } IndexPrep(); SetViewBag(model); return(View(model)); }