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