public bool CheckSummaryAndPlan(SummaryAndPlan sp)
{
string c = "";
string select = string.Format("select count(*) as count from SummaryAndPlan where WriteDate = '{0}' and Writer = '{1}' ", sp.WriteDate, sp.Writer);
DataTable dt = MySqlHelper.mySqlExecuteQuery(select.ToString(), null, false);
if (dt.Rows.Count > 0)
{
c = dt.Rows[0]["count"].ToString();
}
if (int.Parse(c) > 0)
{
StringBuilder update = new StringBuilder();
update.AppendFormat("update SummaryAndPlan set CheckFlag = '{0}', CheckOpinion = '{1}', Checker = '{2}' ", sp.CheckFlag, sp.CheckOpinion, sp.Checker);
update.AppendFormat(" where WriteDate = '{0}' and Writer = '{1}' ", sp.WriteDate, sp.Writer);
int i = MySqlHelper.mySqlExecuteNonQuery(update.ToString(), null, false);
return(i > 0);
}
else
{
StringBuilder insert = new StringBuilder();
insert.AppendFormat("insert into SummaryAndPlan (CheckFlag,CheckOpinion,Checker,WriteDate,Writer) values ('{0}','{1}','{2}','{3}','{4}')", sp.CheckFlag, sp.CheckOpinion, sp.Checker, sp.WriteDate, sp.Writer);
//insert.AppendFormat(" where NoteDate = '{0}' and Name = '{1}' ", weeklynote.NoteDate, weeklynote.Name);
int i = MySqlHelper.mySqlExecuteNonQuery(insert.ToString(), null, false);
return(i > 0);
}
}
public bool SaveSummary(SummaryAndPlan summaryAndPlan)
{
string Id = string.Empty;
StringBuilder select = new StringBuilder();
select.AppendFormat("select * from SummaryAndPlan where Writer = '{0}' and WriteDate = '{1}'", summaryAndPlan.Writer, summaryAndPlan.WriteDate);
DataTable dt = MySqlHelper.mySqlExecuteQuery(select.ToString(), null, false);
if (dt.Rows.Count > 0)
{
Id = dt.Rows[0]["ID"].ToString();
}
if (Id.Length > 0)
{
StringBuilder delete = new StringBuilder();
delete.AppendFormat("delete from SummaryAndPlan where Id = '{0}'", Id);
int j = MySqlHelper.mySqlExecuteNonQuery(delete.ToString(), null, false);
}
StringBuilder insert = new StringBuilder();
insert.Append("insert into SummaryAndPlan (Writer,Summary,Plan,WriteDate)");
insert.AppendFormat(" values ('{0}','{1}','{2}','{3}')", summaryAndPlan.Writer, summaryAndPlan.Summary, summaryAndPlan.Plan, summaryAndPlan.WriteDate);
int i = MySqlHelper.mySqlExecuteNonQuery(insert.ToString(), null, false);
return(i > 0);
}
public SummaryAndPlan getSummaryAndPlanInfo(NameValueCollection paras)
{
SummaryAndPlan sp = new SummaryAndPlan();
sp.Summary = paras["summary"].Trim();
sp.Plan = paras["plan"].Trim();
sp.WriteDate = paras["date"].Trim();
sp.Writer = paras["name"].Trim();
return(sp);
}
public SummaryAndPlan GetSummaryAndPlan(string UserName, string DateSelect = "")
{
DateTime Day;
if (string.IsNullOrEmpty(DateSelect))
{
Day = DateTime.Today;
}
else
{
Day = DateTime.Parse(DateSelect);
}
if (!string.IsNullOrEmpty(userName))
{
UserName = userName;
}
//获取本周第一天
int Weeknow = Convert.ToInt32(Day.DayOfWeek);
//因为是以星期一为第一天，所以要判断weeknow等于0时，要向前推6天。
Weeknow = (Weeknow == 0 ? (7 - 1) : (Weeknow - 1));
int Daydiff = (-1) * Weeknow;
//本周第一天
string FirstDay = Day.AddDays(Daydiff).ToString("yyyy-MM-dd");
FD = FirstDay;
//获取本周最后一天
int Weeknow1 = Convert.ToInt32(Day.DayOfWeek);
Weeknow1 = (Weeknow1 == 0 ? 7 : Weeknow1);
Daydiff = (7 - Weeknow1);
//本周最后一天
string LastDay = Day.AddDays(Daydiff).ToString("yyyy-MM-dd");
List <SummaryAndPlan> sp = new List <SummaryAndPlan>();
DataTable dt2 = new DataTable();
StringBuilder select2 = new StringBuilder();
select2.AppendFormat("select * from summaryandplan where writedate = '{0}' and writer = '{1}'", FirstDay, UserName);
dt2 = MySqlHelper.mySqlExecuteQuery(select2.ToString(), null, false);
sp = (from y in dt2.AsEnumerable()
select new SummaryAndPlan
{
Plan = y.Field <string>("Plan"),
Summary = y.Field <string>("summary")
}).ToList <SummaryAndPlan>();
if (sp.FirstOrDefault() != null)
{
return(sp.FirstOrDefault());
}
else
{
SummaryAndPlan sp2 = new SummaryAndPlan();
return(sp2);
}
}
public int SaveSummaryAndPlan([FromBody] SummaryAndPlan value)
{
SaveEntity se = new SaveEntity();
if (se.SaveSummary(value))
{
return(1);
}
else
{
return(0);
}
}
