/// <summary>
/// 获取所有角色
/// </summary>
/// <param name="id">角色ID</param>
/// <returns>List</returns>
public static List <B_ROLE> LoadAllRole()
{
using (MainDataContext dbContext = new MainDataContext())
{
return(dbContext.B_ROLE.ToList());
}
}
public static F_TRANSITION Get(int id)
{
using (MainDataContext dbContext = new MainDataContext())
{
return(dbContext.F_TRANSITION.FirstOrDefault(t => t.ID == id));
}
}
public static List <string> LoadRoleActionRange(int roleId)
{
using (MainDataContext dbContext = new MainDataContext())
{
List <string> listA = (from r in dbContext.B_ROLE_ACTION
join a in dbContext.B_ACTION on r.ActionID equals a.ID
where r.RoleID == roleId && a.ParentID != 0
select r.ActionID).ToList()
.Select(t => "a-" + t.ToString())
.ToList <string>();
//List<C_TelBook> lr = (from r in dbContext.B_ROLE_Range
// join a in dbContext.B_Range
// on new { ActionID = r.ActionID, r.Range } equals new { ActionID = a.ActionId, a.Range }
// where r.RoleID == roleId
// select new C_TelBook { ID = r.ActionID, Name = r.Range, OwnerID = 0, OrderNo=0 }).ToList();
//List<string> listR = lr
// //"r-" + SqlFunctions.StringConvert((decimal)r.ActionID) + "-" + r.Range)
// .Select(t => "r-" + t.ID.ToString() + "-" + t.Name)//用C_TelBook对象就是为了类型转化 暂用下吧
// .ToList<string>();
List <string> listR = dbContext.ExecuteQuery <string>(string.Format(@"
select 'r-' + convert(varchar(20),r.ActionID)+'-'+ r.Range
from B_ROLE_Range r
join B_Range a on r.ActionID=a.ActionId and r.Range=a.Range
where r.RoleID = {0}", roleId)).ToList();
listA.AddRange(listR);
return(listA);
}
}
public static List <F_TRANSITION> GetJoinTransation(int activityid)
{
using (MainDataContext dbContext = new MainDataContext())
{
return(dbContext.F_TRANSITION.Where(t => t.EndActivityID == activityid).ToList());
}
}
/// <summary>
/// 特殊要求
/// </summary>
public static List <TZSpecialRequest> LoadSpecialRequests()
{
using (MainDataContext dbContext = new MainDataContext(AppConfig.ConnectionStringDispatch))
{
return(dbContext.TZSpecialRequest.Where(p => p.是否有效 == true).OrderBy(p => p.顺序号).ToList());
}
}
/// <summary>
/// 送往地点
/// </summary>
public static List <TZSendAddrType> LoadSendAddrTypes()
{
using (MainDataContext dbContext = new MainDataContext(AppConfig.ConnectionStringDispatch))
{
return(dbContext.TZSendAddrType.Where(p => p.是否有效 == true).OrderBy(p => p.顺序号).ToList());
}
}
/// <summary>
/// 获取受理对象
/// </summary>
public static C_AccInfo GetC_AccInfo(string eventCode, int orderNumber)
{
//查询受理信息
SqlParameterTool sqltac = new SqlParameterTool();
sqltac.commandText.Append(@"SELECT EventCode=事件编码,AcceptOrder=受理序号,TypeId=受理类型编码,DetailReasonId=受理类型子编码,AcceptPersonCode=责任受理人编码,AlarmTel=呼救电话
,HangUpTime=挂起时刻,RingTime=电话振铃时刻,AcceptBeginTime=开始受理时刻,AcceptEndTime=结束受理时刻,CommandTime=发送指令时刻,LocalAddr=现场地址,WaitAddr=等车地址
,SendAddr=送往地点,LocalAddrTypeId=往救地点类型编码,SendAddrTypeId=送往地点类型编码,LinkMan=联系人,LinkTel=联系电话,Extension=分机,PatientName=患者姓名,Sex=性别
,Age=年龄,Folk=民族,[National]=国籍,AlarmReason=主诉,Judge=病种判断,IllStateId=病情编码,IsNeedLitter=是否需要担架,PatientCount=患者人数,SpecialNeed=特殊要求,IsLabeled=是否标注
,X=X坐标,Y=Y坐标,AmbulanceList=派车列表,Remark=备注,AcceptType=TZET.名称,Dispatcher=TP.姓名
FROM TAcceptEvent TAE
left join TZAcceptEventType TZET on TZET.编码 = TAE.受理类型编码
left join TPerson TP on TP.编码 = TAE.责任受理人编码
where 事件编码 = @p0 and 受理序号=@p1");
sqltac.commandObj.Add(eventCode);
sqltac.commandObj.Add(orderNumber);
using (MainDataContext dbContext = new MainDataContext(AppConfig.ConnectionStringDispatch))
{
C_AccInfo tac = dbContext.ExecuteQuery <C_AccInfo>(
sqltac.commandText.ToString()
, sqltac.commandObj.ToArray()).FirstOrDefault();
return(tac);
}
}
/// <summary>
/// 主诉下拉菜单(树)填充
/// </summary>
/// <returns></returns>
public static List <TZAlarmReason> LoadAlarmReasons()
{
using (MainDataContext dbContext = new MainDataContext(AppConfig.ConnectionStringDispatch))
{
return(dbContext.TZAlarmReason.Where(p => p.是否有效 == true).OrderBy(p => p.顺序号).ToList());
}
}
public static object GetTelBackCallsV7(int page, int rows, string order, string sort, string start, string end, string type)
{
using (MainDataContext dbContext = new MainDataContext(AppConfig.ConnectionStringDispatch))
{
StringBuilder strSQL = new StringBuilder();
strSQL.Append(" select ");
strSQL.Append(" 患者姓名=tac.患者姓名, ");
strSQL.Append(" 性别=tac.性别, ");
strSQL.Append(" 年龄=tac.年龄, ");
strSQL.Append(" 出车分站=ts.名称, ");
strSQL.Append(" 现场地址=tac.现场地址, ");
strSQL.Append(" 发送时间=tbcs.发送时间, ");
strSQL.Append(" 主叫电话=tac.呼救电话, ");
strSQL.Append(" 联系人=tac.联系人, ");
strSQL.Append(" 联系电话=tac.联系电话, ");
strSQL.Append(" 受理类型=tzac.名称, ");
strSQL.Append(" 出车结果=case when tt.是否正常结束=1 then '正常结束' else tztar.名称 end, ");
strSQL.Append(" 任务编码=tt.任务编码, ");
strSQL.Append(" 事件详情='查看', ");
strSQL.Append(" 司机=tt.司机,医生=tt.医生,护士=tt.护士,车辆=tab.实际标识,任务号=tt.任务流水号,主诉=tac.主诉,送往地点=tac.送往地点, ");
strSQL.Append(" 回访人=tbc.回访人, ");
strSQL.Append(" 回访时刻=case when tbcs.发送时间 is null then tbc.回访保存时间 else tbcs.发送时间 end, ");
strSQL.Append(" 短信=isnull((select 短信=case when tbcs.任务编码 is null then '未发' else case when tbcs.接收内容 is null then '已发' else tbcs.接收内容 end end from TBackCallSM tbcs where tbcs.任务编码=tt.任务编码 ),'未发'), ");
strSQL.Append(" 回访单=(select 回访单=case when isnull(count(*),0)=0 then '未访' else tbc.是否有效 end from TBackCall where tbc.任务编码=tt.任务编码 ),");
strSQL.Append(" 录音=(select 录音=Convert(varchar(20),isnull(count(*),0))+'个' from TBackCallRecordLink tbcl where tbcl.任务编码=tt.任务编码 ), ");
strSQL.Append(" 编码= tbcs.编码 ");
strSQL.Append(" from dbo.TTask tt ");
strSQL.Append(" left join TAlarmEvent tae on tae.事件编码=tt.事件编码 ");
strSQL.Append(" left join TAcceptEvent tac on tac.事件编码=tt.事件编码 and tt.受理序号=tac.受理序号 ");
strSQL.Append(" left join TStation ts on ts.编码=tt.分站编码 ");
strSQL.Append(" left join TZAcceptEventType tzac on tzac.编码=tac.受理类型编码 ");
strSQL.Append(" left join TZTaskAbendReason tztar on tztar.编码=tt.异常结束原因编码 ");
strSQL.Append(" left join TAmbulance tab on tab.车辆编码=tt.车辆编码 ");
strSQL.Append(" left join TBackCallAudit tbca on tbca.任务编码=tt.任务编码 ");
strSQL.Append(" left join TBackCall tbc on tbc.任务编码=tt.任务编码 ");
strSQL.Append(" left join dbo.TBackCallSM tbcs on tbcs.任务编码=tt.任务编码 ");
strSQL.Append(" where tbcs.发送时间>='" + start + "' and tbcs.发送时间<'" + end + "' and (tae.所属事故编码 is null or tae.所属事故编码='') and tt.是否执行中=0 and tbca.任务编码 is null ");
if (!string.IsNullOrEmpty(type))
{
if (type == "乱码")
{
strSQL.AppendFormat(" and tbcs.接收内容 not in ('满意','不满意','NULL')");
}
else
{
strSQL.AppendFormat(" and tbcs.接收内容='{0}'", type);
}
}
var list1 = dbContext.ExecuteQuery <C_BackCall>(strSQL.ToString());
var list2 = dbContext.ExecuteQuery <C_BackCall>(strSQL.ToString());
long total = list1.LongCount();
list2 = list2.Skip((page - 1) * rows).Take(rows);
return(new { total = total, rows = list2.ToList() });
}
}
public MainViewModel(
[NotNull] MainDataContext dataContext,
[NotNull] ISystemTrayContextMenu trayMenu,
[NotNull] IConsoleArgs consoleArgs,
[NotNull] IWaVersionInfoProvider waVersionInfoProvider,
[NotNull] MainForm mainForm)
{
if (dataContext == null)
{
throw new ArgumentNullException(nameof(dataContext));
}
if (trayMenu == null)
{
throw new ArgumentNullException(nameof(trayMenu));
}
if (consoleArgs == null)
{
throw new ArgumentNullException(nameof(consoleArgs));
}
if (waVersionInfoProvider == null)
{
throw new ArgumentNullException(nameof(waVersionInfoProvider));
}
if (mainForm == null)
{
throw new ArgumentNullException(nameof(mainForm));
}
this.DataContext = dataContext;
this.trayMenu = trayMenu;
this.consoleArgs = consoleArgs;
this.waVersionInfoProvider = waVersionInfoProvider;
this.mainForm = mainForm;
trayMenu.ShowMainWindowClicked += ShowRestore;
trayMenu.ExitWurmAssistantClicked += (sender, eventArgs) => this.TryClose();
savedNonMinimizedWindowState = WindowState.Normal;
if (consoleArgs.WurmUnlimitedMode)
{
WindowTitle = "Aldur's Wurm Assistant Unlimited";
Icon = Resources.WurmAssistantUnlimitedIcon.ToImageSource();
}
else
{
WindowTitle = "Aldur's Wurm Assistant";
Icon = Resources.WurmAssistantIcon.ToImageSource();
}
WindowTitle += string.Format(" ({0})", waVersionInfoProvider.Get());
mainForm.Dock = DockStyle.Fill;
WinFormsContent = new WindowsFormsHost()
{
Child = mainForm,
HorizontalAlignment = HorizontalAlignment.Stretch,
VerticalAlignment = VerticalAlignment.Stretch
};
}
public static IEnumerable <CollectionInfo> GetAllCollectionInfos()
{
using (MainDataContext db = new MainDataContext())
{
var res = db.CollectionInfos.Select(p => p).ToList();
return(res);
}
}
/// <summary>
/// 车辆状态相关信息
/// </summary>
/// <returns></returns>
public static List <TZAmbulanceState> LoadAmbulanceStateInfo()
{
using (MainDataContext dbContext = new MainDataContext(AppConfig.ConnectionStringDispatch))
{
List <TZAmbulanceState> l = dbContext.TZAmbulanceState.Where(t => t.是否有效 == true).OrderBy(t => t.顺序号).ToList();
return(l);
}
}
public static List <TZAmbulanceGroup> LoadAllGroups()
{
using (MainDataContext dbContext = new MainDataContext(AppConfig.ConnectionStringDispatch))
{
var list = dbContext.TZAmbulanceGroup.ToList();
return(list);
}
}
public void lnkSave_Click(object sender, EventArgs e)
{
using (MainDataContext db = new MainDataContext())
{
Save(db, hdnID.Value);
db.Dispose();
}
}
public DataQueryManager(Type _Type, int _viewID)
{
Type = _Type;
ViewID = _viewID;
db = new MainDataContext();
Initialize(Type, ViewID);
}
public static void RecordLinqUpdate(Models.Admin user, object oldObj, object newObj)
{
using (MainDataContext dbo = new MainDataContext())
{
RecordLinqUpdate(dbo, user, oldObj, newObj);
dbo.SubmitChanges();
}
}
public static object DataType()
{
using (MainDataContext dbContext = new MainDataContext())
{
var list = (from g in dbContext.G_DATA select new { Type = g.Type }).Distinct();
return(list.ToList());
}
}
public static int GetQuestionPageCount()
{
using (MainDataContext db = new MainDataContext())
{
SysDict dict = db.SysDicts.FirstOrDefault(p => p.DictName == "QuestionPageCount");
return(dict == null ? 0 : int.Parse(dict.DictValue) - db.QuestionInfos.Count() / 20 - 2);
}
}
public void Dispose(bool disposing)
{
if (AutoDisposeDB && db != null)
{
db.Dispose();
db = null;
}
}
public static CollectionInfo GetCollectionInfoById(string CollectionId)
{
using (MainDataContext db = new MainDataContext())
{
var res = db.CollectionInfos.FirstOrDefault(p => p.CollectionID.ToString() == CollectionId);
db.Dispose();
return(res);
}
}
/// <summary>
/// 获取现场地点类型字典表中的相关数据
/// </summary>
/// <param name="TypeCode">字典表表名</param>
/// <returns>object</returns>
public static object GetMainDictioninary(string TypeCode)
{
using (MainDataContext dbContext = new MainDataContext())
{
var list = (from t in TypeCode
select t).ToList();
return(list);
}
}
public static List <F_FLOW_CONFIG> GetFlowConfig(int flowId, string itemName)
{
using (MainDataContext dbContext = new MainDataContext())
{
string sql = string.Format("select * from F_FLOW_CONFIG where flowid={0} and itemName='{1}'", flowId, itemName);
return(dbContext.ExecuteQuery <F_FLOW_CONFIG>(sql).ToList());
}
}
protected void Page_Load(object sender, EventArgs e)
{
Page.Title = _.GeneratePageTitle(Page.Title, Config.WebsiteName);
using (var dc = new MainDataContext())
{
ctInitDatabase.Visible = !dc.DatabaseExists();
}
}
public static List <int> GetModelIds(int participantId, string type)
{
using (MainDataContext dbContext = new MainDataContext())
{
string sql = string.Format("select id from F_PARTICIPANT_{0} where ParticipantID={1}", type, participantId);
return(dbContext.ExecuteQuery <int>(sql).ToList());
}
}
private void Viewport_Loaded(object sender, RoutedEventArgs e)
{
// Б-же, ну какой же это все-таки костыль, а.
viewportGrid = sender as UIElement;
// А вот контекст реально раньше работал, если присвоить значение полю в конструкторе, но сейчас при
// попытке изменить модель представления все крэшится. BLUH.
mainDataContext = DataContext as MainDataContext;
}
public static int GetAnswerCountByCollectionId(string CollectionId)
{
using (MainDataContext db = new MainDataContext())
{
var res = db.CollectionQuestionAndAnswers.Count(p => p.CollectionID.ToString() == CollectionId);
db.Dispose();
return(res);
}
}
public static List <TStation> LoadAllStations()
{
using (MainDataContext dbContext = new MainDataContext(AppConfig.ConnectionStringDispatch))
{
var list = dbContext.TStation.Where(s => s.是否有效 == true).OrderBy(s => s.顺序号).ToList();
return(list);
}
}
protected void Page_Load(object sender, EventArgs e)
{
Page.Title = _.GeneratePageTitle(Page.Title, Config.WebsiteName);
using (var dc = new MainDataContext())
{
ctInitDatabase.Visible = !dc.DatabaseExists();
}
}
public static bool Delete(IList <string> listId)
{
using (MainDataContext dbContext = new MainDataContext())
{
using (MainDataContext dsContext = new MainDataContext(AppConfig.ConnectionStringDispatch))
{
try
{
//删除Tperson
foreach (string id in listId)
{
int workerId = int.Parse(id);
List <B_WORKER_ROLE> listWorkerRole = dbContext.B_WORKER_ROLE.Where(t => t.WorkerID == workerId && t.TPerson编码 != null && t.TPerson编码 != "").ToList();
foreach (B_WORKER_ROLE workerRole in listWorkerRole)
{
TPerson person = dsContext.TPerson.FirstOrDefault(t => t.编码 == workerRole.TPerson编码);
dsContext.TPerson.DeleteOnSubmit(person);
}
}
dsContext.SubmitChanges();
//删除人员
StringBuilder sb = new StringBuilder();
sb.Append("SET XACT_ABORT ON ");
sb.AppendLine(" BEGIN TRAN ");
foreach (string id in listId)
{
int workerId = int.Parse(id);
//删除人员
sb.AppendFormat(" delete B_WORKER where id={0}", workerId);
//删除人员组织
sb.AppendFormat(" delete B_WORKER_ORGANIZATION where WorkerID={0}", workerId);
//删除人员角色
sb.AppendFormat(" delete B_WORKER_ROLE where WorkerID={0}", workerId);
}
sb.AppendLine(" COMMIT TRAN ");
dbContext.ExecuteCommand(sb.ToString());
return(true);
}
catch (Exception ex)
{
Log4Net.LogError("删除人员", ex.Message);
return(false);
}
}
}
}
public async Task <EmployeeTaskDTO> AddEmployeeTask(EmployeeTaskDTO employeeTaskDTO)
{
int employeeId = int.Parse(HttpContextAccessor.HttpContext.User.Claims.FirstOrDefault(a => a.Type == ClaimTypes.NameIdentifier).Value);
var employeeTask = new EmployeeTask(employeeTaskDTO.TaskTitle, employeeTaskDTO.Description, employeeId, employeeTaskDTO.ProjectId, employeeTaskDTO.StartDate, employeeTaskDTO.ExpectedDate, employeeTaskDTO.TaskStatusId, employeeTaskDTO.EndDate);
MainDataContext.EmployeeTasks.Add(employeeTask);
await MainDataContext.SaveChangesAsync();
return(Mapper.Map <EmployeeTaskDTO>(employeeTask));
}
public static bool ReleaseAccident(string accidentId)
{
using (MainDataContext dbContext = new MainDataContext(AppConfig.ConnectionStringDispatch))
{
var model = dbContext.TAlarmEvent.Single(t => t.事件编码 == accidentId);
model.所属事故编码 = accidentId;
dbContext.SubmitChanges();
return(true);
}
}
public TaiKhoan Get(Guid ID)
{
try
{
MainDataContext context = new MainDataContext(ConnectionString);
var taiKhoan = context.TaiKhoans.SingleOrDefault(p => p.ID == ID);
context.Connection.Close();
return taiKhoan;
}
catch (Exception)
{
return null;
}
}
public bool Add(QLNS.Data.TaiKhoan item)
{
try
{
MainDataContext context = new MainDataContext(ConnectionString);
context.TaiKhoans.InsertOnSubmit(item);
context.SubmitChanges();
context.Connection.Close();
return true;
}
catch (Exception)
{
return false;
}
}
protected void ctInitDatabase_Click(object sender, EventArgs e)
{
using (var dc = new MainDataContext())
{
dc.CreateDatabase();
// 添加权限
dc.UserPermission.InsertOnSubmit(
new UserPermission { Name = "文章和用户", Article = true, User = true });
dc.UserPermission.InsertOnSubmit(
new UserPermission { Name = "文章", Article = true, User = false });
dc.SubmitChanges();
}
// 添加初始用户
var user = new User();
user.Name = "ad";
user.Password = _.ComputeHmac("1", Config.HmacStaticKey);
user.Permission = DB.GetUserPermissions()[0];
DB.SetUser(user);
_.Refresh();
}
public bool Delete(QLNS.Data.TaiKhoan item)
{
try
{
MainDataContext context = new MainDataContext(ConnectionString);
var itemDelete = context.TaiKhoans.SingleOrDefault(p => p.ID == item.ID);
if (itemDelete != null)
{
context.TaiKhoans.DeleteOnSubmit(itemDelete);
}
context.SubmitChanges();
context.Connection.Close();
return true;
}
catch (Exception)
{
return false;
}
}
public List<TaiKhoan> GetAll()
{
try
{
MainDataContext context = new MainDataContext(ConnectionString);
var listReturn = context.TaiKhoans.ToList();
context.Connection.Close();
return listReturn;
}
catch (Exception)
{
return new List<TaiKhoan>();
}
}
public bool Login(string TaiKhoan, string MatKhau, ref string error)
{
try
{
MainDataContext context = new MainDataContext(ConnectionString);
var taiKhoan = context.TaiKhoans.SingleOrDefault(p => p.TenTaiKhoan == TaiKhoan && p.MatKhau == MatKhau.MD5());
if (taiKhoan == null)
{
error = "Tài khoản không tồn tại HOẶC Thông tin đăng nhập không chính xác.";
return false;
}
if (taiKhoan.TrangThai == 0)
{
error = "Tài khoản đã bị khóa.";
return false;
}
taiKhoan.LastLogin = DateTime.Now;
context.SubmitChanges();
context.Connection.Close();
return true;
}
catch (Exception ex)
{
error = ex.Message;
return false;
}
}
public bool Update(QLNS.Data.TaiKhoan item)
{
try
{
MainDataContext context = new MainDataContext(ConnectionString);
var itemUpdate = context.TaiKhoans.SingleOrDefault(p => p.ID == item.ID);
if (itemUpdate != null)
{
itemUpdate.HoTen = item.HoTen;
itemUpdate.MatKhau = item.MatKhau;
itemUpdate.TrangThai = item.TrangThai;
}
context.SubmitChanges();
context.Connection.Close();
return true;
}
catch (Exception)
{
return false;
}
}
