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();
}
}
