/// <summary>
/// 新增或更新一条到款分配记录，校外项目型
/// </summary>
/// <param name="id"></param>
/// <param name="pi"></param>
public static void SetPayAssignOutSchool(int id, PayAssign pi)
{
SqlConnection conn = new SqlConnection(connString);
SqlCommand cmd;
bool isExist = HasPayAssigned(id);
if (isExist)
{
cmd = new SqlCommand("UPDATE [PayAssigned] SET [School]=@School, [StaffName]=@StaffName, [ProjectName]=@ProjectName, [Payee] = @Payee, [Payed]=@Payed, [Income]=@Income, [Assigned]=@Assigned, [Instrument]=@Instrument, [Hardware]=@Hardware, [FundingID] = @FundingID, [ToUniversity]=@ToUniversity, [ToUniversityDetail]=@ToUniversityDetail, [ToSchool]=@ToSchool, [ToSchoolDetail]=@ToSchoolDetail, [Fundings]=@Fundings, [FundingsDetail]=@FundingsDetail, [Welfare]=@Welfare, [WelfareDetail]=@WelfareDetail, [Note]=@Note, [ApproveProcess]=@ApproveProcess WHERE [ApplyID] = @ApplyID", conn);
}
else
{
cmd = new SqlCommand("INSERT INTO [PayAssigned] ([School], [StaffName], [ProjectName], [Payee], [Payed], [Income], [Assigned], [Instrument], [Hardware], [FundingID], [ToUniversity], [ToUniversityDetail], [ToSchool], [ToSchoolDetail], [Fundings], [FundingsDetail], [Welfare], [WelfareDetail], [Note]) VALUES (@School, @StaffName, @ProjectName, @Payee, @Payed, @Income, @Assigned, @Instrument, @Hardware, @FundingID, @ToUniversity, @ToUniversityDetail, @ToSchool, @ToSchoolDetail, @Fundings, @FundingsDetail, @Welfare, @WelfareDetail, @Note) Select @@Identity as 'Identity' ", conn);
}
cmd.Parameters.Add("@ApplyID", SqlDbType.Int).Value = id;
cmd.Parameters.Add("@School", SqlDbType.VarChar).Value = pi.school;
cmd.Parameters.Add("@StaffName", SqlDbType.VarChar).Value = pi.staffName;
cmd.Parameters.Add("@ProjectName", SqlDbType.VarChar).Value = pi.projectName;
cmd.Parameters.Add("@Payee", SqlDbType.VarChar).Value = pi.payee;
cmd.Parameters.Add("@Payed", SqlDbType.Float).Value = pi.payed;
cmd.Parameters.Add("@Income", SqlDbType.Float).Value = pi.income;
cmd.Parameters.Add("@Assigned", SqlDbType.Float).Value = pi.assigned;
cmd.Parameters.Add("@Instrument", SqlDbType.VarChar).Value = pi.instrument;
cmd.Parameters.Add("@Hardware", SqlDbType.VarChar).Value = pi.hardware;
cmd.Parameters.Add("@FundingID", SqlDbType.VarChar).Value = pi.fundingID;
cmd.Parameters.Add("@ToUniversity", SqlDbType.Float).Value = pi.toUniversity;
cmd.Parameters.Add("@ToUniversityDetail", SqlDbType.VarChar).Value = pi.toUniversityDetail;
cmd.Parameters.Add("@ToSchool", SqlDbType.Float).Value = pi.toSchool;
cmd.Parameters.Add("@ToSchoolDetail", SqlDbType.VarChar).Value = pi.toSchoolDetail;
cmd.Parameters.Add("@Fundings", SqlDbType.Float).Value = pi.fundings;
cmd.Parameters.Add("@FundingsDetail", SqlDbType.VarChar).Value = pi.fundingsDetail;
cmd.Parameters.Add("@Welfare", SqlDbType.Float).Value = pi.welfare;
cmd.Parameters.Add("@WelfareDetail", SqlDbType.VarChar).Value = pi.welfareDetail;
cmd.Parameters.Add("@Note", SqlDbType.VarChar).Value = pi.note;
cmd.Parameters.Add("@ApproveProcess", SqlDbType.VarChar).Value = pi.approveProcess;
conn.Open();
//同时在标准化申请表中插入一条记录
int recordId = Convert.ToInt32(cmd.ExecuteScalar());
if (!isExist)
{
SqlCommand cmd2 = new SqlCommand("INSERT INTO [AllApplies] ( [ApplyStaff], [ApplyDate], [ApplyType], [NextApprover], [RecordID], [Result]) VALUES (@ApplyStaff, @ApplyDate, @ApplyType, @NextApprover, @RecordID, @Result)", conn);
cmd2.Parameters.Add("@ApplyStaff", SqlDbType.VarChar).Value = pi.staffName;
cmd2.Parameters.Add("@ApplyDate", SqlDbType.DateTime).Value = DateTime.Now;
cmd2.Parameters.Add("@ApplyType", SqlDbType.VarChar).Value = "到款分配-校外";
cmd2.Parameters.Add("@RecordID", SqlDbType.Int).Value = recordId;
cmd2.Parameters.Add("@NextApprover", SqlDbType.VarChar).Value = pi.StaffName;
cmd2.Parameters.Add("@Result", SqlDbType.Bit).Value = false;
cmd2.ExecuteNonQuery();
}
conn.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
int recordID = Convert.ToInt32(Request["RecordID"]);
int applyID = Convert.ToInt32(Request["ApplyID"]);
bool rejected = Convert.ToBoolean(Request["rejected"]);
Apply ap = Apply.GetApplyByID(applyID);
PayAssign pi = PayAssign.GetPayAssignByID(recordID);
school.Text = pi.School;
staffName.Text = pi.StaffName;
projectName.Text = pi.ProjectName;
payee.Text = pi.Payee;
payed.Text = pi.Payed.ToString();
income.Text = pi.Income.ToString();
assigned.Text = pi.Assigned.ToString();
instrument.Text = pi.Instrument;
hardware.Text = pi.Hardware;
fundingID.Text = pi.FundingID;
toUniversity.Text = pi.ToUniversity.ToString();
toUniversityDetail.Text = pi.ToUniversityDetail;
toSchool.Text = pi.ToSchool.ToString();
toSchoolDetail.Text = pi.ToSchoolDetail;
fundings.Text = pi.Fundings.ToString();
fundingsDetail.Text = pi.FundingsDetail;
welfare.Text = pi.Welfare.ToString();
welfareDetail.Text = pi.WelfareDetail;
note.Text = pi.Note;
processShow.Text = pi.ApproveProcess;
//用户权限相关显示功能
Users usr = (Users)Session["Identify"];
BasicInfo info = BasicInfo.GetBasicInfoByID(usr.UserID);
if (!rejected && ap.NextApprover == pi.StaffName)
{
agreeButton.Visible = false;
disagreeButton.Visible = false;
whyDisagree.Visible = false;
//可打印状态
}
else if (info.StaffName.Trim() == pi.StaffName.Trim() || info.Position.Trim() == "出纳")
{
agreeButton.Visible = false;
disagreeButton.Visible = false;
if (info.Position.Trim() != "出纳")
{
whyDisagree.Visible = false;
}
}
//测试阶段保持处理流程可见，运行阶段记得去掉
processShow.Visible = true;
}
/// <summary>
/// 新增或更新一条到款分配记录，校内项目类型
/// </summary>
/// <param name="id"></param>
/// <param name="pi"></param>
public static void SetPayAssignInSchool(int id, PayAssign pi)
{
SqlConnection conn = new SqlConnection(connString);
SqlCommand cmd;
bool isExist = HasPayAssigned(id);
if (isExist)
{
cmd = new SqlCommand("UPDATE [PayAssigned] SET [School]=@School, [StaffName]=@StaffName, [ProjectName]=@ProjectName, [Payee] = @Payee, [Payed]=@Payed, [Income]=@Income, [Assigned]=@Assigned, [Instrument]=@Instrument, [Hardware]=@Hardware, [FundingID] = @FundingID, [Management]=@Management, [Labor]=@Labor, [Consult]=@Consult, [BusinessTax]=@BusinessTax, [AddedValueTax]=@AddedValueTax, [Note]=@Note, [ApproveProcess]=@ApproveProcess WHERE [ApplyID] = @ApplyID", conn);
}
else
{
cmd = new SqlCommand("INSERT INTO [PayAssigned] ([School], [StaffName], [ProjectName], [Payee], [Payed], [Income], [Assigned], [Instrument], [Hardware], [FundingID], [Management], [Labor], [Consult], [BusinessTax], [AddedValueTax], [Note]) VALUES (@School, @StaffName, @ProjectName, @Payee, @Payed, @Income, @Assigned, @Instrument, @Hardware, @FundingID, @Management, @Labor, @Consult, @BusinessTax, @AddedValueTax, @Note) Select @@Identity as 'Identity'", conn);
}
cmd.Parameters.Add("@ApplyID", SqlDbType.Int).Value = id;
cmd.Parameters.Add("@School", SqlDbType.VarChar).Value = pi.school;
cmd.Parameters.Add("@StaffName", SqlDbType.VarChar).Value = pi.staffName;
cmd.Parameters.Add("@ProjectName", SqlDbType.VarChar).Value = pi.projectName;
cmd.Parameters.Add("@Payee", SqlDbType.VarChar).Value = pi.payee;
cmd.Parameters.Add("@Payed", SqlDbType.Float).Value = pi.payed;
cmd.Parameters.Add("@Income", SqlDbType.Float).Value = pi.income;
cmd.Parameters.Add("@Assigned", SqlDbType.Float).Value = pi.assigned;
cmd.Parameters.Add("@Instrument", SqlDbType.VarChar).Value = pi.instrument;
cmd.Parameters.Add("@Hardware", SqlDbType.VarChar).Value = pi.hardware;
cmd.Parameters.Add("@FundingID", SqlDbType.VarChar).Value = pi.fundingID;
cmd.Parameters.Add("@Management", SqlDbType.Float).Value = pi.management;
cmd.Parameters.Add("@Labor", SqlDbType.Float).Value = pi.labor;
cmd.Parameters.Add("@Consult", SqlDbType.Float).Value = pi.consult;
cmd.Parameters.Add("@BusinessTax", SqlDbType.Float).Value = pi.businessTax;
cmd.Parameters.Add("@AddedValueTax", SqlDbType.Float).Value = pi.addedValueTax;
cmd.Parameters.Add("@Note", SqlDbType.VarChar).Value = pi.note;
cmd.Parameters.Add("@ApproveProcess", SqlDbType.VarChar).Value = pi.approveProcess;
conn.Open();
//同时在标准化申请表中插入一条记录
int recordId = Convert.ToInt32(cmd.ExecuteScalar());
if (!isExist)
{
SqlCommand cmd2 = new SqlCommand("INSERT INTO [AllApplies] ( [ApplyStaff], [ApplyDate], [ApplyType], [NextApprover], [RecordID], [Result]) VALUES (@ApplyStaff, @ApplyDate, @ApplyType, @NextApprover, @RecordID, @Result)", conn);
cmd2.Parameters.Add("@ApplyStaff", SqlDbType.VarChar).Value = pi.staffName;
cmd2.Parameters.Add("@ApplyDate", SqlDbType.DateTime).Value = DateTime.Now;
cmd2.Parameters.Add("@ApplyType", SqlDbType.VarChar).Value = "到款分配-校内";
cmd2.Parameters.Add("@RecordID", SqlDbType.Int).Value = recordId;
cmd2.Parameters.Add("@NextApprover", SqlDbType.VarChar).Value = pi.staffName;
cmd2.Parameters.Add("@Result", SqlDbType.Bit).Value = false;
cmd2.ExecuteNonQuery();
}
conn.Close();
}
protected void confirm_Click(object sender, EventArgs e)
{
PayAssign pi = new PayAssign();
pi.School = schoolList.SelectedValue;
pi.ProjectName = projectNameList.SelectedValue;
pi.StaffName = staffName.Text;
pi.Payee = payee.Value;
pi.Payed = Convert.ToDouble(payed.Text);
pi.Income = Convert.ToDouble(income.Text);
pi.Assigned = Convert.ToDouble(assigned.Text);
pi.Instrument = instrument.Text;
pi.Hardware = hardware.Text;
pi.FundingID = fundingID.Value;
pi.ToUniversity = Convert.ToDouble(toUniversity.Text);
pi.ToUniversityDetail = toUniversityDetail.Value;
pi.ToSchool = Convert.ToDouble(toSchool.Text);
pi.ToSchoolDetail = toSchoolDetail.Value;
pi.Fundings = Convert.ToDouble(fundings.Text);
pi.FundingsDetail = fundingsDetail.Value;
pi.Welfare = Convert.ToDouble(welfare.Text);
pi.WelfareDetail = welfareDetail.Value;
pi.Note = note.Text;
pi.ApproveProcess = "";
PayAssign.SetPayAssignOutSchool(-1, pi);
CashFlowInfo tran = new CashFlowInfo();
int recordID = Convert.ToInt32(Request["RecordID"]);
tran.RecordID = recordID;
tran.HappenDate = Convert.ToDateTime(DateTime.Today);
tran.ProjectCode = ProjectInfo.GetProjectInfoByName(pi.ProjectName).ProjectCode;
tran.ProjectAccount = ProjectInfo.GetProjectInfoByName(pi.ProjectName).ProjectAccount;
tran.CashType = "到款分配-校外";
tran.Income = pi.Income;
tran.Expense = 0;
tran.Department = "";
tran.Summary = "";
tran.Remark = "";
tran.Handler = pi.StaffName;
tran.AccountID = "应收账款";
tran.VoucherID = "暂无";
CashFlowInfo.SetCashFlow(tran, tran.RecordID);
Response.Redirect("~/Account/ApplyListPage.aspx");
}
private void updateApprove(string if_agree, string next, BasicInfo info, bool if_back)
{
//更新审批流程
int recordID = Convert.ToInt32(Request["RecordID"]);
PayAssign pi = PayAssign.GetPayAssignByID(recordID);
pi.ApproveProcess += info.StaffName.Trim() + "-" + if_agree + ",";
PayAssign.SetPayAssignOutSchool(recordID, pi);
//更新下一审批人
int applyID = Convert.ToInt32(Request["ApplyID"]);
string nextApprover = next;
Apply.UpdateNextApprover(applyID, nextApprover, if_back);
}
protected void confirm_Click(object sender, EventArgs e)
{
PayAssign pi = new PayAssign();
pi.School = schoolList.SelectedValue;
pi.ProjectName = projectNameList.SelectedValue;
pi.StaffName = staffName.Text;
pi.Payee = payee.Value;
pi.Payed = Convert.ToDouble(payed.Text);
pi.Income = Convert.ToDouble(income.Text);
pi.Assigned = Convert.ToDouble(assigned.Text);
pi.Instrument = instrument.Text;
pi.Hardware = hardware.Text;
pi.FundingID = fundingID.Value;
pi.Management = Convert.ToDouble(management.Text);
pi.Labor = Convert.ToDouble(labor.Text);
pi.Consult = Convert.ToDouble(consult.Text);
pi.BusinessTax = Convert.ToDouble(businessTax.Text);
pi.AddedValueTax = Convert.ToDouble(addedValueTax.Text);
pi.Note = note.Text;
pi.ApproveProcess = "";
PayAssign.SetPayAssignInSchool(-1, pi);
CashFlowInfo tran = new CashFlowInfo();
int recordID = Convert.ToInt32(Request["RecordID"]);
tran.RecordID = recordID;
tran.HappenDate = Convert.ToDateTime(DateTime.Today);
tran.ProjectCode = ProjectInfo.GetProjectInfoByName(pi.ProjectName).ProjectCode;
tran.ProjectAccount = ProjectInfo.GetProjectInfoByName(pi.ProjectName).ProjectAccount;
tran.CashType = "到款分配-校内";
tran.Income = pi.Income;
tran.Expense = 0;
tran.Department = "";
tran.Summary = "";
tran.Remark = "";
tran.Handler = pi.StaffName;
tran.AccountID = "应收账款";
tran.VoucherID = "暂无";
CashFlowInfo.SetCashFlow(tran, tran.RecordID);
Response.Redirect("~/Account/ApplyListPage.aspx");
}
/// <summary>
/// 根据编号返回特定的到款分配记录
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static PayAssign GetPayAssignByID(int id)
{
SqlConnection conn = new SqlConnection(connString);
SqlCommand cmd = new SqlCommand("SELECT * FROM [PayAssigned] WHERE [ApplyID] = @ApplyID", conn);
cmd.Parameters.Add("@ApplyID", SqlDbType.Int).Value = id;
conn.Open();
SqlDataReader sdr = cmd.ExecuteReader();
PayAssign pi = null;
if (sdr.Read())
{
pi = new PayAssign();
pi.applyID = Convert.ToInt16(sdr["ApplyID"]);
pi.school = (string)sdr["School"];
pi.staffName = (string)sdr["StaffName"];
pi.projectName = (string)sdr["ProjectName"];
pi.payee = (string)sdr["Payee"];
pi.payed = Convert.ToDouble(sdr["Payed"]);
pi.income = Convert.ToDouble(sdr["Income"]);
pi.assigned = Convert.ToDouble(sdr["Assigned"]);
pi.instrument = (string)sdr["Instrument"];
pi.hardware = (string)sdr["Hardware"];
pi.fundingID = (string)sdr["FundingID"];
pi.note = (string)sdr["Note"];
pi.approveProcess = sdr["ApproveProcess"] == DBNull.Value ? "" : (string)sdr["ApproveProcess"];
pi.toUniversity = sdr["ToUniversity"] == DBNull.Value?0: Convert.ToDouble(sdr["ToUniversity"]);
pi.toUniversityDetail = sdr["ToUniversityDetail"] == DBNull.Value ? "" : (string)sdr["ToUniversityDetail"];
pi.toSchool = sdr["ToSchool"] == DBNull.Value ? 0 : Convert.ToDouble(sdr["ToSchool"]);
pi.toSchoolDetail = sdr["ToSchoolDetail"] == DBNull.Value ? "" : (string)sdr["ToSchoolDetail"];
pi.fundings = sdr["Fundings"] == DBNull.Value ? 0 : Convert.ToDouble(sdr["Fundings"]);
pi.fundingsDetail = sdr["FundingsDetail"] == DBNull.Value ? "" : (string)sdr["FundingsDetail"];
pi.welfare = sdr["Welfare"] == DBNull.Value ? 0 : Convert.ToDouble(sdr["Welfare"]);
pi.welfareDetail = sdr["WelfareDetail"] == DBNull.Value ? "" : (string)sdr["WelfareDetail"];
pi.management = sdr["Management"] == DBNull.Value ? 0 : Convert.ToDouble(sdr["Management"]);
pi.labor = sdr["Labor"] == DBNull.Value ? 0 : Convert.ToDouble(sdr["Labor"]);
pi.consult = sdr["Consult"] == DBNull.Value ? 0 : Convert.ToDouble(sdr["Consult"]);
pi.businessTax = sdr["BusinessTax"] == DBNull.Value ? 0 : Convert.ToDouble(sdr["BusinessTax"]);
pi.addedValueTax = sdr["AddedValueTax"] == DBNull.Value ? 0 : Convert.ToDouble(sdr["AddedValueTax"]);
}
sdr.Close();
conn.Close();
return(pi);
}
