/// <summary>
/// 绩效考核报表--修改
/// </summary>
public object UpdateExamInformation(Module.ExamManager exam, out string mag)
{
mag = string.Empty;
string strSQL = @"Update FY_Performance_ExamineInformation Set FBaseExamine=@FBaseExamine,FCoefficient=@FCoefficient,FBaseResult=@FBaseResult
,FAcAttend=@FAcAttend,FAbsented=@FAbsented,FAmount=@FAmount,FFloatAmount=@FFloatAmount,FRemark=@FRemark Where FID=@FID ";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@FBaseExamine", exam.FBaseExamine),
new SqlParameter("@FCoefficient", exam.FCoefficient),
new SqlParameter("@FBaseResult", exam.FBaseResult),
new SqlParameter("@FAcAttend", exam.FAcAttend),
new SqlParameter("@FAbsented", exam.FAbsented),
new SqlParameter("@FAmount", exam.FAmount),
new SqlParameter("@FFloatAmount", exam.FFloatAmount),
new SqlParameter("@FRemark", exam.FRemark),
new SqlParameter("@FID", exam.FID),
};
object result = null;
try {
result = mSSQL.GetUpdateByText(strSQL, paras);
if (Convert.ToInt32(result) != 1)
{
result = null;
}
}
catch (Exception ex) {
mag = ex.Message;
}
return(result);
}
/// <summary>
/// 绩效考核报表--新增
/// </summary>
public object InsertExamInformation(Module.ExamManager exam, out string mag)
{
mag = string.Empty;
string strSQL = @"Insert Into FY_Performance_ExamineInformation(FCDate,FEmCode,FYear,FMonth,FBaseExamine,FCoefficient,FBaseResult,FAcAttend
,FAbsented,FAmount,FFloatAmount,FRemark,FStatus) Values(@FCDate,@FEmCode,@FYear,@FMonth,@FBaseExamine,@FCoefficient
,@FBaseResult,@FAcAttend,@FAbsented,@FAmount,@FFloatAmount,@FRemark,@FStatus)";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@FCDate", exam.FCDate),
new SqlParameter("@FEmCode", exam.FEmCode),
new SqlParameter("@FYear", exam.FYear),
new SqlParameter("@FMonth", exam.FMonth),
new SqlParameter("@FBaseExamine", exam.FBaseExamine),
new SqlParameter("@FCoefficient", exam.FCoefficient),
new SqlParameter("@FBaseResult", exam.FBaseResult),
new SqlParameter("@FAcAttend", exam.FAcAttend),
new SqlParameter("@FAbsented", exam.FAbsented),
new SqlParameter("@FAmount", exam.FAmount),
new SqlParameter("@FFloatAmount", exam.FFloatAmount),
new SqlParameter("@FRemark", exam.FRemark),
new SqlParameter("@FStatus", exam.FStatus),
};
object result = null;
try {
result = mSSQL.GetUpdateByText(strSQL, paras);
if (Convert.ToInt32(result) != 1)
{
result = null;
}
}
catch (Exception ex) {
mag = ex.Message;
}
return(result);
}
/// <summary>
/// 保存
/// </summary>
protected void btnSave_Click(object sender, EventArgs e)
{
string mag = string.Empty;
int count = 0;
bool isChecked = false;
foreach (GridViewRow row in GridView1.Rows)
{
Control ctl = row.FindControl("chkRow");
CheckBox check = ctl as CheckBox;
if (check.Checked)
{
TextBox txtAcAttend = row.FindControl("txtAcAttend") as TextBox;
TextBox txtAbsented = row.FindControl("txtAbsented") as TextBox;
TextBox txtFAmount = row.FindControl("txtFAmount") as TextBox;
TextBox txtRemark = row.FindControl("txtRemark") as TextBox;
Module.ExamManager exam = new Module.ExamManager {
FCDate = DateTime.Now.Date,
FID = row.Cells[2].Text,
FEmCode = row.Cells[3].Text,
FYear = labYear.Text,
FMonth = labMonth.Text,
FBaseExamine = Convert.ToDouble(row.Cells[6].Text),
FCoefficient = Convert.ToDouble(row.Cells[7].Text),
FBaseResult = Convert.ToDouble(row.Cells[8].Text),
FFloatAmount = Convert.ToDecimal(row.Cells[12].Text),
FStatus = true,
};
exam.FAcAttend = Convert.ToDouble(string.IsNullOrEmpty(txtAcAttend.Text) ? "0" : txtAcAttend.Text);
exam.FAbsented = Convert.ToDouble(string.IsNullOrEmpty(txtAbsented.Text) ? "0" : txtAbsented.Text);
exam.FAmount = Convert.ToDouble(string.IsNullOrEmpty(txtFAmount.Text) ? "0" : txtFAmount.Text);
exam.FRemark = txtRemark.Text;
//**验证是否完成绩效计算**
if (exam.FBaseResult != 0 && exam.FFloatAmount == 0)
{
string saveOk = string.Empty;
if (isChecked)
{
saveOk = $@"已完成【{count}】条记录保存，";
}
mag = @"请先完成【绩效浮动奖金】计算。";
Response.Write($@"<script language=javaScript>alert('{saveOk}编号：【{exam.FEmCode}】数据保存失败，原因： {mag}');</script>");
btnRefresh_Click(null, null);
return;
}
//**新增状态*
if (isNewData)
{
//*插入新记录*
object result = manageAction.InsertExamInformation(exam, out mag);
if (result == null)
{
Response.Write($@"<script language=javaScript>alert('已完成更新{count}条记录，【{exam.FEmCode}】数据新增失败');</script>");
btnRefresh_Click(null, null);
return;
}
else
{
//*更新【考核成绩结果】的单据状态为已审核*
result = null;
result = manageAction.UpdateExamResultApprove(exam.FEmCode, exam.FYear, exam.FMonth, out mag);
if (result == null)
{
Response.Write($@"<script language=javaScript>alert('【绩效结果表】审核状态修改失败，原因： {mag}');</script>");
btnRefresh_Click(null, null);
return;
}
}
count += 1;
isChecked = true;
}
//**修改状态**
if (!isNewData)
{
exam.FID = row.Cells[2].Text;
object result = manageAction.UpdateExamInformation(exam, out mag);
if (result == null)
{
Response.Write($@"<script language=javaScript>alert('{count}条记录更新完成，【{exam.FEmCode}】更新失败。');</script>");
btnRefresh_Click(null, null);
return;
}
count += 1;
isChecked = true;
}
}
}
if (!isChecked)
{
mag = $"请先选择要保存的行。";
Response.Write($@"<script language=javaScript>alert('{mag}');</script>");
return;
}
else
{
mag = $"数据更新成功，共更新【{count.ToString()}】条数据。";
Response.Write($@"<script language=javaScript>alert('{mag}');</script>");
btnRefresh_Click(null, null);
btnSave.Enabled = false;
}
}