protected void confirm_Click(object sender, EventArgs e) { CarUse ci = new CarUse(); ci.StaffName = staffName.Text; ci.DepartmentName = department.Text; ci.AlongCount = Convert.ToInt32(alongCount.Value); ci.StartDate = Convert.ToDateTime(startDate.Value); ci.EndDate = Convert.ToDateTime(endDate.Value); ci.AlongName = alongName.Text; ci.Destination = destination.Value; ci.Driver = driver.Value; ci.CarNum = carNum.Value; ci.Reason = reason.Text; ci.Note = note.Text; ci.ApproveProcess = ""; int recordid = CarUse.SetCarUseByID(-1, ci); List <CarUseRecord> recordList = getRecordList(); CarUseRecord.SetCarUseRecord(recordList, recordid); Response.Redirect("~/Account/ApplyListPage.aspx"); }
public GreenCars(CarType carType, int mpg, int trafficTickets, int milesDrivenYr, double insuranceRate, CarUse carUse, int id) { CarType = carType; Mpg = mpg; TrafficTickets = trafficTickets; MilesDrivenYr = milesDrivenYr; InsuranceRate = insuranceRate; CarUse = carUse; Id = id; }
/// <summary> /// 新增或更新车辆使用登记记录 /// </summary> /// <param name="id"></param> /// <param name="ci"></param> /// <param name="userID"></param> public static int SetCarUseByID(int id, CarUse ci) { SqlConnection conn = new SqlConnection(connString); SqlCommand cmd; bool isExist = HasCarUseInfo(id); if (isExist) { cmd = new SqlCommand("UPDATE [CarUseApplies] SET [StaffName] = @StaffName, [Department]=@Department, [StartDate]=@StartDate, [EndDate]=@EndDate, [AlongCount]=@AlongCount, [AlongName]=@AlongName, [Reason]=@Reason, [Destination]=@Destination, [Driver]=@Driver, [CarNum] = @CarNum, [Note]=@Note, [ApproveProcess]=@ApproveProcess WHERE [ApplyID] = @ApplyID", conn); } else { cmd = new SqlCommand("INSERT INTO [CarUseApplies] ([StaffName], [Department], [StartDate], [EndDate], [AlongCount], [AlongName], [Reason], [Destination], [Driver], [CarNum], [Note]) VALUES (@StaffName, @Department, @StartDate, @EndDate, @AlongCount, @AlongName, @Reason, @Destination, @Driver, @CarNum, @Note) Select @@Identity as 'Identity'", conn); } cmd.Parameters.Add("@ApplyID", SqlDbType.Int).Value = id; cmd.Parameters.Add("@StaffName", SqlDbType.VarChar).Value = ci.staffName; cmd.Parameters.Add("@Department", SqlDbType.VarChar).Value = ci.departmentName; cmd.Parameters.Add("@StartDate", SqlDbType.DateTime).Value = ci.startDate; cmd.Parameters.Add("@EndDate", SqlDbType.DateTime).Value = ci.endDate; cmd.Parameters.Add("@AlongCount", SqlDbType.Int).Value = ci.alongCount; cmd.Parameters.Add("@AlongName", SqlDbType.VarChar).Value = ci.alongName; cmd.Parameters.Add("@Reason", SqlDbType.VarChar).Value = ci.reason; cmd.Parameters.Add("@Destination", SqlDbType.VarChar).Value = ci.destination; cmd.Parameters.Add("@Driver", SqlDbType.VarChar).Value = ci.driver; cmd.Parameters.Add("@CarNum", SqlDbType.VarChar).Value = ci.carNum; cmd.Parameters.Add("@Note", SqlDbType.VarChar).Value = ci.note == null?"":ci.note; cmd.Parameters.Add("@ApproveProcess", SqlDbType.VarChar).Value = ci.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 = ci.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 = Department.GetDepartmentByName(BasicInfo.GetBasicInfoByName(ci.staffName).Department).ResponsiblePerson; cmd2.Parameters.Add("@Result", SqlDbType.Bit).Value = false; cmd2.ExecuteNonQuery(); } conn.Close(); return(recordId); }
private void updateApprove(string if_agree, string next, BasicInfo info, bool if_back) { Users usr = (Users)Session["Identify"]; int recordID = Convert.ToInt32(Request["RecordID"]); CarUse ci = CarUse.GetCarUseByID(recordID); ci.ApproveProcess += info.StaffName.Trim() + "-" + if_agree + ","; CarUse.SetCarUseByID(recordID, ci); string nextApprover = next; int applyID = Convert.ToInt32(Request["ApplyID"]); Apply.UpdateNextApprover(applyID, nextApprover, if_back); }
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); CarUse ci = CarUse.GetCarUseByID(recordID); staffName.Text = ci.StaffName; department.Text = ci.DepartmentName; destination.Text = ci.Destination; timeInUse.Text = ci.StartDate.ToShortDateString() + "至" + ci.EndDate.ToShortDateString(); alongCount.Text = ci.AlongCount.ToString(); alongName.Text = ci.AlongName; reason.Text = ci.Reason; driver.Text = ci.Driver; carNum.Text = ci.CarNum; note.Text = ci.Note; processShow.Text = ci.ApproveProcess; recordList.Text = transResult(ci.DriveHistoryList); //用户权限相关显示功能 Users usr = (Users)Session["Identify"]; BasicInfo info = BasicInfo.GetBasicInfoByID(usr.UserID); if (!rejected && ap.NextApprover == ci.StaffName) { agreeButton.Visible = false; disagreeButton.Visible = false; whyDisagree.Visible = false; //可打印状态 proManager.Text = "已签字"; company.Text = "已签字"; } else if (info.StaffName.Trim() == ci.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> /// <returns></returns> public static CarUse GetCarUseByID(int id) { SqlConnection conn = new SqlConnection(connString); SqlCommand cmd = new SqlCommand("SELECT * FROM [CarUseApplies] WHERE [ApplyID] = @ApplyID", conn); cmd.Parameters.Add("@ApplyID", SqlDbType.Int).Value = id; conn.Open(); SqlDataReader sdr = cmd.ExecuteReader(); CarUse ci = null; if (sdr.Read()) { ci = new CarUse(); ci.staffName = (string)sdr["StaffName"]; ci.departmentName = (string)sdr["Department"]; ci.startDate = Convert.ToDateTime(sdr["StartDate"]); ci.endDate = Convert.ToDateTime(sdr["EndDate"]); ci.alongCount = (int)sdr["AlongCount"]; ci.alongName = (string)sdr["AlongName"]; ci.reason = (string)sdr["Reason"]; ci.destination = (string)sdr["Destination"]; ci.driver = (string)sdr["Driver"]; ci.driveHistoryList = new List <CarUseRecord>(); ci.carNum = (string)sdr["CarNum"]; ci.ApproveProcess = sdr["ApproveProcess"] == DBNull.Value ? "" : (string)sdr["ApproveProcess"]; } sdr.Close(); conn.Close(); List <CarUseRecord> result = new List <CarUseRecord>(); result = CarUseRecord.GetCarUseRecordListByID(id); ci.driveHistoryList.AddRange(result); return(ci); }