private void btnAdd_Click(object sender, EventArgs e)
{
if (RtbGBInfo.Text != null)
{
DialogResult dr = MessageBox.Show("确定录入？一旦录入后将无法修改及删除，或会影响员工的晋升！", "录入警告", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.Yes)
{
WorkerGoodBad goodBad = new WorkerGoodBad();
goodBad.WorkNo = lblWorkerNo.Text;
goodBad.GBType = CboType.SelectedIndex;
goodBad.GBInfo = RtbGBInfo.Text;
goodBad.GBOperation = AdminInfo.Account;
goodBad.GBTime = DtpDate.Value;
bool n = new WorkerGoodBadService().AddGoodBad(goodBad);
if (n == true)
{
MessageBox.Show("新增成功！");
#region 获取添加操作日志所需的信息
OperationLog o = new OperationLog();
o.OperationTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd,HH:mm:ss"));
o.Operationlog = AdminInfo.Account + AdminInfo.Name + "于" + DateTime.Now + "对员工：" + lblName.Text + "进行了奖罚情况录入！";
o.OperationAccount = LoginInfo.WorkerNo;
o.datains_usr = LoginInfo.WorkerNo;
o.datains_date = DateTime.Now;
new OperationlogService().InsertOperationLog(o);
#endregion
DgvGoodBadList.DataSource = new WorkerGoodBadService().SelectAllGoodBadByWorkNo(lblWorkerNo.Text);
}
else
{
MessageBox.Show("或是服务器错误所致！");
}
}
else
{
MessageBox.Show("取消录入操作！");
}
}
else
{
MessageBox.Show("信息不能为空！");
}
}
public static List <WorkerGoodBad> SelectAllGoodBadByWorkNo(string wn)
{
List <WorkerGoodBad> gb = new List <WorkerGoodBad>();
string sql = "select * from WorkerGoodBad wgb,GBType gbt where wgb.GBType = gbt.GBType and wgb.WorkNo = '" + wn + "'";
MySqlConnection conn = DBHelper.GetConnection();
conn.Open();
MySqlDataReader dr = DBHelper.ExecuteReader(sql);
while (dr.Read())
{
WorkerGoodBad goodBad = new WorkerGoodBad();
goodBad.WorkNo = dr["WorkNo"].ToString();
goodBad.GBInfo = dr["GBInfo"].ToString();
goodBad.TypeName = dr["GBName"].ToString();
goodBad.GBOperation = dr["GBOperation"].ToString();
goodBad.GBTime = (DateTime)dr["GBTime"];
gb.Add(goodBad);
}
dr.Close();
DBHelper.Closecon();
return(gb);
}
public static int AddGoodBad(WorkerGoodBad goodBad)
{
return(WorkerGoodBadService.AddGoodBad(goodBad));
}
public static int AddGoodBad(WorkerGoodBad goodBad)
{
string sql = "insert into WorkerGoodBad values('" + goodBad.WorkNo + "','" + goodBad.GBInfo + "','" + goodBad.GBType + "','" + goodBad.GBOperation + "','" + goodBad.GBTime + "')";
return(DBHelper.ExecuteNonQuery(sql));
}
public bool AddGoodBad([FromBody] WorkerGoodBad goodBad)
{
return(new WorkerGoodBadService().AddGoodBad(goodBad));
}
