private void BtnRepealCost_Click(object sender, EventArgs e)
{
if (DgvCostApply.SelectedRows.Count != 1)
{
MessageBox.Show("请仅选择一个费用单进行撤销！", "信息意识", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
int costId = (int)DgvCostApply.SelectedRows[0].Cells["cost_id"].Value;
List <cost> costList = new CostApplyBLL().Query(new Dictionary <string, object> {
{ "id", costId }
});
if (costList.Count != 0)
{
if (costList[0].Main.status != 0)
{
MessageBox.Show("该费用单已审核，不可撤销", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
DialogResult dialogResult = MessageBox.Show("您确定要撤销费用单" + costId + "吗？", "撤销提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dialogResult == DialogResult.Yes)
{
Result res = new CostApplyBLL().Del(costId);
MessageBox.Show(res.Message, "撤销结果提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
BtnSearchCostApply_Click(null, null);
}
private void CostApplyForm_Load(object sender, EventArgs e)
{
List <string> listApprover = new CostApplyBLL().ApproverInfo(UserInfoBLL.UserId);
CmbApprover.Items.Clear();
CmbApprover.Items.AddRange(listApprover.ToArray());
}
private void BtnAudit_Click(object sender, EventArgs e)
{
if (DgvCostApprove.SelectedRows.Count != 1)
{
MessageBox.Show("请仅选择一个费用单进行审批！", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
int costId = (int)DgvCostApprove.SelectedRows[0].Cells["ApprCostId"].Value;
cost cost = new CostApplyBLL().Query(new Dictionary <string, object>
{
{ "id", costId }
})[0];
foreach (cost_approval approval in cost.ApprovalList)
{
if (approval.result != null && approval.approval_id == UserInfoBLL.UserId)
{
MessageBox.Show("该费用单已审批！不可再次审批", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
CostApprovalForm costApprovalForm = new CostApprovalForm(costId);
costApprovalForm.ShowDialog();
BtnSearchCostApply_Click(null, null);
}
private void BtnUpdateCost_Click(object sender, EventArgs e)
{
if (DgvCostApply.SelectedRows.Count != 1)
{
MessageBox.Show("请仅选择一个费用单进行修改！", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
int costId = (int)DgvCostApply.SelectedRows[0].Cells["cost_id"].Value;
List <cost> costList = new CostApplyBLL().Query(new Dictionary <string, object> {
{ "id", costId }
});
if (costList.Count != 0)
{
if (costList[0].Main.status != 0)
{
MessageBox.Show("该费用单已审核，不可修改", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
CostApplyForm costApplyForm = new CostApplyForm(costId);
costApplyForm.Text = "费用单修改";
costApplyForm.ShowDialog();
BtnSearchCostApply_Click(null, null);
}
private void BtnCostApply_Click(object sender, EventArgs e)
{
if (CmbApprover.SelectedItem == null)
{
MessageBox.Show("请选择一个审批人负责您的费用申请", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
CostApplyBLL costApplyBLL = new CostApplyBLL();
List <cost_detail> listDetail = new List <cost_detail>();
decimal applyMoney = 0;
foreach (DataGridViewRow row in this.DgvCostDetail.Rows)
{
if (row.Cells[0].Value == null)
{
continue;
}
int type = int.Parse((((string)row.Cells[0].Value).Split('.')[0]));
decimal money = decimal.Parse((string)row.Cells[1].Value);
listDetail.Add(new cost_detail
{
cost_type_id = type,
money = money
});
applyMoney += money;
}
cost_main main = new cost_main
{
apply_money = applyMoney,
apply_time = DateTime.Now,
apply_id = UserInfoBLL.UserId,
status = 0,
remark = TexRemark.Text
};
List <cost_approval> ListApproval = new List <cost_approval>
{
new cost_approval
{
approval_id = int.Parse(CmbApprover.SelectedItem.ToString().Split('.')[0])
}
};
cost cost = new cost
{
Main = main,
DetailList = listDetail,
ApprovalList = ListApproval
};
Result res = costApplyBLL.Add(cost);
DialogResult dialogResult = MessageBox.Show(res.Message, "添加费用申请单状态提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (dialogResult == DialogResult.OK)
{
if (res.Code == RES.OK)
{
this.DgvCostDetail.Rows.Clear();
this.Close();
}
}
}
private void BtnSearchCostApply_Click(object sender, EventArgs e)
{
Dictionary <string, object> conditions = new Dictionary <string, object>();
conditions.Add("apply_id", UserInfoBLL.UserId);
int status = -1;
if (CmbApplyStatus.SelectedItem != null)
{
if (!CmbApplyStatus.SelectedItem.ToString().Trim().Equals(" "))
{
switch (CmbApplyStatus.SelectedItem.ToString())
{
case "未审核": status = 0; break;
case "正在审核": status = 1; break;
case "审核通过": status = 2; break;
case "审核驳回": status = 3; break;
}
}
}
if (status >= 0)
{
conditions.Add("status", status);
}
conditions.Add("start_time", TimeApplyStart.Value);
conditions.Add("end_time", TimeApplyEnd.Value);
List <cost> ListCost = new CostApplyBLL().Query(conditions);
List <CostApplyData> DataList = new List <CostApplyData>();
foreach (cost cost in ListCost)
{
string applicant = new SysUserDAL().SelectById(cost.Main.apply_id)[0].name;
string statusStr = null;
switch (cost.Main.status)
{
case 0: statusStr = "未审核"; break;
case 1: statusStr = "正在审核"; break;
case 2: statusStr = "审核通过"; break;
case 3: statusStr = "审核驳回"; break;
}
DataList.Add(new CostApplyData
{
Number = 1,
cost_id = cost.Main.id,
applicant = applicant,
apply_money = cost.Main.apply_money,
apply_time = cost.Main.apply_time,
status = statusStr
});
}
DgvCostApply.DataSource = DataList;
}
private void BtnCostApplyUpdate_Click(object sender, EventArgs e)
{
List <cost_detail> listDetail = new List <cost_detail>();
decimal applyMoney = 0;
foreach (DataGridViewRow row in this.DgvCostDetail.Rows)
{
if (row.Cells[0].Value == null)
{
continue;
}
int type = int.Parse((((string)row.Cells[0].Value).Split('.')[0]));
decimal money = decimal.Parse((string)row.Cells[1].Value);
listDetail.Add(new cost_detail
{
cost_type_id = type,
money = money
});
applyMoney += money;
}
Result res = new CostApplyBLL().Update(new cost
{
Main = new cost_main
{
id = costId,
apply_money = applyMoney,
remark = TexRemark.Text
},
DetailList = listDetail
});
DialogResult dialogResult = MessageBox.Show(res.Message, "修改费用申请单状态提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (dialogResult == DialogResult.OK)
{
if (res.Code == RES.OK)
{
this.DgvCostDetail.Rows.Clear();
this.Close();
}
}
}
private void CostApprovalForm_Load(object sender, EventArgs e)
{
cost cost = new CostApplyBLL().Query(new Dictionary <string, object>
{
{ "id", costId }
}).First();
cost_main main = cost.Main;
view_sys_u2g applicant = new SysUserDAL().SelectById(main.apply_id).First();
TexApplicant.Text = applicant.name;
foreach (cost_detail detail in cost.DetailList)
{
int index = this.DgvCostDetail.Rows.Add();
this.DgvCostDetail.Rows[index].SetValues(new CostApplyDAL().GetCostTypeById(detail.cost_type_id), detail.money);
}
foreach (cost_approval approval in cost.ApprovalList)
{
int index = this.DgvApproval.Rows.Add();
string approver = approval.approval_id + "." + new SysUserDAL().SelectById(approval.approval_id).First().name;
this.DgvApproval.Rows[index].SetValues(approver, approval.result, approval.time, approval.opinion);
}
int userId = UserInfoBLL.UserId;
List <string> approverList = new CostApplyDAL().GetApprovalInfo(userId);
if (approverList.Count == 0)
{
LblNextApprover.Visible = false;
CmbNextApprover.Visible = false;
return;
}
else
{
LblNextApprover.Visible = true;
CmbNextApprover.Visible = true;
}
CmbNextApprover.Items.Clear();
CmbNextApprover.Items.AddRange(approverList.ToArray());
}
private void CostApplyDetailForm_Load(object sender, EventArgs e)
{
cost cost = new CostApplyBLL().Query(new Dictionary <string, object>
{
{ "id", costId }
}).First();
cost_main main = cost.Main;
LblCostId.Text = main.id.ToString();
view_sys_u2g applicant = new SysUserDAL().SelectById(main.apply_id).First();
LblApplicant.Text = applicant.name;
LblApplicantOrg.Text = applicant.org_name;
LblApplyTime.Text = main.apply_time.ToString("yyyy-MM-dd HH:mm:ss");
LblApplyMoney.Text = main.apply_money.ToString();
foreach (cost_detail detail in cost.DetailList)
{
int index = this.DgvCostDetail.Rows.Add();
this.DgvCostDetail.Rows[index].SetValues(new CostApplyDAL().GetCostTypeById(detail.cost_type_id), detail.money);
}
switch (main.status)
{
case 0: LblStatus.Text = "未审核"; break;
case 1: LblStatus.Text = "正在审核"; break;
case 2: LblStatus.Text = "审核通过"; break;
case 3: LblStatus.Text = "审核驳回"; break;
}
foreach (cost_approval approval in cost.ApprovalList)
{
int index = this.DgvApproval.Rows.Add();
string approver = approval.approval_id + "." + new SysUserDAL().SelectById(approval.approval_id).First().name;
this.DgvApproval.Rows[index].SetValues(approver, approval.result, approval.time, approval.opinion);
}
}
private void BtnSearchApprove_Click(object sender, EventArgs e)
{
Dictionary <string, object> conditions = new Dictionary <string, object>();
conditions.Add("start_time", TimeApproveStart.Value);
conditions.Add("end_time", TimeApproveEnd.Value);
int result = -1;
switch (CmbApporveStatus.Text.ToString().Trim())
{
case "通过": result = 0; break;
case "驳回": result = 1; break;
case "未审核": result = 2; break;
}
List <CostApprovalData> ListData = new List <CostApprovalData>();
List <cost> CostList = new CostApplyBLL().Query(conditions);
foreach (cost cost in CostList)
{
foreach (cost_approval approval in cost.ApprovalList)
{
if (result == 0 && (approval == null || approval.result == false))
{
continue;
}
if (result == 1 && (approval == null || approval.result == true))
{
continue;
}
if (result == 2 && (approval != null))
{
continue;
}
if (approval.approval_id != UserInfoBLL.UserId)
{
continue;
}
CostApprovalData data = new CostApprovalData
{
ApprNumber = 1,
ApprCostId = cost.Main.id,
ApprApplicant = new SysUserDAL().SelectById(cost.Main.apply_id)[0].name,
ApprApplyMoney = cost.Main.apply_money,
ApprApplyTime = cost.Main.apply_time,
ApprApprovalTime = approval.time,
ApprOpinion = approval.opinion
};
if (approval.result == null)
{
data.ApprResult = "未审批";
}
else
{
data.ApprResult = (bool)approval.result ? "通过" : "驳回";
}
ListData.Add(data);
}
}
DgvCostApprove.DataSource = ListData;
}
