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"]; } } }