/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private bool saveInfo()
{
vehicle = VehicleDao.GetBySerial(this.serial.Text);
this.ValidateChildren(ValidationConstraints.Enabled & ValidationConstraints.TabStop & ValidationConstraints.Selectable);
if (!ValidatorManager.ValidateControls(this))
{
MessageBox.Show("控件内容不合法");
return(false);
}
Customer originInfo = GetOriginCustomer();
Customer currentInfo = GetCurrentCustomer();
vehicle = GetVehicleInfo();
try
{
originInfo.Id = vehicle.OriginCustomer.Id;
currentInfo.Id = vehicle.CurrentCustomer.Id;
CustomerDao.Update(originInfo);
CustomerDao.Update(currentInfo);
vehicle.OriginCustomer = originInfo;
vehicle.CurrentCustomer = currentInfo;
VehicleDao.UpdateVehicle(vehicle);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
return(true);
}
private void Receive(string serial)
{
this.serial.Text = serial;
vehicle = VehicleDao.GetBySerial(serial);
if (vehicle != null)
{
this.setControlReadOnly(false);
try
{
SetVehicleInfo(vehicle);
}
catch
{
MessageUtil.ShowWarning("发生错误！");
}
this.SetOriginCustomer(vehicle.OriginCustomer);
this.SetCurrentCustomer(vehicle.CurrentCustomer);
}
else
{
this.serial.Focus();
}
}
/// <summary>
/// 流水号失去焦点后，如果用户输入了流水号，则根据输入的流水号进行查找，否则生成流水号
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void serial_Leave(object sender, EventArgs e)
{
if (this.serial.ReadOnly || this.serial.Text.Length != 11)
{
return;
}
vehicle = VehicleDao.GetBySerial(this.serial.Text);;
if (vehicle != null)
{
this.setControlReadOnly(false);
InitComboBox();
SetVehicleInfo(vehicle);
this.SetOriginCustomer(CustomerDao.GetById(vehicle.OriginCustomer.UserId));
this.SetCurrentCustomer(CustomerDao.GetById(vehicle.CurrentCustomer.UserId));
}
else
{
MessageBox.Show("无此数据：流水号" + this.serial.Text);
this.serial.Focus();
this.serial.Text = VehicleDao.GetCurrentDate();
this.serial.Select(this.serial.Text.Length, 0);
}
}
protected override Vehicle GetVehicleInfo()
{
vehicle = VehicleDao.GetBySerial(vehicle.Serial);
vehicle.Isgrant = true;
vehicle.GrantDate = DateTime.ParseExact(VehicleDao.GetCurrentTimestamp(), "yyyy-MM-dd HH:mm:ss", System.Globalization.CultureInfo.CurrentCulture);
vehicle.Granter = LoginForm.user;
return(vehicle);
}
/// <summary>
/// 保存按钮点击，将数据保存至数据库
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void saveBtn_Click(object sender, EventArgs e)
{
this.ValidateChildren(ValidationConstraints.Enabled & ValidationConstraints.TabStop & ValidationConstraints.Selectable);
if (!ValidatorManager.ValidateControls(this))
{
MessageBox.Show("控件内容不合法");
return;
}
Customer originInfo = GetOriginCustomer();
Customer currentInfo = GetCurrentCustomer();
if (this.isUpdate)
{
try
{
vehicle = VehicleDao.GetBySerial(vehicle.Serial);
originInfo.Id = vehicle.OriginCustomer.Id;
currentInfo.Id = vehicle.CurrentCustomer.Id;
CustomerDao.Update(originInfo);
CustomerDao.Update(currentInfo);
vehicle = GetVehicleInfo();
vehicle.OriginCustomer = originInfo;
vehicle.CurrentCustomer = currentInfo;
VehicleDao.UpdateVehicle(vehicle);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
}
else
{
try
{
CustomerDao.Add(originInfo);
CustomerDao.Add(currentInfo);
vehicle = GetVehicleInfo();
vehicle.OriginCustomer = originInfo;
vehicle.CurrentCustomer = currentInfo;
object id = VehicleDao.AddVehicle(vehicle);
MessageBox.Show("当前流水号为 " + id);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
}
this.resetControlContent();
this.setControlReadOnly(true);
this.serial.Focus();
}
protected override Vehicle GetVehicleInfo()
{
vehicle = VehicleDao.GetBySerial(vehicle.Serial);
if (base.FunctionBtn.Text == "缴费")
{
vehicle.Ischarged = true;
vehicle.Isrefund = false;
vehicle.ChargeDate = DateTime.ParseExact(VehicleDao.GetCurrentTimestamp(), "yyyy-MM-dd HH:mm:ss", System.Globalization.CultureInfo.CurrentCulture);
vehicle.Charger = LoginForm.user;
return(vehicle);
}
else
{
vehicle.Isrefund = true;
vehicle.Ischarged = false;
vehicle.RefundDate = DateTime.ParseExact(VehicleDao.GetCurrentTimestamp(), "yyyy-MM-dd HH:mm:ss", System.Globalization.CultureInfo.CurrentCulture);
vehicle.Refunder = LoginForm.user;
return(vehicle);
}
}
/// <summary>
/// 流水号失去焦点后，如果用户输入了流水号，则根据输入的流水号进行查找，否则生成流水号
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void serial_Leave(object sender, EventArgs e)
{
if (this.serial.ReadOnly || (this.serial.Text.Length != 11 && this.serial.Text.Length != 0))
{
return;
}
if (Utilities.IsNullOrEmpty(this.serial.Text))
{
vehicle = new Vehicle();
this.serial.Text = VehicleDao.GetLatestSerial();
this.setControlReadOnly(false);
this.isUpdate = false;
}
else
{
vehicle = VehicleDao.GetBySerial(this.serial.Text);
if (vehicle != null)
{
this.setControlReadOnly(false);
this.isUpdate = true;
SetVehicleInfo(vehicle);
this.SetOriginCustomer(vehicle.OriginCustomer);
this.SetCurrentCustomer(vehicle.CurrentCustomer);
}
else
{
this.serial.Focus();
}
}
}
/// <summary>
/// 打印交易票
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void printBtn_Click(object sender, EventArgs e)
{
try
{
vehicle = VehicleDao.GetBySerial(this.serial.Text);
vehicle.Isprinted = true;
vehicle.Isgrant = false;
VehicleDao.UpdateVehicle(vehicle);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
Object oMissing = System.Reflection.Missing.Value;
Microsoft.Office.Interop.Excel.Application m_objExcel = null;
Microsoft.Office.Interop.Excel._Workbook m_objBook = null;
Microsoft.Office.Interop.Excel.Sheets m_objSheets = null;
Microsoft.Office.Interop.Excel._Worksheet m_objSheet = null;
Microsoft.Office.Interop.Excel.Range m_objRange = null;
try
{
m_objExcel = new Microsoft.Office.Interop.Excel.Application();
DirectoryInfo Dir = new DirectoryInfo(".");
m_objBook = m_objExcel.Workbooks.Open(Dir.FullName + "/Templete/Input.xls", oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing);
m_objSheets = (Microsoft.Office.Interop.Excel.Sheets)m_objBook.Worksheets;
m_objSheet = (Microsoft.Office.Interop.Excel._Worksheet)(m_objSheets.get_Item(1));
// 开票日期
m_objRange = m_objSheet.get_Range("B1", oMissing);
m_objRange.Value = DateTime.ParseExact(VehicleDao.GetCurrentDate(), "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture).ToString("yyyy/MM/dd");
// 开票人
m_objRange = m_objSheet.get_Range("K19", oMissing);
m_objRange.Value = LoginForm.user.UsersName;
// 买 方 单 位 /个人
m_objRange = m_objSheet.get_Range("C5", oMissing);
m_objRange.Value = this.currentName.Text;
// 单位代码/身份证号码
m_objRange = m_objSheet.get_Range("K5", oMissing);
m_objRange.Value = this.currentId.Text;
// 买方单位/个人住址
m_objRange = m_objSheet.get_Range("C6", oMissing);
m_objRange.Value = this.currentAddress.Text;
// 电话
m_objRange = m_objSheet.get_Range("L6", oMissing);
m_objRange.Value = this.currentPhone.Text;
// 卖 方 单 位/ 个人
m_objRange = m_objSheet.get_Range("C7", oMissing);
m_objRange.Value = this.originName.Text;
// 单位代码/身份证号码
m_objRange = m_objSheet.get_Range("K7", oMissing);
m_objRange.Value = this.originId.Text;
// 卖方单位/个人住址
m_objRange = m_objSheet.get_Range("C8", oMissing);
m_objRange.Value = this.originAddress.Text;
// 电话
m_objRange = m_objSheet.get_Range("L8", oMissing);
m_objRange.Value = this.originPhone.Text;
// 车 牌 照 号
m_objRange = m_objSheet.get_Range("C9", oMissing);
m_objRange.Value = "辽B." + this.license.Text;
// 登记证号
m_objRange = m_objSheet.get_Range("E9", oMissing);
m_objRange.Value = this.certificate.Text;
// 车 辆 类 型
m_objRange = m_objSheet.get_Range("L9", oMissing);
m_objRange.Value = this.vehicleType.Text;
// 车架号/车辆识别代码
m_objRange = m_objSheet.get_Range("C10", oMissing);
m_objRange.Value = this.vin.Text;
// 厂牌型号
m_objRange = m_objSheet.get_Range("E10", oMissing);
m_objRange.Value = this.brand.Text;
// 转入地车辆管理所名称
m_objRange = m_objSheet.get_Range("L10", oMissing);
m_objRange.Value = this.department.Text;
// 车价 合 计（大写）
m_objRange = m_objSheet.get_Range("C11", oMissing);
m_objRange.Value = this.transactions.Text;
// 车价 合 计（小写）
m_objRange = m_objSheet.get_Range("L11", oMissing);
m_objRange.Value = this.transactions.Text;
m_objExcel.DisplayAlerts = false;
m_objSheet.PrintOut();
}
catch (Exception ex)
{
MessageBox.Show("打印失败，请检查打印机设置。错误信息：" + ex.Message);
}
finally
{
if (m_objBook != null)
{
m_objBook.Close(oMissing, oMissing, oMissing);
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objBook);
}
if (m_objExcel != null)
{
m_objExcel.Workbooks.Close();
m_objExcel.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objExcel);
}
m_objBook = null;
m_objExcel = null;
GC.Collect();
}
this.resetControlContent();
this.setControlReadOnly(true);
this.serial.Focus();
this.serial.Select(this.serial.Text.Length, 0);
}
