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