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