Example #1
0
        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字符串并返回到客户端
            }
        }
Example #2
0
 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();
     }
 }