public JObject GetInfo(dynamic in_data) { try { JObject data = JObject.Parse(in_data.ToString()); string id = data["id"].ToString(); string option = data["option"].ToString(); if (id == "" || option == "") { return(SendData(400, "请求错误")); } JObject car_json = null; switch (option) { case "0": //用户id car_json = CarDAL.GetInfo(id); break; case "1": //订单id JObject or_json = OrderDAL.GetInfo(id); car_json = CarDAL.GetInfo(or_json["us_id"].ToString()); break; default: return(SendData(400, "请求错误")); } return(SendData(200, data: car_json)); } catch (Exception e) { return(SendData(400, "请求错误")); } }
private void cbbCarName_SelectionChanged(object sender, SelectionChangedEventArgs e) { DataTable listCar = new CarDAL().GetComboBoxCarModel(cbbCarName.SelectedValue.ToString()); cbbCarModel.ItemsSource = listCar.DefaultView; cbbCarEngine.ItemsSource = null; }
public JObject Apply(dynamic in_data) { try { JObject data = JObject.Parse(in_data.ToString()); string carname = data["carname"].ToString(); string caridcard = data["caridcard"].ToString(); string capacity = data["capacity"].ToString(); string cartype = data["cartype"].ToString(); string us_id = data["CarpoolSSID"]?.ToString(); if (us_id == null || Session["CarpoolSSID"].ToString() != us_id) { return(SendData(15001, "未授权访问")); } if (CarDAL.Exist(caridcard)) { return(SendData(17001, "车牌号码已被注册")); } if (!CarDAL.Apply(us_id, carname, caridcard, capacity, cartype)) { return(SendData(20000, "服务错误")); } return(SendData(200)); } catch (Exception e) { return(SendData(400, "请求错误", e.ToString())); } }
protected void btnSearch_Click1(object sender, EventArgs e) { CarDAL carDAL = new CarDAL(); // gvCar.DataSource = carDAL.ReadByMakeId(Convert.ToInt16(ddMake.SelectedItem.Value)); int makeId = 0, modelId = 0; if (ddMake.SelectedItem.Value != "") { makeId = Convert.ToInt16(ddMake.SelectedItem.Value); } if (ddModel.SelectedItem.Value != "") { modelId = Convert.ToInt16(ddModel.SelectedItem.Value); } if (makeId > 0) { gvCar.DataSource = carDAL.ReadByMakeId(Convert.ToInt16(ddMake.SelectedItem.Value)); } if (modelId > 0 && makeId > 0) { gvCar.DataSource = carDAL.SearchCar(makeId, modelId); } gvCar.DataBind(); btnAddGarage.Visible = true; }
private void ReloadData() { try { DataTable listMember = new CarDAL().GetAll(); grdCar.ItemsSource = listMember.DefaultView; DataCommon.Set("LIST_CAR", listMember); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void cbbCarModel_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { if (cbbCarName.SelectedValue != null && cbbCarModel.SelectedValue != null) { DataTable listCar = new CarDAL().GetComboBoxCarEngine(cbbCarName.SelectedValue.ToString(), cbbCarModel.SelectedValue.ToString()); cbbCarEngine.ItemsSource = listCar.DefaultView; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
public JObject Menu_user_info(dynamic in_data) { try { JObject data = JObject.Parse(in_data?.ToString()); string us_id = data["CarpoolSSID"]?.ToString(); if (us_id == null || Session["CarpoolSSID"]?.ToString() != us_id) { return(SendData(15001, "未授权访问")); } JObject us_json = UserDAL.GetInfo(us_id); JObject car_json = CarDAL.GetInfo(us_id); int or_processing_cnt = OrderDAL.GetProcessingCount(us_id); int or_all_cnt = OrderDAL.GetAllCount(us_id); int or_completed_cnt = OrderDAL.GetCompletedCount(us_id); JArray nt_Unprocessed = NoticeDAL.GetUnprocessed(us_id); JObject d_us = new JObject(); d_us.Add("us_id", us_id); d_us.Add("tel", us_json["tel"]); d_us.Add("name", us_json["name"]); d_us.Add("headportrait", us_json["headportrait"]); JObject d_car = new JObject(); d_car.Add("car_name", car_json == null ? null : car_json["car_name"]); d_car.Add("car_idcard", car_json == null ? null : car_json["car_idcard"]); JObject d_or = new JObject(); d_or.Add("processing_count", or_processing_cnt); d_or.Add("all_count", or_all_cnt); d_or.Add("completed_count", or_completed_cnt); JObject d_nt = new JObject(); d_nt.Add("unprocessed_count", nt_Unprocessed.Count); JObject ret_json = new JObject(); ret_json.Add("user", d_us); ret_json.Add("car", d_car); ret_json.Add("order", d_or); ret_json.Add("notice", d_nt); return(SendData(200, data: ret_json)); } catch (Exception e) { return(SendData(400, "请求错误")); } }
public PopupInsureCar() { try { InitializeComponent(); DataTable listCar = new CarDAL().GetComboBoxCarName(); cbbCarName.ItemsSource = listCar.DefaultView; DataTable listCompany = new InsureCompanyDAL().GetComboBoxCompanyName(); cbbCompany.ItemsSource = listCompany.DefaultView; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void Reset_MouseLeftButtonDown(object sender, MouseButtonEventArgs e) { try { cbbCarName.ItemsSource = null; DataTable listCar = new CarDAL().GetComboBoxCarName(); cbbCarName.ItemsSource = listCar.DefaultView; cbbCarModel.ItemsSource = null; cbbCarEngine.ItemsSource = null; cbbCarYear.SelectedIndex = 0; cbbStatus.SelectedIndex = 0; ReloadData(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void Button_Click(object sender, RoutedEventArgs e) { try { int index = grdCar.SelectedIndex; string carCode = ((DataRowView)grdCar.SelectedItem).Row.ItemArray[0].ToString(); string carName = ((DataRowView)grdCar.SelectedItem).Row.ItemArray[1].ToString(); string carModel = ((DataRowView)grdCar.SelectedItem).Row.ItemArray[2].ToString(); string carEngine = ((DataRowView)grdCar.SelectedItem).Row.ItemArray[3].ToString(); CarData carItem = new CarDAL().GetItemCode(carCode, carName, carModel, carEngine); DataCommon.Set("CAR_EDIT", carItem); PopupCar pop = new PopupCar(); pop.ShowDialog(); ReloadData(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
public InsureCarPage() { try { InitializeComponent(); DataTable listCar = new CarDAL().GetComboBoxCarName(); cbbCarName.ItemsSource = listCar.DefaultView; MemberData member = (MemberData)DataCommon.Get("DATA.MEMBER"); if (!member.ROLE_CODE.ToUpper().Equals("ADMIN")) { btnImport.Visibility = System.Windows.Visibility.Hidden; btnAdd.Visibility = System.Windows.Visibility.Hidden; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
protected void btnAddGarage_Click(object sender, EventArgs e) { foreach (GridViewRow row in gvCar.Rows) { CheckBox cb = (CheckBox)row.FindControl("chkSel"); if (cb.Checked) { GarageDAL garageDAL = new GarageDAL(); CarDAL carkDAL = new CarDAL(); int makeID = Convert.ToInt16(row.Cells[0].Text); int modelID = Convert.ToInt16(row.Cells[1].Text); int carId = garageDAL.GetCarId(makeID, modelID); garageDAL.AddToGarage(Convert.ToInt16(Session["MemberId"]), carId); //@TODO add userID lblStatus.Text = "Added to Garage Successfully"; } } }
protected void btnSave_Click(object sender, EventArgs e) { int make = Convert.ToInt16(ddMake.SelectedItem.Value); int model = Convert.ToInt16(ddModel.SelectedItem.Value); int year = Convert.ToInt32(txtYear.Text); double price = Convert.ToDouble(txtPrice.Text); double mileage = Convert.ToDouble(txtMileage.Text); string photoUrl = ""; if (FileUpload1.HasFile) { FileUpload1.SaveAs(MapPath("../images") + @"\" + FileUpload1.FileName); } photoUrl = FileUpload1.FileName.ToString(); Car car = new Car(make, model, year, price, mileage, "images/" + photoUrl); CarDAL carDAL = new CarDAL(); carDAL.Add(car); lblStatus.Text = "Saved"; }
public JObject GetOrderDetails(dynamic in_data) { try { JObject data = JObject.Parse(in_data.ToString()); string or_id = data["or_id"]?.ToString(); if (or_id == null || or_id == "") { return(SendData(400, "请求错误")); } JObject od_json = OrderDAL.GetInfo(or_id); JObject ods_json = OrderDAL.GetOrderDetailsInfo(or_id, od_json["us_id"].ToString()); int applyedcount = OrderDAL.GetApplyedCount(or_id); int applyingcount = OrderDAL.GetApplyingCount(or_id); JObject apply_json = new JObject(); apply_json.Add("applyingcount", applyingcount); apply_json.Add("applyedcount", applyedcount); JObject car_json = CarDAL.GetInfo(od_json["us_id"].ToString()); JObject us_json = UserDAL.GetInfo(od_json["us_id"].ToString()); JObject rt_us_json = new JObject(); rt_us_json.Add("tel", us_json["tel"]); rt_us_json.Add("name", us_json["name"]); JObject ret_data = new JObject(); ret_data.Add("order", od_json); ret_data.Add("orderdetails", ods_json); ret_data.Add("applycount", apply_json); ret_data.Add("car", car_json); ret_data.Add("userinfo", rt_us_json); return(SendData(200, data: ret_data)); } catch (Exception e) { return(SendData(400, "请求错误")); } }
private void btnStart_Click(object sender, RoutedEventArgs e) { try { //WaitProcess wp = new WaitProcess(); //wp.ShowDialog(); carDal = new CarDAL(); comDal = new InsureCompanyDAL(); insureDal = new InsureCarDAL(); List <InsureCarData> listItem = ReadExcel(txtPath.Text); DataCommon.Set("ListInsureCarData", listItem); ProcessDatabase(); btnClose.IsEnabled = true; btnSelect.IsEnabled = true; //wp.Close(); MessageBox.Show("นำเข้าข้อมูลเรียนร้อย"); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
public PopupInsureCar(string mode) { try { InitializeComponent(); InsureCarData item = (InsureCarData)DataCommon.Get("INSURE_CAR_EDIT"); txtAssetTime.Text = item.ASSET_TIME.ToString(); txtCapitalInsure.Text = item.CAPITAL_INSURANCE.ToString(); txtCoveragePeople.Text = item.LIVE_COVERAGE_PEOPLE.ToString(); txtCoverageTime.Text = item.LIVE_COVERAGE_TIME.ToString(); txtDamageCar.Text = item.DAMAGE_TO_VEHICLE.ToString(); txtFirstDamage.Text = item.FIRST_DAMAGE_PRICE.ToString(); txtInsureDriver.Text = item.DRIVER_INSURANCE_AMT.ToString(); txtMEDICAL_FEE_AMT.Text = item.MEDICAL_FEE_AMT.ToString(); txtMEDICAL_FEE_PEOPLE.Text = item.MEDICAL_FEE_PEOPLE.ToString(); txtMissingCar.Text = item.MISSING_FIRE_CAR.ToString(); txtNetPrice.Text = item.NET_PRICE.ToString(); txtPackage.Text = item.PACKAGE_NAME; txtPERSONAL_ACCIDENT_AMT.Text = item.PERSONAL_ACCIDENT_AMT.ToString(); txtPERSONAL_ACCIDENT_PEOPLE.Text = item.PERSONAL_ACCIDENT_PEOPLE.ToString(); txtPriolity.Text = item.INSURE_PRIORITY.ToString(); txtRoundPrice.Text = item.PRICE_ROUND.ToString(); txtTotalPrice.Text = item.TOTAL_PRICE.ToString(); txtEff.Text = item.EFFECTIVE_DATE.ToShortDateString(); txtExp.Text = item.EXPIRE_DATE.ToShortDateString(); cbbCarYear.SelectedValue = item.CAR_YEAR.ToString(); DataTable listCar = new CarDAL().GetComboBoxCarName(); cbbCarName.ItemsSource = listCar.DefaultView; cbbCarName.Text = item.CAR_NAME.ToString(); DataTable listCarModel = new CarDAL().GetComboBoxCarModel(item.CAR_NAME); cbbCarModel.ItemsSource = listCarModel.DefaultView; cbbCarModel.Text = item.CAR_MODEL.ToString(); DataTable listCarEngine = new CarDAL().GetComboBoxCarEngine(item.CAR_NAME, item.CAR_MODEL); cbbCarEngine.ItemsSource = listCarEngine.DefaultView; cbbCarEngine.Text = item.CAR_ENGINE.ToString(); DataTable listCompany = new InsureCompanyDAL().GetComboBoxCompanyName(); cbbCompany.ItemsSource = listCompany.DefaultView; cbbCompany.Text = item.COMPANY_FULLNAME; cbbConfident.SelectedValue = item.CONFIDENTIAL_STATUS == "S" ? "Show" : "Hidden"; cbbInsureCat.SelectedValue = item.INSURE_CATEGORY.ToString(); cbbTypeRepair.SelectedValue = item.INSURE_TYPE_REPAIR.ToString(); if (mode == "VIEW") { txtAssetTime.IsEnabled = false; txtCapitalInsure.IsEnabled = false; txtCoveragePeople.IsEnabled = false; txtCoverageTime.IsEnabled = false; txtDamageCar.IsEnabled = false; txtFirstDamage.IsEnabled = false; txtInsureDriver.IsEnabled = false; txtMEDICAL_FEE_AMT.IsEnabled = false; txtMEDICAL_FEE_PEOPLE.IsEnabled = false; txtMissingCar.IsEnabled = false; txtNetPrice.IsEnabled = false; txtPackage.IsEnabled = false; txtPERSONAL_ACCIDENT_AMT.IsEnabled = false; txtPERSONAL_ACCIDENT_PEOPLE.IsEnabled = false; txtPriolity.IsEnabled = false; txtRoundPrice.IsEnabled = false; txtTotalPrice.IsEnabled = false; txtEff.IsEnabled = false; txtExp.IsEnabled = false; cbbCarYear.IsEnabled = false; cbbCarName.IsEnabled = false; cbbCarModel.IsEnabled = false; cbbCarEngine.IsEnabled = false; cbbCompany.IsEnabled = false; cbbConfident.IsEnabled = false; cbbInsureCat.IsEnabled = false; cbbTypeRepair.IsEnabled = false; cbbStatus.IsEnabled = false; btnSave.Visibility = System.Windows.Visibility.Hidden; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
public HomeController() { _DAL = new CarDAL(); }
public CarBLL(string connectionString) { data = new CarDAL(connectionString); }
private void btnCheck_Click(object sender, EventArgs e) { try { CheckProperties.ce.SapChengPinTable = null; CheckProperties.ce.SapChengPinTable2 = null; CheckMethod.listMessage.Clear(); CommonalityEntity.yxincheck = false;//是否系统自动进门授权 SerialNumber = txtNumber.Text.Trim(); if (string.IsNullOrEmpty(SerialNumber)) { MessageBox.Show(this, "小票号(IC卡)不能为空"); return; } string strsql = ""; if (SerialNumber.Length >= 12) { strsql = "select top 1 * from View_CarState where SmallTicket_Serialnumber= '" + SerialNumber + "' order by SmallTicket_ID desc"; } if (SerialNumber.Length == 9) { strsql = "select top 1 * from View_CarState where SmallTicket_ICCard_ID in( select ICCard_ID from ICCard where ICCard_Value ='" + SerialNumber + "') order by SmallTicket_ID desc"; ICValue = SerialNumber; } if (string.IsNullOrEmpty(strsql)) { MessageBox.Show("小票号(IC卡)无效!"); return; } dtviewcarstate = LinQBaseDao.Query(strsql).Tables[0]; if (dtviewcarstate.Rows.Count > 0) { if (!ISfull()) { return; } } else { MessageBox.Show("小票号(IC卡)无效!"); return; } string Strategy_DriSName = "";//通行策略名称 CommonalityEntity.IsUpdatedri = false; //查询车辆类型的通行策略 DataTable DrivewayStrategy_IDDT = LinQBaseDao.Query("select DrivewayStrategy_ID,DrivewayStrategy_Sort ,DrivewayStrategy_Name,DrivewayStrategy_Driveway_ID from DrivewayStrategy where DrivewayStrategy_State='启动' and DrivewayStrategy_Name in (select CarType_DriSName from CarType where CarType_Name='" + cmbCarType.Text + "') order by DrivewayStrategy_Sort ").Tables[0]; if (DrivewayStrategy_IDDT.Rows.Count <= 0) { MessageBox.Show("该车辆没有配通行策略!", "提示"); return; } Strategy_DriSName = DrivewayStrategy_IDDT.Rows[0][2].ToString(); CommonalityEntity.Driveway_ID = Convert.ToInt32(DrivewayStrategy_IDDT.Rows[0]["DrivewayStrategy_Driveway_ID"].ToString()); DataTable dtption = LinQBaseDao.Query("select Driveway_Value,Position_ID,Position_Value,Position_State from View_DrivewayPosition where Driveway_ID=" + CommonalityEntity.Driveway_ID).Tables[0]; if (dtption.Rows.Count > 0) { if (dtption.Rows[0]["Position_State"].ToString() != "启动") { MessageBox.Show(this, "通行门岗状态已暂停和注销!"); return; } CommonalityEntity.Driveway_Value = dtption.Rows[0]["Driveway_Value"].ToString(); CommonalityEntity.Position_ID = Convert.ToInt32(dtption.Rows[0]["Position_ID"].ToString()); CommonalityEntity.Position_Value = dtption.Rows[0]["Position_Value"].ToString(); } else { MessageBox.Show(this, "门岗通道不存在,请检查!"); return; } string carname = dtviewcarstate.Rows[0]["CarInfo_Name"].ToString(); CheckProperties.ce.CarInfo_ID = Convert.ToInt32(dtviewcarstate.Rows[0]["CarInfo_ID"].ToString()); CheckProperties.ce.ChengPinNumber = carname; CheckProperties.ce.carInfo_Name = carname; if (ChkRepeat(carname)) { MessageBox.Show("不能重复登记该车辆!"); return; } string crSql = "select * from CarType where CarType_Name='" + cmbCarType.Text + "'"; CheckProperties.ce.IsPhoto = false; CheckProperties.ce.levelIsWaste = false; CheckProperties.ce.isSort = false; CheckProperties.ce.ISUpdateCredentials = false; CommonalityEntity.ISYX = false; CheckProperties.ce.IsState = false; CarType cart = LinQBaseDao.GetItemsForListing <CarType>(crSql).FirstOrDefault(); if (cart != null) { CommonalityEntity.Car_Type_ID = cart.CarType_ID.ToString(); CheckProperties.ce.carType_ID = cart.CarType_ID; CheckProperties.ce.CarTypeKey = cart.CarType_ID.ToString(); CommonalityEntity.CarType[cart.CarType_ID.ToString()] = cart.CarType_Name; CheckProperties.ce.carType_Value = cart.CarType_Value; CheckProperties.ce.CarType_Name = cart.CarType_Name; } #region 执行登记管控 //根据车辆类型,获取车辆类型的管控策略(登记管控) string sql = ""; sql = "select * from ManagementStrategy where ManagementStrategy_DriSName='" + Strategy_DriSName + "' and ManagementStrategy_Menu_ID=1 and ManagementStrategy_State='启动' and ManagementStrategy_Rule in('ChkChengPin', 'ChkSapOflag','ISInCheckSapSave') order by ManagementStrategy_No "; DataTable dtmstra = LinQBaseDao.Query(sql).Tables[0]; if (dtmstra.Rows.Count > 0) { CommonalityEntity.ISlogin = true; } else { CommonalityEntity.ISlogin = false; } if (CommonalityEntity.ISlogin) { sql = "select * from ManagementStrategy where ManagementStrategy_DriSName='" + Strategy_DriSName + "' and ManagementStrategy_Menu_ID=1 and ManagementStrategy_State='启动' order by ManagementStrategy_No "; } else { sql = "select * from ManagementStrategy where ManagementStrategy_DriSName='" + Strategy_DriSName + "' and ManagementStrategy_Menu_ID=1 and ManagementStrategy_State='启动' and ManagementStrategy_Rule not in('ChkChengPin', 'ChkSapOflag','ISInCheckSapSave') order by ManagementStrategy_No "; } try { checkPr.ExecutionMethod(sql);//执行指定车辆类型的管控 } catch { } #endregion //执行结果 if (CheckMethod.listMessage.Count > 0) { foreach (var item in CheckMethod.listMessage) { MessageBox.Show(item); return; } } string carId = ""; Expression <Func <Car, bool> > carFn = n => n.Car_Name == CheckProperties.ce.carInfo_Name; Car car1 = CarDAL.Query(carFn).FirstOrDefault(); if (car1 != null) { carId = car1.Car_ID.ToString(); } #region 车辆信息 carInfo_ID = insertcar(carId); ErroSql.Add("delete carinfo where carinfo_id=" + carInfo_ID); #endregion #region 登记图片信息 DataTable dt = LinQBaseDao.Query("select * from CarPic where CarPic_Type='车辆登记照片' and CarPic_CarInfo_ID=" + CheckProperties.ce.CarInfo_ID).Tables[0]; if (dt.Rows.Count > 0) { string picSql = "Insert into CarPic(CarPic_CarInfo_ID,CarPic_State,CarPic_Add,CarPic_Type,CarPic_Time,CarPic_Match) values(" + carInfo_ID + ",'启动','" + dt.Rows[0]["CarPic_Add"].ToString() + "','车辆登记照片',getdate(),'匹配')"; picSql = picSql + " select @@identity"; string picid = LinQBaseDao.GetSingle(picSql).ToString();//得到当前的图片编号 ErroSql.Add("delete CarPic where CarPic_ID=" + picid); } #endregion #region 进出凭证信息 SerialNumberNEW = CheckProperties.ce.serialNumber; CommonalityEntity.Serialnumber = SerialNumberNEW; SmallTicket stk = new SmallTicket(); string icid = "", count = "", hour = ""; if (!string.IsNullOrEmpty(ICValue)) { dt = LinQBaseDao.Query("select * from ICCard where ICCard_Value='" + ICValue + "'").Tables[0]; if (dt.Rows.Count > 0) { string ICCard_EffectiveType = dt.Rows[0]["ICCard_EffectiveType"].ToString(); string ICCard_count = dt.Rows[0]["ICCard_count"].ToString(); string ICCard_HasCount = dt.Rows[0]["ICCard_HasCount"].ToString(); string ICCard_State = dt.Rows[0]["ICCard_State"].ToString(); icid = dt.Rows[0]["ICCard_ID"].ToString(); if (ICCard_EffectiveType == "次数") { int ct = Convert.ToInt32(ICCard_count); int ht = Convert.ToInt32(ICCard_HasCount); if (ct > ht) { count = (ct - ht).ToString(); } else { count = "1"; } } if (ICCard_EffectiveType == "有效期") { DateTime ICCard_BeginTime = Convert.ToDateTime(dt.Rows[0]["ICCard_BeginTime"].ToString()); DateTime ICCard_EndTime = Convert.ToDateTime(dt.Rows[0]["ICCard_EndTime"].ToString()); if (CommonalityEntity.GetServersTime() > ICCard_BeginTime && CommonalityEntity.GetServersTime() < ICCard_EndTime) { TimeSpan th = ICCard_EndTime - CommonalityEntity.GetServersTime(); int s = Convert.ToInt32(th.TotalHours); if (s > 0) { hour = s.ToString(); } else { hour = "1000"; } } } if (ICCard_EffectiveType == "永久") { count = "1"; } } } else { hour = CheckProperties.ce.serTime; count = CheckProperties.ce.serCount; } if (string.IsNullOrEmpty(count)) { stk.SmallTicket_Allowcount = 1; } else { stk.SmallTicket_Allowcount = int.Parse(count); } if (string.IsNullOrEmpty(hour)) { stk.SmallTicket_Allowhour = 0; } else { stk.SmallTicket_Allowhour = int.Parse(hour); } if (CheckProperties.ce.isSort) { //根据当前排队的序号,生成排队号 if (!CommonalityEntity.ISSecondXY) { DataTable dtm = LinQBaseDao.Query("select * from ManagementStrategy where ManagementStrategy_Rule='GetSortNumber' and ManagementStrategy_State='启动' and ManagementStrategy_Menu_ID=1 and ManagementStrategy_DriSName in (select CarType_DriSName from CarType where CarType_ID=" + cmbCarType.SelectedValue + ")").Tables[0]; if (dtm.Rows.Count > 0) { CheckMethod.GetSortNumber(); } string number = CommonalityEntity.SortNumber(CheckProperties.ce.sort_Value); stk.SmallTicket_SortNumber = CommonalityEntity.Position_Value + CheckProperties.ce.carType_Value + number; } else { stk.SmallTicket_SortNumber = ""; } } else { stk.SmallTicket_SortNumber = ""; } stk.SmallTicket_CarInfo_ID = carInfo_ID; if (!string.IsNullOrEmpty(icid)) { stk.SmallTicket_Type = "IC卡"; stk.SmallTicket_ICCard_ID = Convert.ToInt32(icid); } stk.SmallTicket_Position_ID = SystemClass.PositionID; stk.SmallTicket_PrintNumber = ""; stk.SmallTicket_Remark = ""; stk.SmallTicket_State = "有效"; stk.SmallTicket_Time = CommonalityEntity.GetServersTime(); if (SerialNumber.Trim() != "") { DataTable dtm = LinQBaseDao.Query("select * from ManagementStrategy where ManagementStrategy_Rule='ChkSerialNumber' and ManagementStrategy_State='启动' and ManagementStrategy_Menu_ID=1 and ManagementStrategy_DriSName in (select CarType_DriSName from CarType where CarType_ID=" + cmbCarType.SelectedValue + ")").Tables[0]; if (dtm.Rows.Count > 0) { CheckMethod.ChkSerialNumber(); SerialNumberNEW = CheckProperties.ce.serialNumber; } stk.SmallTicket_Type += "小票"; stk.SmallTicket_Serialnumber = SerialNumberNEW.Trim(); } string SmalltSql = ""; if (stk.SmallTicket_ICCard_ID.ToString() != "")//判断IC卡是否输入 { SmalltSql = "insert into SmallTicket values(" + stk.SmallTicket_ICCard_ID + ",'" + stk.SmallTicket_Serialnumber + "'," + stk.SmallTicket_Position_ID + "," + stk.SmallTicket_CarInfo_ID + ",'" + stk.SmallTicket_Time + "','" + stk.SmallTicket_SortNumber + "','" + stk.SmallTicket_PrintNumber + "','" + stk.SmallTicket_State + "','" + stk.SmallTicket_Type + "','" + stk.SmallTicket_Allowcounted + "','" + stk.SmallTicket_Allowcount + "','" + stk.SmallTicket_Allowhour + "','" + stk.SmallTicket_Remark + "')"; } else { SmalltSql = "insert into SmallTicket values(null,'" + stk.SmallTicket_Serialnumber + "'," + stk.SmallTicket_Position_ID + "," + stk.SmallTicket_CarInfo_ID + ",'" + stk.SmallTicket_Time + "','" + stk.SmallTicket_SortNumber + "','" + stk.SmallTicket_PrintNumber + "','" + stk.SmallTicket_State + "','" + stk.SmallTicket_Type + "','" + stk.SmallTicket_Allowcounted + "','" + stk.SmallTicket_Allowcount + "','" + stk.SmallTicket_Allowhour + "','" + stk.SmallTicket_Remark + "')"; } SmalltSql = SmalltSql + " select @@identity"; smallTicket_ID = int.Parse(LinQBaseDao.GetSingle(SmalltSql).ToString());//得到当前的车辆编号 ErroSql.Add("delete SmallTicket where SmallTicket_id=" + smallTicket_ID); #endregion #region 排队信息 SortNumberInfo sort = new SortNumberInfo(); //根据车辆类型 得到该车辆类型的信息 sort.SortNumberInfo_DrivewayValue = CommonalityEntity.Driveway_Value; //门岗值 sort.SortNumberInfo_PositionValue = CommonalityEntity.Position_Value; //车辆类型值 sort.SortNumberInfo_CarTypeValue = CheckProperties.ce.carType_Value; //呼叫次数 sort.SortNumberInfo_CallCount = 0; sort.SortNumberInfo_LEDCount = 0; sort.SortNumberInfo_Operate = CommonalityEntity.USERNAME; //生成原因 sort.SortNumberInfo_Reasons = "登记生成"; sort.SortNumberInfo_Remark = ""; //凭证编号 sort.SortNumberInfo_SmallTicket_ID = smallTicket_ID; sort.SortNumberInfo_SMSCount = 0; if (CheckProperties.ce.isSort) { if (!CommonalityEntity.ISSecondXY) { sort.SortNumberInfo_SortValue = CheckProperties.ce.sort_Value + 1; sort.SortNumberInfo_TongXing = "排队中"; } else { CommonalityEntity.ISSecondXY = false; sort.SortNumberInfo_SortValue = null; sort.SortNumberInfo_TongXing = "待通行"; } } else { sort.SortNumberInfo_SortValue = null; sort.SortNumberInfo_TongXing = "待通行"; } sort.SortNumberInfo_State = "启动"; sort.SortNumberInfo_Type = "系统生成"; sort.SortNumberInfo_Time = CommonalityEntity.GetServersTime(); //添加排队信息 string sort_Sql = "insert into SortNumberInfo values('" + sort.SortNumberInfo_SmallTicket_ID + "','" + sort.SortNumberInfo_Time + "','" + sort.SortNumberInfo_Reasons + "','" + sort.SortNumberInfo_Operate + "','" + sort.SortNumberInfo_Type + "','" + sort.SortNumberInfo_SortValue + "','" + sort.SortNumberInfo_PositionValue + "','" + sort.SortNumberInfo_CarTypeValue + "','" + sort.SortNumberInfo_CallCount + "','" + sort.SortNumberInfo_SMSCount + "','" + sort.SortNumberInfo_LEDCount + "','" + sort.SortNumberInfo_Remark + "','" + sort.SortNumberInfo_TongXing + "','" + sort.SortNumberInfo_DrivewayValue + "','" + sort.SortNumberInfo_State + "','" + sort.SortNumberInfo_CallTime + "','" + sort.SortNumberInfo_Number + "', 1 ,0)"; sort_Sql = sort_Sql + " select @@identity"; sortNumberInfo_ID = int.Parse(LinQBaseDao.GetSingle(sort_Sql).ToString()); ErroSql.Add("delete SortNumberInfo where SortNumberInfo_ID=" + sortNumberInfo_ID);//增删改出错后需要执行的SQL #endregion #region 添加通行总记录 CarInOutRecord cir = new CarInOutRecord(); string strstrategy = ""; bool issort = false; cir.CarInOutRecord_DrivewayStrategy_ID = Convert.ToInt32(DrivewayStrategy_IDDT.Rows[0]["DrivewayStrategy_ID"].ToString()); for (int i = 0; i < DrivewayStrategy_IDDT.Rows.Count; i++) { if (Convert.ToInt32(DrivewayStrategy_IDDT.Rows[i]["DrivewayStrategy_Sort"].ToString()) == 1) { issort = false; strstrategy += DrivewayStrategy_IDDT.Rows[i]["DrivewayStrategy_ID"].ToString() + ","; } else { issort = true; strstrategy += DrivewayStrategy_IDDT.Rows[i]["DrivewayStrategy_ID"].ToString() + ","; } } cir.CarInOutRecord_ISFulfill = false; cir.CarInOutRecord_Abnormal = "正常"; cir.CarInOutRecord_State = "启动"; cir.CarInOutRecord_DrivewayStrategyS = strstrategy.TrimEnd(','); cir.CarInOutRecord_CarInfo_ID = carInfo_ID; cir.CarInOutRecord_Update = false; cir.CarInOutRecord_Driveway_ID = CommonalityEntity.Driveway_ID; if (issort) { cir.CarInOutRecord_Sort = "有序"; } else { cir.CarInOutRecord_Sort = "无序"; } string CarInOutRecordSql = "Insert into CarInOutRecord(CarInOutRecord_CarInfo_ID,CarInOutRecord_DrivewayStrategy_ID,CarInOutRecord_ISFulfill,CarInOutRecord_Time,CarInOutRecord_Abnormal,CarInOutRecord_State,CarInOutRecord_DrivewayStrategyS,CarInOutRecord_Sort,CarInOutRecord_Update,CarInOutRecord_Driveway_ID,CarInOutRecord_InCheck,CarInOutRecord_Remark) values(" + cir.CarInOutRecord_CarInfo_ID + "," + cir.CarInOutRecord_DrivewayStrategy_ID + ",'" + cir.CarInOutRecord_ISFulfill + "',getdate(),'正常','启动','" + cir.CarInOutRecord_DrivewayStrategyS + "','" + cir.CarInOutRecord_Sort + "','" + cir.CarInOutRecord_Update + "'," + cir.CarInOutRecord_Driveway_ID + ",'否','" + Strategy_DriSName + "')"; CarInOutRecordSql = CarInOutRecordSql + " select @@identity"; CarInOutRecord_ID = int.Parse(LinQBaseDao.GetSingle(CarInOutRecordSql).ToString()); ErroSql.Add("delete CarInOutRecord where CarInOutRecord_ID=" + CarInOutRecord_ID); #endregion #region 添加关联表信息 string staid = dtviewcarstate.Rows[0]["StaffInfo_ID"].ToString(); string sfCrSql = "Insert into StaffInfo_CarInfo values(" + staid + "," + smallTicket_ID + ")"; sfCrSql = sfCrSql + " select @@identity"; int sfCrID = int.Parse(LinQBaseDao.GetSingle(sfCrSql).ToString()); ErroSql.Add("delete StaffInfo_CarInfo where StaffInfo_CarInfo_ID=" + sfCrID); #endregion if (CommonalityEntity.yxincheck) { LinQBaseDao.Query("update CarInOutRecord set CarInOutRecord_InCheck='是',CarInOutRecord_InCheckTime=GETDATE(),CarInOutRecord_InCheckUser='******' where CarInOutRecord_ID=" + CarInOutRecord_ID); } #region 判断是否添加成功 if (sortNumberInfo_ID > 0 && smallTicket_ID > 0 && carInfo_ID > 0 && CarInOutRecord_ID != -1) { if (CommonalityEntity.SAP_ID != "" && SerialNumberNEW != "") { LinQBaseDao.Query("update eh_SAPRecord set Sap_Serialnumber=" + SerialNumberNEW + " where Sap_ID=" + CommonalityEntity.SAP_ID); CommonalityEntity.SAP_ID = ""; if (!CommonalityEntity.GetSAP(PNO, "A", carname, SerialNumberNEW, "1")) { MessageBox.Show("成品纸车辆SAP验证未通过!"); return; } } if (CommonalityEntity.SAP_ID != "" && SerialNumberNEW == "" && ICValue != "") { LinQBaseDao.Query("update eh_SAPRecord set Sap_Serialnumber=" + ICValue + " where Sap_ID=" + CommonalityEntity.SAP_ID); CommonalityEntity.SAP_ID = ""; if (!CommonalityEntity.GetSAP(PNO, "A", carname, ICValue, "1")) { MessageBox.Show("成品纸车辆SAP验证未通过!"); return; } } CommonalityEntity.CarInfo_ID = carInfo_ID.ToString(); MessageBox.Show(this, "成品二次排队成功"); CommonalityEntity.WriteLogData("新增", "新增:" + carname + "车辆二次排队", CommonalityEntity.USERNAME);//添加操作日志 if (!string.IsNullOrEmpty(CommonalityEntity.SAP_ID)) { DataTable dtsap = LinQBaseDao.Query("select Sap_InNO,Sap_OutHG,Sap_OutXZ from eh_SAPRecord where Sap_ID=" + CommonalityEntity.SAP_ID).Tables[0]; if (dtsap.Rows.Count > 0) { if (CommonalityEntity.SAP_ID != "" && SerialNumber != "") { LinQBaseDao.Query("update eh_SAPRecord set Sap_Serialnumber=" + SerialNumberNEW + " where Sap_ID=" + CommonalityEntity.SAP_ID); CommonalityEntity.SAP_ID = ""; if (!CommonalityEntity.GetSAP(dtsap.Rows[0]["Sap_InNO"].ToString(), "A", carname, SerialNumberNEW, "1")) { MessageBox.Show("成品车辆SAP验证未通过!"); return; } } } } //获取打印设置 string prtSql = "select top 1 * from PrintInfo where Print_State='启动' and Print_CarType_ID=" + CheckProperties.ce.carType_ID + ""; if (CheckProperties.ce.isSerialNumber) { CheckProperties.ce.isSerialNumber = false; PrintInfo pinfo = PrintInfoDAL.GetPrint(prtSql); if (pinfo.Print_ID > 0) { if (SerialNumberNEW != "") { string prSql = "Select top 1 "; string[] str = pinfo.Print_Content.Split(','); foreach (var item in str) { prSql += item + ","; } prSql = prSql.Substring(0, prSql.Length - 1); prSql += " from View_LEDShow_zj where 小票号='" + SerialNumberNEW + "' and smallTicket_State='有效'"; DataSet ds = LinQBaseDao.Query(prSql); CommonalityEntity.Serialnumber = SerialNumberNEW; PrintInfoForm pi = new PrintInfoForm(ds); pi.Show(); } } else { MessageBox.Show("没有进行打印设置,请设置打印后,重新打印"); return; } } } #endregion } catch { MessageBox.Show("成品二次排队失败!"); CommonalityEntity.WriteTextLog("ProductForm btnCheck_Click()"); try { string sqlstr = ""; for (int i = 0; i < ErroSql.Count; i++) { sqlstr += ErroSql[i] + " "; } LinQBaseDao.Query(sqlstr); } catch { CommonalityEntity.WriteTextLog("ProductForm btnCheck_Click()"); } } }
private void btnSave_Click(object sender, RoutedEventArgs e) { try { if (txtCarCode.Text == "") { MessageBox.Show("กรุณากรอก รหัสรถยนต์"); return; } if (txtCarName.Text == "") { MessageBox.Show("กรุณากรอก ยี่ห้อรถยนต์"); return; } if (txtCarModel.Text == "") { MessageBox.Show("กรุณากรอก รุ่นรถยนต์"); return; } if (txtCarEngine.Text == "") { MessageBox.Show("กรุณากรอก เครื่องรถยนต์"); return; } if (MessageBox.Show("ยืนยันการบันทึกข้อมูล", "การบันทึกข้อมูล", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.Yes) { bool complete = false; CarDAL dal = new CarDAL(); if (DataCommon.Exists("CAR_EDIT")) { item = (CarData)DataCommon.Get("CAR_EDIT"); CarData newItem = new CarData(); newItem.CAR_CODE = txtCarCode.Text.ToUpper(); newItem.CAR_ENGINE = txtCarEngine.Text.ToUpper(); newItem.CAR_MODEL = txtCarModel.Text.ToUpper(); newItem.CAR_NAME = txtCarName.Text.ToUpper(); newItem.CAR_REMARK = txtCarRemark.Text; newItem.CAR_STATUS = cbbStatus.Text == "ใช้งาน" ? "A" : "I"; dal.Update(item, newItem); DataCommon.Remove("CAR_EDIT"); complete = true; } else { if (dal.GetItem(txtCarCode.Text, txtCarName.Text, txtCarModel.Text, txtCarEngine.Text) == null) { item = new CarData(); item.CAR_CODE = txtCarCode.Text.ToUpper(); item.CAR_ENGINE = txtCarEngine.Text.ToUpper(); item.CAR_MODEL = txtCarModel.Text.ToUpper(); item.CAR_NAME = txtCarName.Text.ToUpper(); item.CAR_REMARK = txtCarRemark.Text; item.CAR_STATUS = cbbStatus.Text == "ใช้งาน" ? "A" : "I"; new CarDAL().Insert(item); complete = true; } else { MessageBox.Show("รหัสรถยนต์นี้ซ้ำในระบบ กรุณาเปลี่ยนรหัสรถยนต์"); } } if (complete) { MessageBox.Show("บันทึกข้อมูลสำเร็จ"); this.Close(); } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void btnSave_Click(object sender, RoutedEventArgs e) { try { bool complete = false; MemberData member = (MemberData)DataCommon.Get("DATA.MEMBER"); InsureCarData newItem = new InsureCarData(); if (cbbCompany.Text == "") { MessageBox.Show("กรูณาเลือก บริษัทประกันภัย"); return; } newItem.COMPANY_CODE = new InsureCompanyDAL().GetCompanyCode(cbbCompany.Text); if (txtPackage.Text == "") { MessageBox.Show("กรูณากรอก ชื่อแพคเกจ"); return; } newItem.PACKAGE_NAME = txtPackage.Text; if (cbbCarName.Text == "") { MessageBox.Show("กรูณาเลือก ยี่ห้อรถยนต์"); return; } if (cbbCarModel.Text == "") { MessageBox.Show("กรูณาเลือก รุ่นรถยนต์"); return; } if (cbbCarEngine.Text == "") { MessageBox.Show("กรูณาเลือก เครื่องยนต์"); return; } CarData carItem = new CarDAL().GetItem(cbbCarName.Text, cbbCarModel.Text, cbbCarEngine.Text); newItem.CAR_ID = carItem.CAR_ID; newItem.CAR_CODE = carItem.CAR_CODE; newItem.CAR_ENGINE = carItem.CAR_ENGINE; newItem.CAR_MODEL = carItem.CAR_MODEL; newItem.CAR_NAME = carItem.CAR_NAME; newItem.CAR_YEAR = cbbCarYear.Text; newItem.CONFIDENTIAL_STATUS = cbbConfident.Text == "Show" ? "S" : "H"; newItem.CREATE_DATE = DateTime.Now; newItem.CREATE_USER = member.MEMBER_USER; newItem.INSURE_CAR_STATUS = cbbStatus.Text == "ใช้งาน" ? "A" : "I"; newItem.INSURE_CATEGORY = cbbInsureCat.Text; newItem.INSURE_TYPE_REPAIR = cbbTypeRepair.Text; newItem.UPDATE_DATE = DateTime.Now; newItem.UPDATE_USER = member.MEMBER_USER; if (txtCapitalInsure.Text == "") { MessageBox.Show("กรูณากรอก ทุนประกันภัย"); return; } newItem.CAPITAL_INSURANCE = Convert.ToDecimal(txtCapitalInsure.Text); if (txtNetPrice.Text == "") { MessageBox.Show("กรูณากรอก เบี้ยสุทธิ"); return; } newItem.NET_PRICE = Convert.ToDecimal(txtNetPrice.Text); if (txtTotalPrice.Text == "") { MessageBox.Show("กรูณากรอก เบี้ยรวม"); return; } newItem.TOTAL_PRICE = Convert.ToDecimal(txtTotalPrice.Text); if (txtRoundPrice.Text == "") { MessageBox.Show("กรูณากรอก เบี้ยกลม"); return; } newItem.PRICE_ROUND = Convert.ToDecimal(txtRoundPrice.Text); int priority = 0; bool result = Int32.TryParse(txtPriolity.Text, out priority); if (result) { newItem.INSURE_PRIORITY = priority; } else { newItem.INSURE_PRIORITY = 999; } if (txtEff.Text == "") { MessageBox.Show("กรูณาเลือก วันที่มีผล"); return; } newItem.EFFECTIVE_DATE = Convert.ToDateTime(txtEff.Text); if (txtExp.Text == "") { MessageBox.Show("กรูณาเลือก วันที่หมดอายุ"); return; } newItem.EXPIRE_DATE = Convert.ToDateTime(txtExp.Text); if (txtCoveragePeople.Text == "") { MessageBox.Show("กรูณากรอก ชีวิต ร่างกาย หรืออนามัย /คน"); return; } newItem.LIVE_COVERAGE_PEOPLE = Convert.ToDecimal(txtCoveragePeople.Text); if (txtCoverageTime.Text == "") { MessageBox.Show("กรูณากรอก ชีวิต ร่างกาย หรืออนามัย /ครั้ง"); return; } newItem.LIVE_COVERAGE_TIME = Convert.ToDecimal(txtCoverageTime.Text); if (txtAssetTime.Text == "") { MessageBox.Show("กรูณากรอก ทรัพย์สิน/ครั้ง"); return; } newItem.ASSET_TIME = Convert.ToDecimal(txtAssetTime.Text); if (txtDamageCar.Text == "") { MessageBox.Show("กรูณากรอก ความเสียหายต่อรถยนต์"); return; } newItem.DAMAGE_TO_VEHICLE = Convert.ToDecimal(txtDamageCar.Text); if (txtMissingCar.Text == "") { MessageBox.Show("กรูณากรอก รถยนต์สูญหาย/ไฟไหม้"); return; } newItem.MISSING_FIRE_CAR = Convert.ToDecimal(txtMissingCar.Text); if (txtFirstDamage.Text == "") { MessageBox.Show("กรูณากรอก ค่าความเสียหายส่วนแรก"); return; } newItem.FIRST_DAMAGE_PRICE = Convert.ToDecimal(txtFirstDamage.Text); if (txtInsureDriver.Text == "") { MessageBox.Show("กรูณากรอก ประกันตัวผู้ขับขี่"); return; } newItem.DRIVER_INSURANCE_AMT = Convert.ToDecimal(txtInsureDriver.Text); if (txtPERSONAL_ACCIDENT_AMT.Text == "") { MessageBox.Show("กรูณากรอก อุบัติเหตุส่วนบุคคล"); return; } newItem.PERSONAL_ACCIDENT_AMT = Convert.ToDecimal(txtPERSONAL_ACCIDENT_AMT.Text); if (txtPERSONAL_ACCIDENT_PEOPLE.Text == "") { MessageBox.Show("กรูณากรอก จำนวนคนต่ออุบัติเหตุส่วนบุคคล"); return; } newItem.PERSONAL_ACCIDENT_PEOPLE = Convert.ToInt32(txtPERSONAL_ACCIDENT_PEOPLE.Text); if (txtMEDICAL_FEE_AMT.Text == "") { MessageBox.Show("กรูณากรอก ค่ารักษาพยาบาล"); return; } newItem.MEDICAL_FEE_AMT = Convert.ToDecimal(txtMEDICAL_FEE_AMT.Text); if (txtMEDICAL_FEE_PEOPLE.Text == "") { MessageBox.Show("กรูณากรอก จำนวนคนต่อค่ารักษาพยาบาล"); return; } newItem.MEDICAL_FEE_PEOPLE = Convert.ToInt32(txtMEDICAL_FEE_PEOPLE.Text); if (MessageBox.Show("ยืนยันการบันทึกข้อมูล", "การบันทึกข้อมูล", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.Yes) { if (DataCommon.Exists("INSURE_CAR_EDIT")) { InsureCarData oldItem = (InsureCarData)DataCommon.Get("INSURE_CAR_EDIT"); new InsureCarDAL().Update(oldItem, newItem); complete = true; } else { new InsureCarDAL().Insert(newItem); complete = true; } if (complete) { MessageBox.Show("บันทึกข้อมูลสำเร็จ"); this.Close(); } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }