public void AddWorkLogs(WorkLogsModel tables) { try { UDal.AddWorkLogs(tables); } catch (Exception ex) { throw new Exception(ex.Message); } }
public void AddWorkLogs(WorkLogsModel tables) { tables.UserId = GetUser().Id; tables.UserName = GetUser().Name; try { USer.AddWorkLogs(tables); } catch (Exception ex) { throw new Exception(ex.Message); } }
public int Delete(WorkLogsModel workLog) { //构造sql语句及参数 string sql = "Delete From Works WHERE ID=@ID"; SqlParameter[] ps = { new SqlParameter("@ID", workLog.ID) }; //执行并返回 return(MSSqlHelper.ExecuteNonQuery(sql, ps)); }
//操作日志 public void AddWorkLogs(WorkLogsModel tables) { using (var db = new HTJKEntities()) { var WorkLogs = new WorkLogs(); WorkLogs.UserId = tables.UserId; WorkLogs.UserName = tables.UserName; WorkLogs.MSG = tables.MSG; WorkLogs.MSGStatus = tables.MSGStatus; WorkLogs.CreateTime = DateTime.Now; db.WorkLogs.Add(WorkLogs); db.SaveChanges(); } }
private void dgvlist_RowEditEnding(object sender, DataGridRowEditEndingEventArgs e) { //dgvlist.ItemsSource = new BindingCollection<WorkLogsModel>(); WorkLogsModel logs = new WorkLogsModel() { ID = (e.Row.Item as WorkLogsModel).ID, DateTime = (e.Row.Item as WorkLogsModel).DateTime, Name = (e.Row.Item as WorkLogsModel).Name, ProductName = (e.Row.Item as WorkLogsModel).ProductName, Version = (e.Row.Item as WorkLogsModel).Version, Stage = (e.Row.Item as WorkLogsModel).Stage, Type = (e.Row.Item as WorkLogsModel).Type, Task = (e.Row.Item as WorkLogsModel).Task, Progress = (e.Row.Item as WorkLogsModel).Progress, Whours = Convert.ToInt32((e.Row.Item as WorkLogsModel).Whours), TProgress = (e.Row.Item as WorkLogsModel).TProgress, Workout = (e.Row.Item as WorkLogsModel).Workout, Problem = (e.Row.Item as WorkLogsModel).Problem, }; if (Convert.ToString((e.Row.Item as WorkLogsModel).ID) == "0") { if (_workLogsBll.Add(logs)) { LoadList(); } else { MessageBox.Show("新增失败"); } } else { if (_workLogsBll.Edit(logs)) { LoadList(); } else { MessageBox.Show("修改失败"); } } }
/// <summary> /// 修改数据 /// </summary> /// <param name="workLog"></param> /// <returns></returns> public int Updata(WorkLogsModel workLog) { //构造sql语句及参数 string sql = "UPDATE Works SET DateTime= @DateTime, Name=@Name, ProductName=@ProductName, Version=@Version, Stage=@Stage, Type=@Type, Progress=@Progress, Whours=@Whours, TProgress=@TProgress, Workout=@Workout, Problem=@Problem WHERE ID=@ID"; SqlParameter[] ps = { new SqlParameter("@ID", workLog.ID), new SqlParameter("@DateTime", workLog.DateTime), new SqlParameter("@Name", workLog.Name), new SqlParameter("@ProductName", workLog.ProductName), new SqlParameter("@Version", workLog.Version), new SqlParameter("@Stage", workLog.Stage), new SqlParameter("@Type", workLog.Type), new SqlParameter("@Task", workLog.Task), new SqlParameter("@Progress", workLog.Progress), new SqlParameter("@Whours", workLog.Whours), new SqlParameter("@TProgress", workLog.TProgress), new SqlParameter("@Workout", workLog.Workout), new SqlParameter("@Problem", workLog.Problem) }; //执行并返回 return(MSSqlHelper.ExecuteNonQuery(sql, ps)); }
public int Insert(WorkLogsModel workLog) { //构造insert语句 string sql = "INSERT INTO Works (DateTime, Name, ProductName, Version, Stage, Type, Task, Progress, Whours, TProgress, Workout, Problem) VALUES(@DateTime, @Name, @ProductName, @Version, @Stage, @Type, @Task, @Progress, @Whours, @TProgress, @Workout, @Problem)"; //构造sql语句的参数 SqlParameter[] ps = //使用数组初始化器 { new SqlParameter("@DateTime", workLog.DateTime), new SqlParameter("@Name", workLog.Name), new SqlParameter("@ProductName", workLog.ProductName), new SqlParameter("@Version", workLog.Version), new SqlParameter("@Stage", workLog.Stage), new SqlParameter("@Type", workLog.Type), new SqlParameter("@Task", workLog.Task), new SqlParameter("@Progress", workLog.Progress), new SqlParameter("@Whours", workLog.Whours), new SqlParameter("@TProgress", workLog.TProgress), new SqlParameter("@Workout", workLog.Workout), new SqlParameter("@Problem", workLog.Problem) }; //执行插入操作 return(MSSqlHelper.ExecuteNonQuery(sql, ps)); }
public bool Del(WorkLogsModel workLog) { return(_dal.Delete(workLog) > 0); }
public bool Edit(WorkLogsModel workLog) { return(_dal.Updata(workLog) > 0); }
public bool Add(WorkLogsModel workLog) { return(_dal.Insert(workLog) > 0); }