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