private void Dgv_ManageList_SelectionChanged(object sender, EventArgs e)
{
if (dgv_ManageList.SelectedRows.Count == 0)
{
return;
}
int index = 0;
CbManageInfo mManageInfo = FormComm.GetDataSourceToClass <CbManageInfo>(dgv_ManageList, ref index);
if (mManageInfo.ManageType == 0)
{
btn_Del.Enabled = false;
btn_Edit.Enabled = false;
btn_ChangePassword.Enabled = Dal_ManageInfo.ManageInfo.ManageType == 0;
btn_Jurisdiction.Enabled = false;
}
else if (mManageInfo.ID == Dal_ManageInfo.ManageInfo.ID)
{
btn_Del.Enabled = false;
btn_ChangePassword.Enabled = true;
btn_Edit.Enabled = true;
btn_Jurisdiction.Enabled = false;
}
else
{
btn_Del.Enabled = Dal_ManageRights.ManageRights.SetUserManagementToDelete;
btn_Edit.Enabled = Dal_ManageRights.ManageRights.SetUserManagemenetEditor;
btn_ChangePassword.Enabled = Dal_ManageInfo.ManageInfo.ManageType == 0;
btn_Jurisdiction.Enabled = Dal_ManageRights.ManageRights.SetUserAdministrationRights;
}
}
private void GetRecordCount()
{
int count = Dbhelper.Db.GetCount <CbManageLog>("ID");
PageCount = FormComm.GetPage(count, 30, l_PageTitle);
CurrentPage = 1;
}
private void Btn_Del_Click(object sender, EventArgs e)
{
int index = 0;
CbDeviceInfo deviceinfo = FormComm.GetDataSourceToClass <CbDeviceInfo>(dgv_DeviceInfo, ref index);
if (MessageBox.Show("确认是否删除设备信息。", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information) == DialogResult.OK)
{
try
{
Dbhelper.Db.Del <CbDeviceInfo>(deviceinfo.ID);
DataTable dt = dgv_DeviceInfo.DataSource as DataTable;
dt.Rows.RemoveAt(index);
GetDeviceInfoCount();
if (cb_AllSelected.CheckState != CheckState.Unchecked)
{
cb_AllSelected.CheckState = CheckState.Unchecked;
btn_Export.Enabled = false;
}
}
catch (Exception ex)
{
CustomExceptionHandler.GetExceptionMessage(ex);
MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
/// <summary>
/// DGV 单击单元格内容
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Dgv_DataList_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex < 0)
{
return;
}
if (!(dgv_DataList.Columns[e.ColumnIndex] is DataGridViewButtonColumn))
{
return;
}
int index = 0;
CbAssociateCard mAssociateCard = FormComm.GetDataSourceToClass <CbAssociateCard>(dgv_DataList, ref index);
//单个延期
using (DelayParam_Form delayparam = new DelayParam_Form(mAssociateCard))
{
if (delayparam.ShowDialog() != DialogResult.OK)
{
return;
}
mAssociateCard = delayparam.Tag as CbAssociateCard;
if (mAssociateCard.AssociateCardTime.Date != mAssociateCard.UpdateTime.Date)
{
mAssociateCard.UseState = 3;
}
//更新列表中的显示
FormComm.UpdateDgvDataSource <CbAssociateCard>(mAssociateCard, dgv_DataList, index);
}
}
private void GetDeviceInfoCount()
{
int count = Dbhelper.Db.GetCount <CbDeviceInfo>();
PageCount = FormComm.GetPage(count, 30, l_Description);
CurrentPage = 1;
}
private void GetRecordCount()
{
string where = GetSearchCountent();
int count = Dbhelper.Db.GetCount <CbIoRecord>("ID", where);
PageCount = FormComm.GetPage(count, 30, l_PageTitle);
CurrentPage = 1;
}
private void Btn_Add_Click(object sender, EventArgs e)
{
using (AddDeviceInfo_Form adddeviceinfo = new AddDeviceInfo_Form())
{
if (adddeviceinfo.ShowDialog() != DialogResult.OK)
{
return;
}
CbDeviceInfo mDeviceInfo = adddeviceinfo.Tag as CbDeviceInfo;
FormComm.AddDgvSource <CbDeviceInfo>(mDeviceInfo, dgv_DeviceInfo);
GetDeviceInfoCount();
}
}
private void Btn_Edit_Click(object sender, EventArgs e)
{
int index = 0;
CbDeviceInfo mDeviceInfo = FormComm.GetDataSourceToClass <CbDeviceInfo>(dgv_DeviceInfo, ref index);
using (EditDeviceInfo_Form editdeviceinfo = new CbznSystem.EditDeviceInfo_Form(mDeviceInfo))
{
if (editdeviceinfo.ShowDialog() != DialogResult.OK)
{
return;
}
mDeviceInfo = editdeviceinfo.Tag as CbDeviceInfo;
FormComm.UpdateDgvDataSource <CbDeviceInfo>(mDeviceInfo, dgv_DeviceInfo, index);
}
}
private void Btn_Jurisdiction_Click(object sender, EventArgs e)
{
int index = 0;
CbManageInfo mManageInfo = FormComm.GetDataSourceToClass <CbManageInfo>(dgv_ManageList, ref index);
using (JurisdictionSettings_Form jurisdiction = new JurisdictionSettings_Form(mManageInfo))
{
if (jurisdiction.ShowDialog() != DialogResult.OK)
{
return;
}
GetManageInfo();
dgv_ManageList.Rows[index].Selected = true;
}
}
private void GetRecordCount()
{
try
{
string strwhere = GetSearchWhere();
int count = Dbhelper.Db.GetCount <CbCardInfo>("ID", strwhere);
PageCount = FormComm.GetPage(count, 30, l_PageTile);
CurrentPage = 1;
}
catch (Exception ex)
{
CustomExceptionHandler.GetExceptionMessage(ex);
MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Btn_Edit_Click(object sender, EventArgs e)
{
int index = 0;
CbCardInfo mCardInfo = FormComm.GetDataSourceToClass <CbCardInfo>(dgv_InfoList, ref index);
using (EditInfo_Form edit = new EditInfo_Form(mCardInfo))
{
if (edit.ShowDialog() != DialogResult.OK)
{
return;
}
mCardInfo = edit.Tag as CbCardInfo;
FormComm.UpdateDgvDataSource <CbCardInfo>(mCardInfo, dgv_InfoList, index);
}
}
private void Btn_ChangePassword_Click(object sender, EventArgs e)
{
int index = 0;
CbManageInfo mManageInfo = FormComm.GetDataSourceToClass <CbManageInfo>(dgv_ManageList, ref index);
using (ChangePassword_Form changepassword = new ChangePassword_Form(mManageInfo))
{
if (changepassword.ShowDialog() != DialogResult.OK)
{
return;
}
mManageInfo = changepassword.Tag as CbManageInfo;
FormComm.UpdateDgvDataSource <CbManageInfo>(mManageInfo, dgv_ManageList, index);
}
}
private void Btn_Edit_Click(object sender, EventArgs e)
{
int index = 0;
CbManageInfo mManageInfo = FormComm.GetDataSourceToClass <CbManageInfo>(dgv_ManageList, ref index);
using (EditManager_Form editmanage = new EditManager_Form(mManageInfo))
{
if (editmanage.ShowDialog() != DialogResult.OK)
{
return;
}
mManageInfo = editmanage.Tag as CbManageInfo;
FormComm.UpdateDgvDataSource <CbManageInfo>(mManageInfo, dgv_ManageList, index);
}
}
private List <CbDeviceInfo> GetSelectRow()
{
List <CbDeviceInfo> mDeviceInfos = new List <CbDeviceInfo>();
for (int i = 0; i < dgv_DeviceInfo.RowCount; i++)
{
bool flag = Utils.StrToBool(dgv_DeviceInfo["c_Selected", i].Value, false);
if (!flag)
{
continue;
}
CbDeviceInfo mDeviceInfo = FormComm.GetDataSourceToClass <CbDeviceInfo>(dgv_DeviceInfo, i);
mDeviceInfos.Add(mDeviceInfo);
}
return(mDeviceInfos);
}
private void GetRecordCount()
{
try
{
string where = GetSearchWhere();
DataTable dt = Dbhelper.Db.GetAggregate <CbTempChargeRecord>(new AggregateFuncion[] {
new AggregateFuncion()
{
AggregateType = AggregateTypes.COUNT, Column = "ID", ColumnAlias = "RecordCount"
},
new AggregateFuncion()
{
AggregateType = AggregateTypes.SUM, Column = "ChargeAmount", ColumnAlias = "Charges"
},
new AggregateFuncion()
{
AggregateType = AggregateTypes.SUM, Column = "ActualAmount", ColumnAlias = "PaidInAmount"
},
}, where);
int count = 0;
double charges = 0, paidinamount = 0;
object obj = dt.Rows[0]["RecordCount"];
if (obj != DBNull.Value)
{
count = Convert.ToInt32(obj);
}
obj = dt.Rows[0]["Charges"];
if (obj != DBNull.Value)
{
charges = Convert.ToDouble(obj);
}
obj = dt.Rows[0]["PaidInAmount"];
if (obj != DBNull.Value)
{
paidinamount = Convert.ToDouble(obj);
}
l_StatisticsAll.Text = string.Format("总计金额 应收:{0}元 实收:{1}元", charges, paidinamount);
PageCount = FormComm.GetPage(count, 30, l_PageTitle);
CurrentPage = 1;
}
catch (Exception ex)
{
CustomExceptionHandler.GetExceptionMessage(ex);
MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// 批量延期
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Btn_Delays_Click(object sender, EventArgs e)
{
//获取选择批量延期的副卡
List <CbAssociateCard> mAssociateCards = new List <CbAssociateCard>();
for (int i = 0; i < dgv_DataList.RowCount; i++)
{
bool flag = Utils.StrToBool(dgv_DataList["c_Selected", i].Value, false);
if (!flag)
{
continue;
}
CbAssociateCard mAssociateCard = FormComm.GetDataSourceToClass <CbAssociateCard>(dgv_DataList, i);
mAssociateCards.Add(mAssociateCard);
}
using (DelayParam_Form delayparam = new DelayParam_Form(mAssociateCards))
{
if (delayparam.ShowDialog() != DialogResult.OK)
{
return;
}
mAssociateCards = delayparam.Tag as List <CbAssociateCard>;
//延期后的时间和车牌分区显示在列表中
foreach (CbAssociateCard item in mAssociateCards)
{
for (int i = 0; i < dgv_DataList.RowCount; i++)
{
if (dgv_DataList["AssociateCardNumber", i].Value.Equals(item.AssociateCardNumber))
{
if (item.AssociateCardTime.Date != item.UpdateTime.Date)
{
item.UseState = 3;
}
//更新列表中的显示
FormComm.UpdateDgvDataSource <CbAssociateCard>(item, dgv_DataList, i);
break;
}
}
}
}
}
private void Btn_Del_Click(object sender, EventArgs e)
{
int index = 0;
CbCardInfo mCardInfo = FormComm.GetDataSourceToClass <CbCardInfo>(dgv_InfoList, ref index);
if (MessageBox.Show("确认删除用户：" + mCardInfo.UserName + " 的信息吗？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information) != DialogResult.OK)
{
return;
}
try
{
Dbhelper.Db.Del <CbCardInfo>(mCardInfo.ID);
GetRecordCount();
//DataTable dt = dgv_InfoList.DataSource as DataTable;
//dt.Rows.RemoveAt(index);
}
catch (Exception ex)
{
CustomExceptionHandler.GetExceptionMessage(ex);
MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Btn_Del_Click(object sender, EventArgs e)
{
int index = 0;
CbManageInfo mManageInfo = FormComm.GetDataSourceToClass <CbManageInfo>(dgv_ManageList, ref index);
if (MessageBox.Show("确认删除管理员：" + mManageInfo.UserName + "", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information) != DialogResult.OK)
{
return;
}
try
{
Dbhelper.Db.Del <CbManageInfo>(mManageInfo.ID);
Dbhelper.Db.Del <CbManageRights>(" and UserID=" + mManageInfo.ID);
DataTable dt = dgv_ManageList.DataSource as DataTable;
dt.Rows.RemoveAt(index);
dgv_ManageList.Rows[0].Selected = true;
}
catch (Exception ex)
{
CustomExceptionHandler.GetExceptionMessage(ex);
MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public DataConnection()
{
FormComm FCom = new FormComm(this);
InitializeComponent();
}
/// <summary>
/// 确认
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Btn_Enter_Click(object sender, EventArgs e)
{
btn_Enter.Enabled = false;
byte[] by = null;
try
{
if (_mCardCounting == null)
{
//获取主卡计数数据
_mCardCounting = Dbhelper.Db.FirstDefault <CbCardCountingState>(string.Format(" and UseNumber='{0}' ", _mCardInfo.CardNumber));
//当前计数+1
_mCardCounting.UseCounting = DistanceCardHelper.LimitCount(_mCardCounting.UseCounting);
}
//获取副卡集合
_mViceCard = new List <CbAssociateCard>();
StringBuilder sb = new StringBuilder();
for (int i = 0; i < dgv_DataList.RowCount; i++)
{
CbAssociateCard mvicecard = FormComm.GetDataSourceToClass <CbAssociateCard>(dgv_DataList, i);
_mViceCard.Add(mvicecard);
sb.AppendFormat(" UseNumber='{0}' or", mvicecard.AssociateCardNumber);
}
if (sb.Length > 0)
{
sb = sb.Remove(sb.Length - 2, 2);
}
if (_mViceCardCounting == null && _mCardInfo.CardType == (int)CardTypes.CombinationCard)
{
//获取副卡的计数数据
_mViceCardCounting = Dbhelper.Db.ToList <CbCardCountingState>(string.Format(" and ({0}) ", sb.ToString()));
List <CombinationCardViceCardDataParam> ViceCardParams = new List <CombinationCardViceCardDataParam>();
foreach (CbCardCountingState item in _mViceCardCounting)
{
//副卡计数+1
item.UseCounting = DistanceCardHelper.LimitCount(item.UseCounting);
//获取副卡
CbAssociateCard vicecard = GetViceCard(item.UseNumber);
ViceCardParams.Add(new CombinationCardViceCardDataParam()
{
ViceCardCount = item.UseCounting,
ViceCardNumber = item.UseNumber,
ViceCardPartition = vicecard.SubCardDivision,
ViceCardTime = vicecard.UpdateTime
});
}
by = DistanceCardHelper.SetDistanceData(_mCardInfo.CardNumber, _mCardCounting.UseCounting, ViceCardParams);
}
else //车牌识别卡
{
List <LprCardViceCardParam> ViceCardParams = new List <LprCardViceCardParam>();
foreach (CbAssociateCard item in _mViceCard)
{
ViceCardParams.Add(new LprCardViceCardParam()
{
PlateNumber = item.AssociateCardNumber,
ViceCardPartition = item.SubCardDivision,
ViceCardTime = item.UpdateTime
});
}
by = DistanceCardHelper.SetDistanceData(_mCardInfo.CardNumber, _mCardCounting.UseCounting, ViceCardParams);
}
PortHelper.SerialPortWrite(by);
StartTimeOutThread();
}
catch (Exception ex)
{
btn_Enter.Enabled = true;
CustomExceptionHandler.GetExceptionMessage(ex);
MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public MainWindow()
{
InitializeComponent();
FormComm FCom = new FormComm(this);
}
