private string List() { string sql = "select * from WorkDiary order by addtime desc;select count(id) from WorkDiary"; DataSet ds = DataFactory.SqlHelper.ExecuteDataset(DataBll.conString.constr, System.Data.CommandType.Text, sql); System.Data.DataTable dt = ds.Tables[0]; int rows = Convert.ToInt32(Convert.IsDBNull(ds.Tables[1].Rows[0][0]) ? 0 : ds.Tables[1].Rows[0][0]); //获得总数 List<WorkDiary> wdList = new List<WorkDiary>(); for (int i = 0; i < dt.Rows.Count; i++) { WorkDiary wd = new WorkDiary(); wd.Projectid = Convert.ToInt32(dt.Rows[i]["Projectid"] ?? 0); wd.DiaryContent = Convert.IsDBNull(dt.Rows[i]["DiaryContent"]) ? "" : dt.Rows[i]["DiaryContent"].ToString(); wd.RecordTime = DateTime.Parse(Convert.IsDBNull(dt.Rows[i]["RecordTime"]) ? "" : dt.Rows[i]["RecordTime"].ToString()); wd.TimeSpent = Convert.ToDecimal(dt.Rows[i]["TimeSpent"] ?? 0); wd.Person = Convert.IsDBNull(dt.Rows[i]["Person"]) ? "" : dt.Rows[i]["Person"].ToString(); wdList.Add(wd); } string output = JsonConvert.SerializeObject(wdList); string json = @"{""Rows"":" + output + @",""Total"":""" + rows + @"""}"; return json; }
public string _UpdateDiary(string jsonData) { // String s = (new System.IO.StreamReader(HttpContext.Current.Request.InputStream)).ReadToEnd(); WorkDiary ob = new WorkDiary(); List<WorkDiary> we = JsonConvert.DeserializeObject(jsonData, typeof(List<WorkDiary>)) as List<WorkDiary>; string Flag = "success"; foreach (WorkDiary wd in we) { //wd.Addtime = DateTime.Now; wd.Person = CommonLib.UserInfo["userName"]; wd.PersonID = int.Parse(CommonLib.UserInfo["roleID"]); bool SuccessFlag = wd.Update(); if (!SuccessFlag) { Flag = "error"; } } return Flag; }
public string _ImportDiary(string jsonData) { Maintain we = JsonConvert.DeserializeObject(jsonData, typeof(Maintain)) as Maintain; // List<Maintain> we = JsonConvert.DeserializeObject(jsonData, typeof(List<Maintain>)) as List<Maintain>; string Flag = "success"; WorkDiary wdSingle = new WorkDiary(); wdSingle.Addtime = DateTime.Now; wdSingle.DiaryContent = "[" + we.CustName + "]" + we.MaintainContent; wdSingle.RecordTime = we.CZDate; wdSingle.Person = we.Czy; //wdSingle.PersonID = int.Parse(Session["id"].ToString()); wdSingle.Projectid = 302; wdSingle.TimeSpent = 8; int result = wdSingle.Add(); if (result <= 0) { Flag = "error"; } return Flag; }
public string _List(string projectID) { //string url= HttpContext.Current.Request.Url.AbsolutePath; string name = CommonLib.UserInfo["userName"]; string rid = CommonLib.UserInfo["roleID"]; string uid = CommonLib.UserInfo["uid"]; if (name == null) { return null; } string sql = string.Empty; if (projectID == "Diary") { sql = "SELECT [id],a.[Projectid],DiaryContent,b.ProjectName,[TimeSpent],[PersonID],[Person],[RecordTime],[Addtime],[state],[eg1],[eg2],[eg3],[eg4],[eg5] FROM [WorkDiary] a left join FBProject b on a.eg1=b.ProjectID where person='" + name + "' order by RecordTime desc;select count(id) from WorkDiary"; } else if (string.IsNullOrEmpty(projectID)) { if (rid == "7") //领导 { sql = "SELECT [id],a.[Projectid],DiaryContent,b.ProjectName,[TimeSpent],[PersonID],[Person],[RecordTime],[Addtime],[state],[eg1],[eg2],[eg3],[eg4],[eg5] FROM [WorkDiary] a left join FBProject b on a.eg1=b.ProjectID order by RecordTime desc;select count(id) from WorkDiary"; } else if (rid == "13") //实施经理 { sql = "SELECT a.[id],a.[Projectid],DiaryContent,b.ProjectName,[TimeSpent],[PersonID],[Person],[RecordTime],[Addtime],[state],[eg1],[eg2],[eg3],[eg4],[eg5] FROM [WorkDiary] a left join FBProject b on a.eg1=b.ProjectID inner join custom_user c on a.Person=c.username where a.Person=c.username and c.rid=10 order by RecordTime desc;select count(id) from WorkDiary"; } else sql = "SELECT [id],a.[Projectid],DiaryContent,b.ProjectName,[TimeSpent],[PersonID],[Person],[RecordTime],[Addtime],[state],[eg1],[eg2],[eg3],[eg4],[eg5] FROM [WorkDiary] a left join FBProject b on a.eg1=b.ProjectID where person='" + name + "' order by RecordTime desc;select count(id) from WorkDiary"; } else { if (rid == "7") //领导 { sql = "SELECT [id],a.[Projectid],DiaryContent,b.ProjectName,[TimeSpent],[PersonID],[Person],[RecordTime],[Addtime],[state],[eg1],[eg2],[eg3],[eg4],[eg5] FROM [WorkDiary] a left join FBProject b on a.eg1=b.ProjectID where eg1='" + projectID + "' order by RecordTime desc;select count(id) from WorkDiary"; } else if (rid == "13") //实施经理 { sql = "SELECT a.[id],a.[Projectid],DiaryContent,b.ProjectName,[TimeSpent],[PersonID],[Person],[RecordTime],[Addtime],[state],[eg1],[eg2],[eg3],[eg4],[eg5] FROM [WorkDiary] a left join FBProject b on a.eg1=b.ProjectID inner join custom_user c on a.Person=c.username where a.Person=c.username and c.rid=10 and eg1='" + projectID + "' order by RecordTime desc;select count(id) from WorkDiary"; } else sql = "SELECT [id],a.[Projectid],DiaryContent,b.ProjectName,[TimeSpent],[PersonID],[Person],[RecordTime],[Addtime],[state],[eg1],[eg2],[eg3],[eg4],[eg5] FROM [WorkDiary] a left join FBProject b on a.eg1=b.ProjectID where eg1='" + projectID + "' and person='" + name + "' order by RecordTime desc;select count(id) from WorkDiary where eg1='" + projectID + "'"; } DataSet ds = DataFactory.SqlHelper.ExecuteDataset(DataBll.conString.constr, System.Data.CommandType.Text, sql); System.Data.DataTable dt = ds.Tables[0]; int rows = Convert.ToInt32(Convert.IsDBNull(ds.Tables[1].Rows[0][0]) ? 0 : ds.Tables[1].Rows[0][0]); //获得总数 List<WorkDiary> wdList = new List<WorkDiary>(); for (int i = 0; i < dt.Rows.Count; i++) { WorkDiary wd = new WorkDiary(); wd.Projectid = Convert.ToInt32(dt.Rows[i]["Projectid"] ?? 0); wd.DiaryContent = Convert.IsDBNull(dt.Rows[i]["DiaryContent"]) ? "" : dt.Rows[i]["DiaryContent"].ToString(); wd.RecordTime = DateTime.Parse(Convert.IsDBNull(dt.Rows[i]["RecordTime"]) ? "" : dt.Rows[i]["RecordTime"].ToString()); wd.TimeSpent = Convert.ToDecimal(dt.Rows[i]["TimeSpent"] ?? 0); wd.Person = Convert.IsDBNull(dt.Rows[i]["Person"]) ? "" : dt.Rows[i]["Person"].ToString(); wd.id = Convert.ToInt32(dt.Rows[i]["id"] ?? 0); wd.eg1 = Convert.IsDBNull(dt.Rows[i]["eg1"]) ? "" : dt.Rows[i]["eg1"].ToString(); wd.eg5 = Convert.IsDBNull(dt.Rows[i]["ProjectName"]) ? "" : dt.Rows[i]["ProjectName"].ToString(); wdList.Add(wd); } string output = JsonConvert.SerializeObject(wdList); string json = @"{""Rows"":" + output + @",""Total"":""" + rows + @"""}"; return json; }
public bool _DelDiary(string jsonData) { WorkDiary ob = new WorkDiary(); List<WorkDiary> we = JsonConvert.DeserializeObject(jsonData, typeof(List<WorkDiary>)) as List<WorkDiary>; string Flag = "success"; foreach (WorkDiary item in we) { bool SuccessFlag=ob.Delete(item.id); if (!SuccessFlag) { Flag = "error"; } } return Flag == "success" ? true : false; }