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