public void CreateResend(int activityInstId, int workerId, string remark)
{
m_ActivityInstance = new ActivityInstance(activityInstId);
m_State = WorkItemState.Waiting;
m_WorkItemId = PrimaryKeyCreater.getIntPrimaryKey("F_INST_WORKITEM");
F_INST_WORKITEM instWorkItem = new F_INST_WORKITEM();
instWorkItem.ID = m_WorkItemId;
instWorkItem.ActivityInstID = activityInstId;
instWorkItem.Actorid = workerId;
instWorkItem.Role = "申请人重新送出";
instWorkItem.Assigneeid = workerId;
instWorkItem.Assignerid = 0;
instWorkItem.BeginDate = DateTime.Now;
instWorkItem.EndDate = DateTime.Now;
instWorkItem.State = WorkItemState.Completed;
instWorkItem.AppType = WorkItemApproveType.Blank;
instWorkItem.AssignType = WorkItemAssignType.Normal;
instWorkItem.AppValue = string.Empty;
instWorkItem.AppRemark = remark;
DAL.WorkFlow.WorkItemInstance.Insert(instWorkItem);
}
public static E_Mail CreateMail(string title, string content, string toID)
{
using (MainDataContext dbContext = new MainDataContext())
{
E_Mail mail = new E_Mail();
//邮件主表
mail.ID = PrimaryKeyCreater.getIntPrimaryKey("E_Mail");
mail.From = "系统";
mail.Title = title;
mail.Body = content;
mail.CreateTime = DateTime.Now;
mail.SendDate = DateTime.Now;
List <string> toStr = new List <string>();
foreach (string r in toID.Split(',').ToList())
{
int id = int.Parse(r); //人员ID
string name = dbContext.B_WORKER.FirstOrDefault(b => b.ID == id).Name;
toStr.Add(name);
}
mail.To = String.Join(",", toStr);
return(mail);
}
}
public int CreateFlowNo(int flowId)
{
//IApplicationContext ctx = ContextRegistry.GetContext();
//IPrimaryKeyCreater prikey = ctx["PrimaryKeyCreater"] as IPrimaryKeyCreater;
//m_FlowNo = prikey.getIntPrimaryKey(string.Format("TB_{0}", flowId));
return(PrimaryKeyCreater.getIntPrimaryKey("FlowNo"));
}
public void Create(int activityInstId, int transId)
{
m_Transation = new Transation(transId);
m_ActivityInstance = new ActivityInstance(activityInstId);
//IPrimaryKeyCreater prikey = ctx["PrimaryKeyCreater"] as IPrimaryKeyCreater;
m_TransationInstanceId = PrimaryKeyCreater.getIntPrimaryKey("F_INST_TRANSATION");
F_INST_TRANSATION instTrans = new F_INST_TRANSATION();
instTrans.ID = m_TransationInstanceId;
instTrans.ActivityInstID = activityInstId;
instTrans.TransationID = transId;
instTrans.PassTime = DateTime.Now;
instTrans.TransationValue = "";
DAL.WorkFlow.TransationInstance.Insert(instTrans);
}
public static bool Save(TAmbulance entity)
{
using (MainDataContext dbContext = new MainDataContext(AppConfig.ConnectionStringDispatch))
{
if (entity.车辆编码 == "0") //添加
{
entity.车辆编码 = PrimaryKeyCreater.getIntPrimaryKey("TAmbulance").ToString("00000");
entity.分站编码 = entity.分站编码.PadLeft(3, '0');
entity.命令单发送去向编码 = 5;
entity.任务编码 = "";
entity.任务流水号 = 0;
entity.用户流水号 = "";
entity.工作状态编码 = 8;
entity.当班执行任务数 = 0;
entity.司机 = "";
entity.医生 = "";
entity.护士 = "";
entity.担架工 = "";
entity.抢救员 = "";
entity.是否在线 = false;
entity.是否有效 = true;
entity.顺序号 = 999;
dbContext.TAmbulance.InsertOnSubmit(entity);
dbContext.SubmitChanges();
return(true);
}
else //修改
{
var model = dbContext.TAmbulance.FirstOrDefault(t => t.车辆编码 == entity.车辆编码);
model.分站编码 = entity.分站编码 == "0" ? "000" : entity.分站编码;
model.随车电话 = entity.随车电话;
model.实际标识 = entity.实际标识;
model.车牌号码 = entity.车牌号码;
model.车辆等级编码 = entity.车辆等级编码;
model.车辆类型编码 = entity.车辆类型编码;
dbContext.SubmitChanges();
return(true);
}
}
}
/// <summary>
/// 创建关卡实例
/// </summary>
/// <param name="instFlow"></param>
/// <param name="activity"></param>
/// <returns></returns>
public void Create(int flowInstId, int activityId)
{
this.FlowInstance = new FlowInstance(flowInstId);
this.Activity = new Activity(activityId);
this.State = ActivityInstanceStatus.InActive;
//新增关卡实例
//IPrimaryKeyCreater prikey = ctx["PrimaryKeyCreater"] as IPrimaryKeyCreater;
m_ActivityInstanceId = PrimaryKeyCreater.getIntPrimaryKey("F_INST_ACTIVITY");
F_INST_ACTIVITY instActivity = new F_INST_ACTIVITY();
instActivity.ID = m_ActivityInstanceId;
instActivity.ActivityID = activityId;
instActivity.BeginDate = DateTime.Now;
instActivity.EndDate = null;
instActivity.FlowInstID = flowInstId;
instActivity.State = ActivityInstanceStatus.InActive;
DAL.WorkFlow.ActivityInstance.Insert(instActivity);
}
/// <summary>
/// 创建流程实例
/// </summary>
/// <param name="flow"></param>
/// <returns></returns>
public void Create(int flowId, int flowNo, int applyerId, string digest)
{
m_FlowDefine = new FlowDefine(flowId);
F_INST_FLOW inst = new F_INST_FLOW();
//IPrimaryKeyCreater prikey = ctx["PrimaryKeyCreater"] as IPrimaryKeyCreater;
m_FlowInstanceId = PrimaryKeyCreater.getIntPrimaryKey("F_INST_FLOW");
inst.ID = m_FlowInstanceId;
inst.ApplyerID = applyerId;
inst.BeginDate = DateTime.Now;
inst.EndDate = null;
inst.FlowID = flowId;
inst.State = FlowInstanceState.InActive;
inst.FlowNo = flowNo;
inst.Digest = digest;
DAL.WorkFlow.FlowInstance.Insert(inst);
}
public void Create(int activityInstId, int workerId)
{
m_ActivityInstance = new ActivityInstance(activityInstId);
m_State = WorkItemState.Waiting;
//IPrimaryKeyCreater prikey = ctx["PrimaryKeyCreater"] as IPrimaryKeyCreater;
m_WorkItemId = PrimaryKeyCreater.getIntPrimaryKey("F_INST_WORKITEM");
F_INST_WORKITEM instWorkItem = new F_INST_WORKITEM();
instWorkItem.ID = m_WorkItemId;
instWorkItem.ActivityInstID = activityInstId;
instWorkItem.Actorid = null;
instWorkItem.Role = m_ActivityInstance.Activity.Name;
instWorkItem.Assigneeid = workerId;
instWorkItem.Assignerid = 0;
instWorkItem.BeginDate = DateTime.Now;
instWorkItem.EndDate = null;
instWorkItem.State = WorkItemState.Waiting;
instWorkItem.AppType = WorkItemApproveType.Normal;
instWorkItem.AssignType = WorkItemAssignType.Normal;
DAL.WorkFlow.WorkItemInstance.Insert(instWorkItem);
}
public static TOffice GetOffice(int?officeId)
{
using (MainDataContext dbContext = new MainDataContext())
{
if (officeId != null) // 修改
{
return(dbContext.TOffice.FirstOrDefault(t => t.编码 == officeId));
}
else //新增
{
var list = dbContext.TOffice.Select(t => t.编码);
TOffice entity = new TOffice();
entity.编码 = PrimaryKeyCreater.getIntPrimaryKey("TOffice");
entity.接收人 = string.Empty;
entity.办公类型编码 = string.Empty;
entity.标题 = string.Empty;
entity.作者 = string.Empty;
entity.内容 = string.Empty;
entity.创建时间 = DateTime.Now;
return(entity);
}
}
}
//
// GET: /Email/
#region 写信
public ActionResult Write(int?pageNumber, int?mailID, string type)
{
BLL.Email.Email email = new BLL.Email.Email();
this.ViewData["WriterID"] = User.Identity.Name.Split('|')[0];
this.ViewData["WriterName"] = User.Identity.Name.Split('|')[1]; //发信人
if (mailID != null)
{
if (type == "reply") //回复
{
this.ViewData["MailID"] = PrimaryKeyCreater.getIntPrimaryKey("E_Mail"); //邮件编号
this.ViewData["CreateTime"] = DateTime.Now.AddDays(0).ToString("yyyy-MM-dd HH:mm:ss");; //创建时间
E_Mail mail = email.GetMailInfo((int)mailID);
this.ViewData["To"] = mail.From; //收件人
this.ViewData["Title"] = "回复:" + mail.Title; //主题
this.ViewData["Body"] = "<br><hr>" + mail.Body; //内容
List <E_Mail_Worker> toWorker = email.GetMailWorker((int)mailID, 0); //收件人ID
List <int> toStr = new List <int>();
foreach (E_Mail_Worker w in toWorker)
{
toStr.Add(w.WorkerId);
}
this.ViewData["toID"] = String.Join(",", toStr);
}
else if (type == "forward") //转发
{
this.ViewData["MailID"] = PrimaryKeyCreater.getIntPrimaryKey("E_Mail"); //邮件编号
this.ViewData["CreateTime"] = DateTime.Now.AddDays(0).ToString("yyyy-MM-dd HH:mm:ss");; //创建时间
E_Mail mail = email.GetMailInfo((int)mailID);
this.ViewData["Title"] = "转发:" + mail.Title; //主题
this.ViewData["Body"] = "<br><hr>" + mail.Body; //内容
}
else //草稿
{
this.ViewData["pageNumber"] = pageNumber;
E_Mail mail = email.GetMailInfo((int)mailID);
this.ViewData["MailID"] = mailID; //邮件编号
this.ViewData["CreateTime"] = mail.CreateTime; //创建时间
this.ViewData["To"] = mail.To; //收件人
this.ViewData["CC"] = mail.CC == null ? "" : mail.CC; //抄送
//this.ViewData["SC"] = mail.SC; //密送
this.ViewData["Title"] = mail.Title; //主题
this.ViewData["Body"] = mail.Body; //内容
List <E_Mail_Worker> toWorker = email.GetMailWorker((int)mailID, 1); //收件人ID
List <int> toStr = new List <int>();
foreach (E_Mail_Worker w in toWorker)
{
toStr.Add(w.WorkerId);
}
this.ViewData["toID"] = String.Join(",", toStr);
List <E_Mail_Worker> ccWorker = email.GetMailWorker((int)mailID, 2); //抄送人ID
List <int> ccStr = new List <int>();
foreach (E_Mail_Worker w in ccWorker)
{
ccStr.Add(w.WorkerId);
}
this.ViewData["ccID"] = String.Join(",", ccStr);
}
}
else
{
this.ViewData["MailID"] = PrimaryKeyCreater.getIntPrimaryKey("E_Mail"); //邮件编号
this.ViewData["CreateTime"] = DateTime.Now.AddDays(0).ToString("yyyy-MM-dd HH:mm:ss");
this.ViewData["toID"] = string.Empty; //收件人ID
this.ViewData["To"] = string.Empty; //收件人
this.ViewData["CC"] = string.Empty; //抄送
this.ViewData["ccID"] = string.Empty; //抄送人ID
this.ViewData["SC"] = string.Empty; //密送
this.ViewData["Title"] = string.Empty; //主题
this.ViewData["Body"] = string.Empty; //内容
}
return(View());
}
/// <summary>
/// 得到邮件相关人
/// </summary>
/// <returns></returns>
public List <E_Mail_Worker> GetMailWorker(E_Mail entity, string fromID, string toID, string ccID, string isSend)
{
List <E_Mail_Worker> mailWorker = new List <E_Mail_Worker>();
E_Mail_Worker mailS = new E_Mail_Worker();
//发件人(类型为0)
mailS.ID = PrimaryKeyCreater.getIntPrimaryKey("E_Mail_Worker");
mailS.MailId = entity.ID;
mailS.WorkerId = int.Parse(fromID);
mailS.Type = 0;
mailS.ReadFlag = "1"; //默认已读
if (isSend == "1")
{
mailS.FolderID = 3; //已发送
}
else
{
mailS.FolderID = 2; //草稿箱
}
mailWorker.Add(mailS);
//收件人(类型为1)
foreach (string r in toID.Split(',').ToList())
{
E_Mail_Worker mailR = new E_Mail_Worker();
mailR.ID = PrimaryKeyCreater.getIntPrimaryKey("E_Mail_Worker");
mailR.MailId = entity.ID;
mailR.WorkerId = int.Parse(r);
mailR.Type = 1;
mailR.ReadFlag = "0";
if (isSend == "1")
{
mailR.FolderID = 1; //收件箱
}
else
{
mailR.FolderID = 5; //临时文件夹
}
mailWorker.Add(mailR);
}
//抄送人(类型为2)
if (!string.IsNullOrEmpty(ccID))
{
foreach (string r in ccID.Split(',').ToList())
{
E_Mail_Worker mailCC = new E_Mail_Worker();
mailCC.ID = PrimaryKeyCreater.getIntPrimaryKey("E_Mail_Worker");
mailCC.MailId = entity.ID;
mailCC.WorkerId = int.Parse(r);
mailCC.Type = 2;
mailCC.ReadFlag = "0";
if (isSend == "1")
{
mailCC.FolderID = 1; //收件箱
}
else
{
mailCC.FolderID = 5; //临时文件夹
}
mailWorker.Add(mailCC);
}
}
return(mailWorker);
}