public static int AddTask(SqlConnection con, SqlTransaction sqt, ref TTaskInfo ti) { string sql = String.Empty; Int32 TaskID = 0; try { sql = "insert into tTaskHead(CarID,BeginDate,OprtUserCode) values (@CarID,@BeginDate,@OprtUserCode)"; SqlParameter[] pms = new SqlParameter[] { new SqlParameter("@CarID", ti.CarID), new SqlParameter("@BeginDate", ti.BeginDate), new SqlParameter("@OprtUserCode", ti.OprtUserCode) }; if (MsSqlHelper.ExecSqlUControl(con, sqt, sql, pms) == 1) { TaskID = Convert.ToInt32(MsSqlHelper.GetSingle(con, sqt, "select max(TaskID) as TaskID from tTaskHead where OprtUserCode=@OprtUserCode", new SqlParameter("@OprtUserCode", ti.OprtUserCode))); ti.TaskID = TaskID; foreach (var taskItem in ti.ListItems) { taskItem.TaskID = TaskID; TTaskItemDAL.AddTaskItem(con, sqt, taskItem); } return(1); } else { return(0); } } catch (Exception e) { LogHelper.WriteLog("TTaskInfoDAL.AddTask 1", e); throw e; } }
public static int AddTask(ref TTaskInfo ti, ref TCarInfo ci) { SqlConnection con = new SqlConnection(MsSqlHelper.connectionString); con.Open(); SqlTransaction st = con.BeginTransaction(); try { if (TCarInfoDAL.AddCarInfo(con, st, ref ci) == 1) { ti.CarID = ci.CarID; if (TTaskInfoDAL.AddTask(con, st, ref ti) == 1) { st.Commit(); return(1); } else { throw new Exception("添加任务信息出错"); } } else { throw new Exception("添加车辆信息出错"); } } catch (Exception e) { LogHelper.WriteLog("TTaskInfoDAL.AddTask 2", e); st.Rollback(); con.Close(); con.Dispose(); return(0); } }
/// <summary> /// Create a new instance. /// </summary> /// <param name="taskInfo">Task information including an ID that uniquely identifies the task.</param> /// <param name="cancellation">The Cancellation token that can be used to cancel the work.</param> /// <param name="disposableCancellation">A value that indicates whether the cancel token can be disposed after the task is completed.</param> internal TaskContext(TTaskInfo taskInfo, CancellationTokenSource?cancellation, bool disposableCancellation) { TaskInfo = taskInfo; Cancellation = cancellation; DisposableCancellation = disposableCancellation; }
public static int AddTask(string carNo, string MaintainTypes, string technicians, string carName, string carOwner, string carOwnerTel1, string carOwnerTel2, string carTrevalDistance, string OprtUserCode ) { try { DateTime dt = DateTime.Now; TCarInfo tCi = new TCarInfo(); tCi.CarID = 0; tCi.CarNumber = carNo; tCi.CarName = carName; tCi.CarOwner = carOwner; tCi.CarOwnerTel1 = carOwnerTel1; tCi.CarOwnerTel2 = carOwnerTel2; if (carTrevalDistance != null && carTrevalDistance != String.Empty) { tCi.CarTrevalDistance = int.Parse(carTrevalDistance); } tCi.CarComeTime = dt; tCi.OprtUserCode = OprtUserCode; TTaskInfo tTi = new TTaskInfo(); tTi.TaskID = 0; tTi.CarID = 0; tTi.BeginDate = dt; tTi.OprtUserCode = OprtUserCode; tTi.ListItems = new List <TTaskItem>(); if (MaintainTypes != String.Empty) { String[] mtTypes = MaintainTypes.Split(','); for (int i = 0; i < mtTypes.Length; i++) { //分配维修师傅 List <TTaskItemWorkers> listTw = new List <TTaskItemWorkers>(); if (technicians != String.Empty) { //获取可进行该维修类别的所有维修师傅ID列表 List <int> listmt = TUserInfoBLL.UGetMaintainUsers(int.Parse(mtTypes[i])); String[] tns = technicians.Split(','); foreach (var item in tns) { //判断循环中当前维修师傅,是否在上面的列表中 if (listmt.Contains(int.Parse(item))) { listTw.Add(new TTaskItemWorkers() { TaskID = 0, TaskItemID = 0, UID = int.Parse(item) }); } } } tTi.ListItems.Add(new TTaskItem() { TaskID = 0, MID = int.Parse(mtTypes[i]), TaskItemID = i, BeginTime = dt, ListWorks = listTw } ); } } return(TTaskInfoBLL.AddTask(ref tTi, ref tCi)); } catch (Exception e) { LogHelper.WriteLog("AddTask", e); return(0); } }
public static int AddTask(ref TTaskInfo ti, ref TCarInfo ci) { return(TTaskInfoDAL.AddTask(ref ti, ref ci)); }