public string DeletePlan(string id,string userid) { var tran = Utility.Database.BeginDbTransaction(); try { B_OA_WorkPlan workPlan = new B_OA_WorkPlan(); workPlan.Condition.Add("id=" + id); Utility.Database.Delete<B_OA_WorkPlan>(workPlan, tran); B_OA_TaskMain taskMain = new B_OA_TaskMain(); taskMain.Condition.Add("workPlanId=" + id); Utility.Database.Delete<B_OA_TaskMain>(taskMain, tran); Utility.Database.Commit(tran); return Utility.JsonResult(true, "删除数据成功");//将对象转为json字符串并返回到客户端 } catch (Exception e) { Utility.Database.Rollback(tran); return Utility.JsonResult(false, "删除数据失败!异常信息: " + e.Message);//将对象转为json字符串并返回到客户端 } }
public string GetTaskData(string startTime, string endTime, string userid) { IDbTransaction tran = null; DataSet dataSet = null; try { var user = ComClass.GetUserInfo(userid); string DPID = user.DPID;//获取部站ID if (startTime == null) startTime = ""; if (endTime == null) endTime = ""; GetDataModel data = new GetDataModel();//获取数据模型 tran = Utility.Database.BeginDbTransaction(); string sql = "select TaskId,workPlanId,TaskName,userid,userName,department,deptName,WorkContent,remark,isWc,isFq,convert(varchar(30),startTime,120) as startTime,convert(varchar(30),endTime,120) as endTime from B_OA_TaskMain where department='{0}' "; if (startTime == "" && endTime == "") sql += " and convert(varchar(30),startTime,120)>(GETDATE()-90) "; if (startTime != null && startTime != "") sql += " and convert(varchar(30),startTime,120)>='" + startTime + "'"; if (endTime != null && endTime != "") sql += " and convert(varchar(30),endTime,120)<='" + endTime + "'"; dataSet = Utility.Database.ExcuteDataSet(string.Format(sql, DPID), tran); Utility.Database.Commit(tran);//提交事务 data.Table = dataSet.Tables[0]; B_OA_TaskMain taskMain = new B_OA_TaskMain(); taskMain.department = user.DPID; data.taskMain = taskMain; return Utility.JsonResult(true, null, data);//将对象转为json字符串并返回到客户端 } catch (Exception ex) { Utility.Database.Rollback(tran); ComBase.Logger(ex);//写异常日志到本地文件夹 return Utility.JsonResult(false, ex.Message);//将对象转为json字符串并返回到客户端 } finally { dataSet.Dispose(); } }
public string SaveData(string JsonData, string userName, string userid) { var tran = Utility.Database.BeginDbTransaction(); try { B_OA_WorkPlan workPlan = JsonConvert.DeserializeObject<B_OA_WorkPlan>(JsonData); if (workPlan.userid == null || workPlan.userid == "") workPlan.userid = userid; B_OA_TaskMain taskMain = new B_OA_TaskMain(); taskMain.workPlanId = workPlan.id; taskMain.TaskName = workPlan.workPlanName; taskMain.userid = workPlan.userid; taskMain.userName = workPlan.userName; taskMain.startTime = workPlan.startTime; taskMain.endTime = workPlan.endTime; taskMain.department = workPlan.department; taskMain.deptName = workPlan.deptName; taskMain.WorkContent = workPlan.remark; taskMain.isWc = "0"; taskMain.isFq = "0"; //更新或插入主业务信息 if (workPlan.id == 0) { Utility.Database.Insert<B_OA_WorkPlan>(workPlan, tran); DataSet set=Utility.Database.ExcuteDataSet("select @@identity", tran); Utility.Database.Commit(tran); taskMain.workPlanId = int.Parse(set.Tables[0].Rows[0][0].ToString()); Utility.Database.Insert<B_OA_TaskMain>(taskMain); if (set != null) set.Dispose(); } else { B_OA_TaskMain en = new B_OA_TaskMain(); en.Condition.Add("workPlanId = " + workPlan.id); en = Utility.Database.QueryObject<B_OA_TaskMain>(en); if (en.isFq == "1") { Utility.Database.Rollback(tran); return Utility.JsonResult(false, "工作已分配,不能修改"); } else { workPlan.Condition.Add("id=" + workPlan.id); Utility.Database.Update<B_OA_WorkPlan>(workPlan, tran); taskMain.Condition.Add("workPlanId=" + workPlan.id); Utility.Database.Update<B_OA_TaskMain>(taskMain, tran); Utility.Database.Commit(tran); } } return Utility.JsonResult(true, "保存数据成功");//将对象转为json字符串并返回到客户端 } catch (Exception e) { Utility.Database.Rollback(tran); return Utility.JsonResult(false, "保存数据失败!异常信息: " + e.Message);//将对象转为json字符串并返回到客户端 } }
public string DeleteTaskMain(string id,string workPlanId, string userid) { var tran = Utility.Database.BeginDbTransaction(); DataSet se = null; try { string sql = "select id from B_OA_TaskList where taskid={0} and iswc='1'"; se = Utility.Database.ExcuteDataSet(string.Format(sql, id), tran); if (se != null && se.Tables[0] != null) { if (se.Tables[0].Rows.Count > 0) { Utility.Database.Rollback(tran); return Utility.JsonResult(false, "该工作任务已有部份完成,不能删除");//将对象转为json字符串并返回到客户端 } } B_OA_WorkPlan workPlan = new B_OA_WorkPlan(); workPlan.Condition.Add("id=" + workPlanId); Utility.Database.Delete<B_OA_WorkPlan>(workPlan, tran); B_OA_TaskMain taskMain = new B_OA_TaskMain(); taskMain.Condition.Add("workPlanId=" + workPlanId); Utility.Database.Delete<B_OA_TaskMain>(taskMain, tran); B_OA_TaskList taskList = new B_OA_TaskList(); taskList.Condition.Add("TaskId=" + id); Utility.Database.Delete<B_OA_TaskList>(taskList, tran); Utility.Database.Commit(tran); return Utility.JsonResult(true, "删除数据成功");//将对象转为json字符串并返回到客户端 } catch (Exception e) { Utility.Database.Rollback(tran); return Utility.JsonResult(false, "删除数据失败!异常信息: " + e.Message);//将对象转为json字符串并返回到客户端 } finally { if (se != null) se.Dispose(); } }