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