public string DeleteOnDuty(string id, string userid) { var tran = Utility.Database.BeginDbTransaction(); try { B_OA_OnDuty onDuty = new B_OA_OnDuty(); onDuty.Condition.Add("id=" + id); Utility.Database.Delete<B_OA_OnDuty>(onDuty, 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 GetOnDutyData(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 = ""; GetOnDutyDataModel data = new GetOnDutyDataModel();//获取数据模型 tran = Utility.Database.BeginDbTransaction(); string sql = "select id,workPlanName,userid,userName,department,deptName,remark,convert(varchar(30),startTime,120) as startTime,convert(varchar(30),endTime,120) as endTime from B_OA_OnDuty 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_OnDuty workPlan = new B_OA_OnDuty(); workPlan.startTime = DateTime.Now.ToString(); workPlan.department = user.DPID; data.baseInfo = workPlan; 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(); } }