protected void GridViewExcel_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
CarDataInfo obj = (CarDataInfo)e.Row.DataItem;
e.Row.Cells[0].Text = obj.CodeName;
e.Row.Cells[1].ColumnSpan = 2;
e.Row.Cells[2].Visible = false;
e.Row.Cells[1].Text = obj.Header + " " + obj.Number;
e.Row.Cells[3].Text = bll.getCarTypeKor(obj.CarType);
e.Row.Cells[6].Text = obj.CarhandlerInfoList[0].Handler;
e.Row.Cells[7].Text = obj.CarhandlerInfoList[0].Phone;
if (obj.Reject == 0)
{
e.Row.Cells[8].Text = "Không (아니오)";
}
else
{
e.Row.Cells[8].Text = "Vâng (예)";
}
}
if (e.Row.RowType == DataControlRowType.Header)
{
e.Row.Cells[1].ColumnSpan = 2;
e.Row.Cells[2].Visible = false;
}
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
CarDataInfo car = (CarDataInfo)e.Row.DataItem;
e.Row.Cells[1].ColumnSpan = 2;
e.Row.Cells[2].Visible = false;
e.Row.Cells[1].Text = car.Header + " " + car.Number;
e.Row.Cells[3].Text = car.CarhandlerInfoList[0].Handler;
e.Row.Cells[4].Text = car.CompanyName; //2021-05-03 반안: 팝업되는 창에 차가 소속된 업체도 표시 요청 (박민수 차장)
if (car.Reject == 0)
{
e.Row.Cells[5].Text = "Không (아니오)";
}
else
{
e.Row.Cells[5].Text = "<span style='color:red'>예</span>";
}
if (car.Reject == 0)
{
e.Row.Attributes.Add("onclick", "searchEnd('" + car.CarCode + "','" + car.Header + " " + car.Number + "')");
e.Row.Attributes.Add("style", "cursor:hand");
}
}
if (e.Row.RowType == DataControlRowType.Header)
{
e.Row.Cells[1].ColumnSpan = 2;
e.Row.Cells[2].Visible = false;
}
}
/// <summary>
/// 차량 수정
/// </summary>
/// <param name="carData"></param>
/// <returns></returns>
public int updateCarData(CarDataInfo carData)
{
log.Debug("=================START updateCarData=================");
log.Debug("carData = " + carData.ToString());
StringBuilder sql_car_data_update = new StringBuilder();
sql_car_data_update.Append("UPDATE CarData SET ");
sql_car_data_update.Append("carCategoryCode=" + carData.CarCategoryCode + ",");
sql_car_data_update.Append("header=N'" + carData.Header + "',");
sql_car_data_update.Append("number='" + carData.Number + "',");
//sql_car_data_update.Append("handler='" + carData.Handler + "',");
sql_car_data_update.Append("reject=N'" + carData.Reject + "',");
sql_car_data_update.Append("rejectContent=N'" + carData.RejectContent.Replace("'", "''") + "',");
sql_car_data_update.Append("carType=" + carData.CarType + ",");
sql_car_data_update.Append("companyName=N'" + carData.CompanyName + "',");
sql_car_data_update.Append("companyCode=" + carData.CompanyCode + " ");
sql_car_data_update.Append(" WHERE carCode=" + carData.CarCode);
int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql_car_data_update.ToString(), null);
log.Debug("=================END updateCarData=================");
return(result);
}
/// <summary>
/// 차량 정보 가져오기
/// </summary>
/// <param name="carDataCode"></param>
/// <returns></returns>
public CarDataInfo getCarData(String type, int code)
{
log.Debug("=================START getCarData=================");
log.Debug("type = " + type);
log.Debug("coed = " + code.ToString());
CarDataInfo obj = new CarDataInfo();
StringBuilder SQL_SELECT_CAR_DATA = new StringBuilder();
SQL_SELECT_CAR_DATA.Append(@"
SELECT a.carCode,
a.carCategoryCode,
a.header,
a.number,
a.carType,
a.companyName,
ISNULL(c.handler,' ') as handler,
c.handlerPhone,
a.reject,
isnull(a.rejectContent,' ') as rejectContent,
a.regDate,
b.codeName,
c.carHandlerCode,
a.companyCode
FROM CarData a,
CarCategory b,
CarHandler c
WHERE a.carCategoryCode=b.carCategoryCode
AND a.carCode=c.carCode " );
if (String.Equals(type, "carCode"))
{
SQL_SELECT_CAR_DATA.Append(" AND a.carCode=" + code);
}
else
{
SQL_SELECT_CAR_DATA.Append(" AND c.carHandlerCode=" + code);
}
//Execute the query
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_CAR_DATA.ToString(), null))
{
if (rdr.Read())
{
obj = bindCarDataInfo(rdr, obj);
}
}
log.Debug("=================END getCarData=================");
return(obj);
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
CarDataInfo obj = (CarDataInfo)e.Row.DataItem;
e.Row.Cells[0].Text = obj.CodeName;
e.Row.Cells[1].ColumnSpan = 2;
e.Row.Cells[2].Visible = false;
e.Row.Cells[1].Text = obj.Header + " " + obj.Number;
e.Row.Cells[3].Text = bll.getCarTypeKor(obj.CarType);
e.Row.Cells[6].Text = obj.CarhandlerInfoList[0].Handler;
e.Row.Cells[7].Text = obj.CarhandlerInfoList[0].Phone;
if (obj.Reject == 0)
{
e.Row.Cells[8].Text = "Không 아니오";
}
else
{
e.Row.Cells[8].Text = "예";
}
HyperLink col6 = (HyperLink)e.Row.Cells[10].Controls[0];
col6.NavigateUrl = "carDataEdit.aspx?type=carCode&code=" + obj.CarCode + "&mode=modify";
col6.ImageUrl = "~/images/icon/edit.gif";
HyperLink col7 = (HyperLink)e.Row.Cells[11].Controls[0];
col7.NavigateUrl = "#";
col7.Attributes.Add("onclick", "return confirmDelete('carDataDelete.aspx?carCode=" + obj.CarCode + "');");
col7.ImageUrl = "~/images/icon/delete.gif";
for (int i = 0; i < e.Row.Cells.Count; i++)
{
if (i < 10)
{
e.Row.Cells[i].Attributes.Add("onclick", "window.location='carDataView.aspx?type=carHandlerCode&code=" + obj.CarhandlerInfoList[0].CarHandlerCode + "';");
e.Row.Cells[i].Attributes.Add("style", "cursor:hand");
}
}
}
if (e.Row.RowType == DataControlRowType.Header)
{
e.Row.Cells[1].ColumnSpan = 2;
e.Row.Cells[2].Visible = false;
}
}
/// <summary>
/// 차량 등록
/// </summary>
/// <param name="carData"></param>
/// <returns></returns>
public int insertCarData(CarDataInfo carData)
{
log.Debug("=================START insertCarData=================");
log.Debug("carData = " + carData.ToString());
String sql_insert = "INSERT INTO CarData (carCategoryCode,header,number,reject,[rejectContent],regDate,carType,companyName,companyCode)";
sql_insert += " VALUES";
sql_insert += " (" + carData.CarCategoryCode + ",N'" + carData.Header + "','" + carData.Number + "'," + carData.Reject + ",N'" + carData.RejectContent.Replace("'", "''") + "',GETDATE()," + carData.CarType + ",N'" + carData.CompanyName + "'," + carData.CompanyCode + ")";
int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql_insert, null);
log.Debug("=================END insertCarData=================");
return(result);
}
public int updateCarData_header(CarDataInfo carData)
{
log.Debug("=================START updateCarData=================");
log.Debug("carData = " + carData.ToString());
StringBuilder sql_car_data_update = new StringBuilder();
sql_car_data_update.Append("UPDATE CarData SET ");
sql_car_data_update.Append("header=N'" + carData.Header + "'");
sql_car_data_update.Append(" WHERE carCode=" + carData.CarCode);
int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql_car_data_update.ToString(), null);
log.Debug("=================END updateCarData=================");
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
Car bllVisitCar = new Car();
List <CarDataInfo> list = new List <CarDataInfo>();
List <CarHandlerInfo> list2 = new List <CarHandlerInfo>();
if (Request.QueryString["type"].Equals("carData"))
{
list = bllVisitCar.getCarDataList("car", Request.QueryString["number"]);
}
else
{
list2 = bllVisitCar.selectPermitCarHandlerList(Request.QueryString["carCode"]);
}
if (!list.Count.Equals(0) || !list2.Count.Equals(0))
{
if (Request.QueryString["type"].Equals("carData"))
{
for (int i = 0; i < list.Count; i++)
{
CarDataInfo ep = (CarDataInfo)list[i];
searchResult += ":|:" + ep.CarCode + "," + ep.Header + "," + ep.Number + "," + ep.CarType + "," + ep.CompanyName + "," + ep.CompanyCode;
}
//searchResult = list[0].CarCode.ToString() + "," + list[0].Header + "," + list[0].Number + "," + list[0].CarType + "," + list[0].CompanyName;
}
else
{
for (int i = 0; i < list2.Count; i++)
{
CarHandlerInfo ep = (CarHandlerInfo)list2[i];
searchResult += ":|:" + ep.CarHandlerCode + "," + ep.CarCode + "," + ep.Handler + "," + ep.Phone;
}
//for (int i = 0; i < list.Count; i++)
//{
// CarDataInfo ep = (CarDataInfo)list[i];
// searchResult += ":|:" + ep.CarhandlerInfoList[0].CarHandlerCode.ToString() + "," + ep.CarhandlerInfoList[0].Handler + "," + ep.CarhandlerInfoList[0].Phone;
//}
}
}
}
protected void DetailsView1_DataBound(object sender, EventArgs e)
{
CarDataInfo carDataInfo = (CarDataInfo)DetailsView1.DataItem;
DetailsView1.Rows[4].Cells[1].Text = carDataInfo.CarhandlerInfoList[0].Handler;
DetailsView1.Rows[5].Cells[1].Text = carDataInfo.CarhandlerInfoList[0].Phone;
DetailsView1.Rows[11].Cells[1].Attributes.Add("align", "center");
DetailsView1.Rows[11].Cells[0].Visible = false;
DetailsView1.Rows[11].Cells[1].ColumnSpan = 2;
HyperLink colCancel = (HyperLink)DetailsView1.Rows[11].Cells[1].Controls[0];
colCancel.ImageUrl = "~/images/icon/cancel.gif";
colCancel.NavigateUrl = "javascript:history.go(-1)";
DetailsView1.Rows[9].Cells[1].Text = StringUtil.ConvertToHtml(carDataInfo.RejectContent);
//DetailsView1.Rows[6].Cells[1].Text = "1111333";
}
/// <summary>
/// 차량 저장
/// </summary>
/// <param name="carData"></param>
/// <returns></returns>
public int insertCarData(CarDataInfo carData)
{
return(dal.insertCarData(carData));
}
protected void Page_Load(object sender, EventArgs e)
{
Car bll = new Car();
#region control Add Attribute
number.Attributes.Add("onblur", "numCheck();");
//txtCarNo.Attributes.Add("onkeypress", "numCheck();");
// 2019-03-26-임종우 : .net 에서 client단에 readonly 설정 시 값을 안 가져오는 문제 발생.. 서버에 Attributes 추가로 해결 함.
companyName.Attributes.Add("readonly", "readonly");
#endregion
if (Page.IsPostBack)
{
// 객체 생성 Hình thành Object
CarDataInfo carData = new CarDataInfo();
CarHandlerInfo carHandler = new CarHandlerInfo();
carData.CarCategoryCode = Convert.ToInt32(carCategoryCode.SelectedValue);
carData.Header = header.Text;
carData.Number = number.Text;
//carData.Handler = handler.Text;
carData.Reject = 0;
carData.RejectContent = "";
carData.CarType = "4";
carData.CompanyName = companyName.Text;
if (!String.IsNullOrEmpty(companyCode.Value))
{
carData.CompanyCode = Convert.ToInt32(companyCode.Value);
}
// 차량번호 중복 검사 로직 삭제 (2008.03.10)
//if (bll.existsCarData(carData.Header, carData.Number,carData.Handler))
//{
// Page.RegisterStartupScript("alertMsg", JavaScriptBuilder.alert(header.Text + number.Text + " 는 이미 등록된 차량 번호 입니다."));
//}
//else
//{
// int result = bll.insertCarData(carData);
// Response.Redirect("searchCar.aspx");
//}
if (bll.existsCarData(carData.Header, carData.Number))
{
Page.RegisterStartupScript("alertMsg", JavaScriptBuilder.alert(number.Text + " là số xe đã được đăng ký trước (는 이미 등록된 차량 번호 입니다)."));
}
else if (String.IsNullOrEmpty(carData.CompanyName))
{
Page.RegisterStartupScript("alertMsg", JavaScriptBuilder.alert("Nhập tên công ty (회사명을 입력하여 주세요)."));
}
else
{
int result = bll.insertCarData(carData);
int carCode = bll.selectMaxCarCode();
carHandler.CarCode = carCode;
carHandler.Handler = handler.Text;
carHandler.Phone = "";
//운전자 등록 đăng ký lái xe
bll.insertCarHandler(carHandler);
Response.Redirect("searchCar.aspx");
}
//int result = bll.insertCarData(carData);
//Response.Redirect("searchCar.aspx");
}
else
{
lableCodeName.Text = "Đăng ký xe (차량 등록하기)";
mode.Value = Request.QueryString["mode"];
}
}
protected void Page_Load(object sender, EventArgs e)
{
#region control Add Attribute
// 2019-03-26-임종우 : .net 에서 client단에 readonly 설정 시 값을 안 가져오는 문제 발생.. 서버에 Attributes 추가로 해결 함.
companyName.Attributes.Add("readonly", "readonly");
#endregion
// 관리자 체크 check người quản lý
EmployeeInfo loginEmployee = new EmployeeInfo();
loginEmployee = (EmployeeInfo)Session["loginMember"];
if (loginEmployee == null)
{
Response.Redirect("~/login.aspx", true);
}
if (loginEmployee.ManagerLevel < 2)
{
Response.Redirect("~/login.aspx", true);
}
#region control Add Attribute
number.Attributes.Add("onblur", "numCheck();");
#endregion
if (Page.IsPostBack)
{
// 객체 생성 creat object
CarDataInfo carData = new CarDataInfo();
carData.CarCategoryCode = Convert.ToInt32(carCategoryCode.SelectedValue);
carData.Header = header.Text;
carData.Number = number.Text;
carData.CarType = carType.SelectedValue;
if (reject.Checked == true)
{
carData.Reject = 1;
}
else
{
carData.Reject = 0;
}
carData.RejectContent = rejectContent.Text;
carData.CompanyName = companyName.Text;
if (!String.IsNullOrEmpty(companyCode.Value))
{
carData.CompanyCode = Convert.ToInt32(companyCode.Value);
}
//int carCode; // 차량코드 car code
// 수정하기 sửa
if (mode.Value.Equals("modify"))
{
carData.CarCode = Convert.ToInt32(Request.QueryString["code"]);
int result = bll.updateCarData(carData);
carCode = Convert.ToInt32(Request.QueryString["code"]);
// 이전에 등록된 운전자 정보 삭제 xóa thông tin lái xe được đăng ký trước đó
List <CarHandlerInfo> list = bll.selectCarHandlerList(carCode.ToString());
for (int i = 0; i < list.Count; i++)
{
//int resultDel = bll.deleteCarHandler((CarHandlerInfo)list[i]);
}
reqHandlerName = Request["handlerName"];
arrHandlerName = reqHandlerName.Split(',');
reqPhone = Request["phone"];
arrPhone = reqPhone.Split(',');
for (int i = 0; i < arrHandlerName.Length; i++)
{
CarHandlerInfo carHandler = new CarHandlerInfo();
if (!String.IsNullOrEmpty(arrHandlerName[i]))
{
carHandler.CarCode = carCode;
carHandler.Handler = arrHandlerName[i];
carHandler.Phone = arrPhone[i];
}
bll.insertCarHandler(carHandler);
}
Response.Redirect("carDataList.aspx");
}
// 등록하기 đăng ký
else
{
//if (bll.existsCarData(carData.Number))
//{
// Page.RegisterStartupScript("alertMsg", JavaScriptBuilder.alert(number.Text + " 는 이미 등록된 차량 번호 입니다."));
//}
if (bll.existsCarData(carData.Header, carData.Number, carData.CompanyCode))
{
Page.RegisterStartupScript("alertMsg", JavaScriptBuilder.alert(header.Text + number.Text + "là số xe đã được đăng ký (는 이미 등록된 차량 번호 입니다)."));
}
else
{
if (!String.IsNullOrEmpty(carData.Header) && !String.IsNullOrEmpty(carData.Number))
{
if (!String.IsNullOrEmpty(carData.CompanyName))
{
int result = bll.insertCarData(carData);
carCode = bll.selectMaxCarCode();
reqHandlerName = Request["handlerName"];
arrHandlerName = reqHandlerName.Split(',');
reqPhone = Request["phone"];
arrPhone = reqPhone.Split(',');
for (int i = 0; i < arrHandlerName.Length; i++)
{
CarHandlerInfo carHandler = new CarHandlerInfo();
if (!String.IsNullOrEmpty(arrHandlerName[i]))
{
carHandler.CarCode = carCode;
carHandler.Handler = arrHandlerName[i];
carHandler.Phone = arrPhone[i];
}
bll.insertCarHandler(carHandler);
}
Response.Redirect("carDataList.aspx");
}
else
{
Page.RegisterStartupScript("alertMsg", JavaScriptBuilder.alert("Hãy nhập tên công ty (회사명을 입력하여 주세요)."));
}
}
else
{
Page.RegisterStartupScript("alertMsg", JavaScriptBuilder.alert("Hãy nhập số xe (차량번호를 입력하여 주세요)."));
}
}
}
}
else
{
if (Request.QueryString["mode"].Equals("modify"))
{
CarDataInfo carData = bll.getCarData(Request.QueryString["type"], Convert.ToInt32(Request.QueryString["code"]));
carCategoryCode.SelectedValue = carData.CarCategoryCode.ToString();
header.Text = carData.Header;
number.Text = carData.Number;
carType.SelectedValue = carData.CarType;
companyName.Text = carData.CompanyName;
companyCode.Value = carData.CompanyCode.ToString();
if (carData.Reject == 1)
{
reject.Checked = true;
}
else
{
reject.Checked = false;
}
rejectContent.Text = carData.RejectContent;
lableCodeName.Text = carData.Header + "" + carData.Number + "sửa thông tin (정보 수정하기)";
mode.Value = Request.QueryString["mode"];
List <CarHandlerInfo> carhandlerList = bll.selectCarHandlerList(carData.CarCode.ToString());
for (int i = 0; i < carhandlerList.Count; i++)
{
CarHandlerInfo subhandler = (CarHandlerInfo)carhandlerList[i];
arryCarHandlerList += "carHandlerCode[" + i + "]='" + subhandler.CarHandlerCode + "';\n";
arryCarHandlerList += "handler[" + i + "]='" + subhandler.Handler + "';\n";
arryCarHandlerList += "handlerPhone[" + i + "]='" + subhandler.Phone + "';\n";
}
displayCellCount = carhandlerList.Count.ToString();
}
else
{
lableCodeName.Text = "Đăng Ký Xe (차량 등록하기)";
mode.Value = Request.QueryString["mode"];
}
}
}
/// <summary>
/// 차량 목록
/// </summary>
/// <param name="txtKey"></param>
/// <returns></returns>
public List <CarDataInfo> getCarDataList(String type, String txtKey)
{
log.Debug("=================START getCarDataList=================");
log.Debug("txtKey = " + txtKey);
List <CarDataInfo> list = new List <CarDataInfo>();
StringBuilder SQL_SELECT_CAR_DATA_LIST = new StringBuilder();
if (type.Equals("car"))
{
SQL_SELECT_CAR_DATA_LIST.Append(@"
SELECT a.carCode,
a.carCategoryCode,
a.header,
a.number,
a.carType,
a.companyName,
'' as handler,
'' as handlerPhone,
a.reject,
isnull(a.rejectContent,' ') as rejectContent,
a.regDate,
b.codeName,
0 as carHandlerCode,
a.companyCode
FROM CarData a,
CarCategory b
WHERE a.carCategoryCode=b.carCategoryCode
AND a.companyCode IS NOT NULL");
}
else
{
SQL_SELECT_CAR_DATA_LIST.Append(@"
SELECT a.carCode,
a.carCategoryCode,
a.header,
a.number,
a.carType,
a.companyName,
ISNULL(c.handler,' ') as handler,
c.handlerPhone,
a.reject,
isnull(a.rejectContent,' ') as rejectContent,
a.regDate,
b.codeName,
c.carHandlerCode,
a.companyCode
FROM CarData a,
CarCategory b,
CarHandler c
WHERE a.carCategoryCode=b.carCategoryCode
AND a.carCode=c.carCode " );
}
if (!String.IsNullOrEmpty(txtKey) && type.Equals("car"))
{
SQL_SELECT_CAR_DATA_LIST.Append(" AND a.number LIKE '" + txtKey + "%' ");
}
else if (!String.IsNullOrEmpty(txtKey))
{
SQL_SELECT_CAR_DATA_LIST.Append(" AND a.number+c.handler LIKE '%" + txtKey + "%' ");
}
SQL_SELECT_CAR_DATA_LIST.Append(" ORDER BY a.carCode DESC");
//Execute the query against the database
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_CAR_DATA_LIST.ToString(), null))
{
// Scroll through the results
while (rdr.Read())
{
CarDataInfo obj = new CarDataInfo();
obj = bindCarDataInfo(rdr, obj);
//Add each item to the arraylist
list.Add(obj);
}
}
log.Debug("=================END getCarDataList=================");
return(list);
}
private CarDataInfo bindCarDataInfo(SqlDataReader rdr, CarDataInfo obj)
{
obj.CarhandlerInfoList = new List <CarHandlerInfo>();
obj.CarhandlerInfoList.Add(new CarHandlerInfo());
obj.CarCode = rdr.GetInt32(0);
obj.CarCategoryCode = rdr.GetInt16(1);
if (rdr.IsDBNull(2))
{
obj.Header = null;
}
else
{
obj.Header = rdr.GetString(2);
}
obj.Number = rdr.GetString(3);
obj.CarType = rdr.GetInt32(4).ToString();
if (rdr.IsDBNull(5))
{
obj.CompanyName = null;
}
else
{
obj.CompanyName = rdr.GetString(5);
}
if (rdr.IsDBNull(6))
{
obj.CarhandlerInfoList[0].Handler = null;
}
else
{
obj.CarhandlerInfoList[0].Handler = rdr.GetString(6);
}
if (rdr.IsDBNull(7))
{
obj.CarhandlerInfoList[0].Phone = null;
}
else
{
obj.CarhandlerInfoList[0].Phone = rdr.GetString(7);
}
obj.Reject = rdr.GetByte(8);
obj.RejectContent = rdr.GetString(9);
obj.RegDate = rdr.GetDateTime(10);
obj.CodeName = rdr.GetString(11);
obj.CarhandlerInfoList[0].CarHandlerCode = rdr.GetInt32(12);
if (rdr.IsDBNull(13))
{
obj.CompanyCode = 0;
}
else
{
obj.CompanyCode = rdr.GetInt32(13);
}
return(obj);
}
/// <summary>
/// 차량 수정
/// </summary>
/// <param name="carData"></param>
/// <returns></returns>
public int updateCarData(CarDataInfo carData)
{
return(dal.updateCarData(carData));
}
/// <summary>
/// 2010-05-19-임종우 : 차량 header 수정 추가
/// </summary>
/// <param name="header"></param>
/// <returns></returns>
public int updateCarData_header(CarDataInfo carData)
{
return(dal.updateCarData_header(carData));
}
protected void Page_Load(object sender, EventArgs e)
{
// 관리자 체크 check người quản lý
EmployeeInfo loginEmployee = new EmployeeInfo();
loginEmployee = (EmployeeInfo)Session["loginMember"];
if (loginEmployee == null)
{
Response.Redirect("~/login.aspx", true);
}
if (loginEmployee.ManagerLevel < 2)
{
Response.Redirect("~/login.aspx", true);
}
#region control Add Attribute
number.Attributes.Add("onblur", "numCheck();");
#endregion
if (Page.IsPostBack)
{
// 객체 생성 creat object
CarDataInfo carData = new CarDataInfo();
carData.CarCategoryCode = Convert.ToInt32(carCategoryCode.SelectedValue);
carData.Header = header.Text;
carData.Number = number.Text;
carData.CarType = carType.SelectedValue;
if (reject.Checked == true)
{
carData.Reject = 1;
}
else
{
carData.Reject = 0;
}
carData.RejectContent = rejectContent.Text;
carData.CompanyName = companyName.Text;
if (!String.IsNullOrEmpty(companyCode.Value))
{
carData.CompanyCode = Convert.ToInt32(companyCode.Value);
}
//int carCode; // 차량코드 car code
// 수정하기 sửa
if (mode.Value.Equals("modify"))
{
carData.CarCode = Convert.ToInt32(Request.QueryString["code"]);
int result = bll.updateCarData(carData);
Response.Redirect("carDataList.aspx");
}
// 등록하기 đăng ký
else
{
if (bll.existsCarData(carData.Header, carData.Number, carData.CompanyCode))
{
Page.RegisterStartupScript("alertMsg", JavaScriptBuilder.alert(number.Text + " là số xe đã được đăng ký (는 이미 등록된 차량 번호 입니다)."));
}
//if (bll.existsCarData(carData.Header, carData.Number))
//{
// Page.RegisterStartupScript("alertMsg", JavaScriptBuilder.alert(header.Text + number.Text + " 는 이미 등록된 차량 번호 입니다."));
//}
else
{
int result = bll.insertCarData(carData);
carCode = bll.selectMaxCarCode();
reqHandlerName = Request["handlerName"];
arrHandlerName = reqHandlerName.Split(',');
reqPhone = Request["phone"];
arrPhone = reqPhone.Split(',');
for (int i = 0; i < arrHandlerName.Length; i++)
{
CarHandlerInfo carHandler = new CarHandlerInfo();
if (!String.IsNullOrEmpty(arrHandlerName[i]))
{
carHandler.CarCode = carCode;
carHandler.Handler = arrHandlerName[i];
carHandler.Phone = arrPhone[i];
}
bll.insertCarHandler(carHandler);
}
Response.Redirect("carDataList.aspx");
}
}
}
else
{
if (Request.QueryString["mode"].Equals("modify"))
{
CarDataInfo carData = bll.getCarData(Request.QueryString["type"], Convert.ToInt32(Request.QueryString["code"]));
carCode = Convert.ToInt32(Request.QueryString["code"]);
carCategoryCode.SelectedValue = carData.CarCategoryCode.ToString();
header.Text = carData.Header;
number.Text = carData.Number;
carType.SelectedValue = carData.CarType;
companyName.Text = carData.CompanyName;
companyCode.Value = carData.CompanyCode.ToString();
if (carData.Reject == 1)
{
reject.Checked = true;
}
else
{
reject.Checked = false;
}
rejectContent.Text = carData.RejectContent;
lableCodeName.Text = " Sửa thông tin (정보 수정하기) : " + carData.Header + " " + carData.Number;
mode.Value = Request.QueryString["mode"];
;
}
else
{
lableCodeName.Text = "Đăng ký xe (차량 등록하기)";
mode.Value = Request.QueryString["mode"];
}
}
}
