protected void Button1_Click(object sender, EventArgs e)
{
CarHandlerInfo carHandlerInfo = new CarHandlerInfo();
carHandlerInfo.CarCode = Convert.ToInt32(Request.QueryString["carCode"]);
carHandlerInfo.Handler = txthandler.Text;
carHandlerInfo.Phone = txtphone.Text;
bll.insertCarHandler(carHandlerInfo);
Response.Redirect("carHandlerList.aspx?carCode=" + carHandlerInfo.CarCode);
}
/// <summary>
/// 운전자 삭제
/// </summary>
/// <param name="carCode"></param>
/// <returns></returns>
public int deleteCarHandler(CarHandlerInfo carHandler)
{
log.Debug("=================START deleteCarhandler=================");
log.Debug("carHandler = " + carHandler.ToString());
StringBuilder sql = new StringBuilder();
sql.Append(@"DELETE FROM CarHandler WHERE carHandlerCode=" + carHandler.CarHandlerCode);
int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql.ToString(), null);
return(result);
log.Debug("=================END deleteCarhandler=================");
}
/// <summary>
/// 2011-02-15-김민우: 입문 처리 시 운전자 전화번호 정보 수정
/// </summary>
/// <param name="carHandler"></param>
/// <returns></returns>
public int updateCarHandlerPhone(CarHandlerInfo carHandler)
{
log.Debug("=================START updateCarHandlerPhone=================");
StringBuilder sql = new StringBuilder();
sql.Append(@"UPDATE CarHandler SET handlerPhone='" + carHandler.Phone + @"'
WHERE carHandlerCode= " + carHandler.CarHandlerCode);
//AND handler = '" + carHandler.Handler+ @"'");
int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql.ToString(), null);
return(result);
log.Debug("=================END updateCarHandlerPhone=================");
}
/// <summary>
/// 운전자 등록
/// </summary>
/// <param name="carHandler"></param>
/// <returns></returns>
public int insertCarHandler(CarHandlerInfo carHandler)
{
log.Debug("=================START insertCarHandler=================");
log.Debug("carHandler = " + carHandler.ToString());
String sql_insert = "INSERT INTO CarHandler (carCode,handler,handlerPhone,regDate,VisFlag)";
sql_insert += "VALUES";
sql_insert += "(" + carHandler.CarCode + ",N'" + carHandler.Handler + "','" + carHandler.Phone + "',GETDATE(),'Y')";
int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql_insert, null);
return(result);
log.Debug("=================END insertCarHandler=================");
}
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;
//}
}
}
}
/// <summary>
/// 승인된 운전자 리스트 가져오기
/// </summary>
/// <param name="carCode"></param>
/// <returns></returns>
public List <CarHandlerInfo> selectPermitCarHandlerList(string carCode)
{
log.Debug("=================START selectPermitCarHandlerList=================");
log.Debug("carCode = " + carCode.ToString());
List <CarHandlerInfo> list = new List <CarHandlerInfo>();
StringBuilder sql = new StringBuilder();
sql.Append(@"
SELECT carHandlerCode,
carCode,
handler,
handlerPhone,
regDate,
VisFlag
FROM CarHandler
WHERE carCode=" + carCode + @"
AND VisFlag = 'Y'
ORDER BY handler
");
//Execute the query against the database
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql.ToString(), null))
{
while (rdr.Read())
{
// Scroll through the results
CarHandlerInfo obj = new CarHandlerInfo();
obj = bindCarHandlerInfo(rdr, obj);
//Add each item to the arraylist
list.Add(obj);
}
}
return(list);
log.Debug("=================END selectPermitCarHandlerList=================");
}
private CarHandlerInfo bindCarHandlerInfo(SqlDataReader rdr, CarHandlerInfo obj)
{
obj.CarHandlerCode = rdr.GetInt32(0);
obj.CarCode = rdr.GetInt32(1);
if (rdr.IsDBNull(2))
{
obj.Handler = null;
}
else
{
obj.Handler = rdr.GetString(2);
}
if (rdr.IsDBNull(3))
{
obj.Phone = null;
}
else
{
obj.Phone = rdr.GetString(3);
}
obj.RegDate = rdr.GetDateTime(4);
if (rdr.IsDBNull(5))
{
obj.VisFlag = null;
}
else
{
obj.VisFlag = rdr.GetString(5);
}
return(obj);
}
/// <summary>
/// 운전자 삭제
/// </summary>
/// <param name="carHandlerInfo"></param>
/// <returns></returns>
public int deleteCarHandler(CarHandlerInfo carHandler)
{
return(dal.deleteCarHandler(carHandler));
}
/// <summary>
/// 2011-02-15-김민우: 입문 처리 시 운전자 전화번호 정보 수정
/// </summary>
/// <param name="carHandler"></param>
/// <returns></returns>
public int updateCarHandlerPhone(CarHandlerInfo carHandler)
{
return(dal.updateCarHandlerPhone(carHandler));
}
/// <summary>
/// 운전자 등록
/// </summary>
/// <param name="carHandler"></param>
/// <returns></returns>
public int insertCarHandler(CarHandlerInfo carHandler)
{
return(dal.insertCarHandler(carHandler));
}
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)
{
// 관리자 체크 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"];
}
}
}
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"];
}
}
}
