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