private void FrmCardMakeS_Load(object sender, EventArgs e)
{
//初始化参数和单元
this.paramwin = BindManager.getSystemParam();
NameObjectList pstrans = BindManager.getTransParam();
ParamManager.MergeParam(this.paramwin, pstrans);
this.unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName);
//绑定数据
this.bindMgr = new BindManager(this);
this.dsUnit = this.bindMgr.BuildDataset(this.unitItem, this.paramwin);
this.bindMgr.BindFld(this, dsUnit);
this.Query = new QueryDataRes(this.unitItem.DataSrcFile);
///检测发行器
///
bindMgr.SetGridCols(this.dbUser, "姓名,卡号,部门名称");
DataTable taboption = initSet();
if (null == taboption || taboption.Rows.Count < 1)
{
XtraMessageBox.Show("请设置发行器", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
lblMessage.Text = "";
ShowType();
tabCardApp.SelectedTabPageIndex = 2;
}
private void FrmFeePara_Load(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.deviceName))
{
//读取业务单元和传递参数
this.paramwin = BindManager.getSystemParam();
NameObjectList pstrans = BindManager.getTransParam();
ParamManager.MergeParam(this.paramwin, pstrans);
unitName = pstrans["name"].ToString();//单元
unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName);
//绑定数据
BindManager bg = new BindManager(this);
this.dsUnit = bg.BuildDataset(this.unitItem, this.paramwin);
bg.BindFld(this, this.dsUnit);
if (unitName == "停车场收费标准")
{
lbDeviceInfo.Visible = false;
this.DownBtn.Visible = false;
QueryBtn.Visible = false;
BtnClose.Visible = false;
}
}
else
{
this.cbodev.Visible = false;
this.btnsave.Visible = false;
this.lbDeviceInfo.Text = " " + this.deviceName + "(" + this.deviceID + ")";
}
}
private void FrmDoorMonitor_Load(object sender, EventArgs e)
{
//初始化参数和单元
this.paramwin = BindManager.getSystemParam();
NameObjectList pstrans = BindManager.getTransParam();
ParamManager.MergeParam(this.paramwin, pstrans);
this.unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName);
//绑定数据
this.bindMgr = new BindManager(this);
this.paramwin["code"] = DBNull.Value;
this.ds = this.bindMgr.BuildDataset(this.unitItem, this.paramwin);
this.Query = new QueryDataRes(this.unitItem.DataSrcFile);
this.bindMgr.BindFld(this, ds);
//对树的操作
DataTable tab = this.ds.Tables["门禁监控"];
this.bindMgr.BindTrv(this.trvDoorStall, tab, "名称", "ID", "PID", "@ID={ID},@PID={PID}");
this.trvDoorStall.ExpandAll();
this.tabStateDoor = this.ds.Tables["门禁巡检状态"];
if (gridViewInfo.RowCount > 0)
{
gridViewInfo.DeleteRow(0);
}
}
/// <summary>
/// 窗口初始化
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ParkStallSetFrm_Load(object sender, EventArgs e)
{
//初始化参数和单元
this.paramwin = BindManager.getSystemParam();
NameObjectList pstrans = BindManager.getTransParam();
ParamManager.MergeParam(this.paramwin, pstrans);
this.unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName);
//绑定数据
this.bindMgr = new BindManager(this);
this.paramwin["code"] = DBNull.Value;
this.ds = this.bindMgr.BuildDataset(this.unitItem, this.paramwin);
this.Query = new QueryDataRes(this.unitItem.DataSrcFile);
this.bindMgr.BindFld(this, ds);
//对树的操作
DataTable tab = this.ds.Tables["停车场管理"];
this.bindMgr.BindTrv(this.trvParkStall, tab, "名称", "id", "PID", "@ID={ID},@PID={PID},@编号={编号},@站址={站址}");
this.trvParkStall.ExpandAll();
tab.ColumnChanged += new DataColumnChangeEventHandler(tab_ColumnChanged);
if (this.trvParkStall.Nodes.Count > 0)
{
this.trvParkStall.FocusedNode = this.trvParkStall.Nodes[0];
}
this.grpParam.Hide();
this.grpFee.Dock = DockStyle.Fill;
this.grpParam.Dock = DockStyle.Fill;
// //初始化收费参数编辑控件事件
this.setTextChanged(this.tabFeeStd);
this.setCheckedChanged(this.grpbAccept);
this.setCheckedChanged(this.grpbCardType);
this.setCheckedChanged(this.grpbChannel);
this.plCarType.Dock = DockStyle.Fill;
//加载串口
string[] Com =
{
"COM1", "COM2", "COM3", "COM4", "COM5", "COM6", "COM7", "COM8", "COM9", "COM10"
};
LoadComBox("串口", Com);
//加载波特率
string[] BTL = { "4800", "9600", "19200", "38400", "56000" };
LoadComBox("波特率", BTL);
//加载数据位
string[] DataW = { "5", "6", "7", "8" };
LoadComBox("数据位", DataW);
//加载停止位
string[] DopW = { "1", "2" };
LoadComBox("停止位", DopW);
//加载停止位
string[] DK = { "30000", "60000" };
LoadComBox("端口", DK);
//加载通讯类别
string[] type = { "TCP/IP(局域网)", "UDP/IP(局域网)", "串口" };
LoadComBox("通讯类别", type);
this.TxtStalname.EditValueChanged += new EventHandler(txtEditValueChanged);
this.AllNoTxt.EditValueChanged += new EventHandler(txtEditValueChanged);
this.RetainStaTxt.EditValueChanged += new EventHandler(txtEditValueChanged);
this.ComIpTxt.EditValueChanged += new EventHandler(txtEditValueChanged);
}
/// <summary>
/// 根据数据表创建参数列表
/// </summary>
/// <param name="tab">数据表</param>
/// <returns>返回参数列表</returns>
public static NameObjectList[] createParam(DataTable tab, DataRowState state)
{
if (null == tab || tab.Rows.Count < 1)
{
return(new NameObjectList[0]);
}
List <NameObjectList> psList = new List <NameObjectList>();
DataView dvsub = new DataView(tab, "", "", DataViewRowState.ModifiedCurrent | DataViewRowState.Added | DataViewRowState.Deleted);
DataColumnCollection cols = tab.Columns;
int len = cols.Count;
for (int i = 0; i < dvsub.Count; i++)
{
if (state != dvsub[i].Row.RowState)
{
continue;
}
DataRowView drv = dvsub[i];
NameObjectList ps = new NameObjectList();
for (int c = 0; c < len; c++)
{
ps[cols[c].ColumnName] = drv[c];
}
psList.Add(ps);
}
return(psList.ToArray());
}
private void FrmLogin_Load(object sender, EventArgs e)
{
FormFactory dbhelp = new FormFactory();
if (!dbhelp.ConnectionResult("value", "Granity.granityMgr", "select * from 用户信息表"))
{
FrmDBDatabase db = new FrmDBDatabase();
db.ShowDialog();
if (!db.Success)
{
return;
}
}
try
{
//读取业务单元和传递参数
this.paramwin = BindManager.getSystemParam();
NameObjectList pstrans = BindManager.getTransParam();
ParamManager.MergeParam(this.paramwin, pstrans);
unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName);
//绑定数据
BindManager bg = new BindManager(this);
this.dsUnit = bg.BuildDataset(this.unitItem, this.paramwin);
this.Query = new QueryDataRes(this.unitItem.DataSrcFile);
bg.BindFld(this, this.dsUnit);
setSystemTime();
}
catch
{
this.Close();
}
}
/// <summary>
/// 退还押金
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btBack_Click(object sender, EventArgs e)
{
string province = this.cbbProvince.Text;
if (!string.IsNullOrEmpty(province))
{
province = regUperCase.Replace(province, "");
}
string carnum = this.tbCarnum.Text;
if (!string.IsNullOrEmpty(carnum))
{
carnum = province + carnum;
}
this.tag = basefun.setvaltag(this.tag, "{车牌号码}", carnum);
//押金处理
NameObjectList ps = ParamManager.createParam(this.tag);
//ps["操作类别"] = "退费";
ps["操作类别"] = "不退费再入场";
this.tag = basefun.setvaltag(this.tag, "{收费操作}", "不退费再入场");
ParamManager.MergeParam(ps, BindManager.getSystemParam(), false);
this.Query.ExecuteNonQuery("押金处理", ps, ps, ps);
this.DialogResult = DialogResult.Yes;
this.Close();
}
private void FrmCardUpdate_Load(object sender, EventArgs e)
{ //读取业务单元和传递参数
this.paramwin = BindManager.getSystemParam();
NameObjectList pstrans = BindManager.getTransParam();
ParamManager.MergeParam(this.paramwin, pstrans);
unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName);
//绑定数据
BindManager bg = new BindManager(this);
this.dsUnit = bg.BuildDataset(this.unitItem, this.paramwin);
bg.BindFld(this, this.dsUnit);
this.Query = new QueryDataRes(this.unitItem.DataSrcFile);
bg.SetGridCols(this.dbUser, "姓名,卡号,部门名称");
DataTable tab = initDev();
if (null == tab || tab.Rows.Count < 1)
{
XtraMessageBox.Show("请设置发行器", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
ShowType();
this.cboDTime.Text = DateTime.Now.ToString("yyyy-MM-dd");
this.cboETime.Text = DateTime.Now.ToString("yyyy-MM-dd");;
this.cboPTime.Text = DateTime.Now.ToString("yyyy-MM-dd");;
}
/// <summary>
/// 设置通讯设备
/// </summary>
/// <param name="devid">设备ID</param>
/// <param name="target">通讯目标</param>
/// <param name="station">站址</param>
public override void SetDevice(CommiManager mgr, CommiTarget target, string devid, int station)
{
if (null == mgr || string.IsNullOrEmpty(devid) || null == target || station < 1)
{
return;
}
this.commimgr = mgr;
this.target = target;
this.devid = devid;
this.station = station;
NameObjectList ps = new NameObjectList();
ps["分组ID"] = devid;
DataTable tab = this.query.getTable("门禁设备", ps);
if (null == tab || tab.Rows.Count < 1)
{
return;
}
object val = tab.Rows[0]["记录位置"];
if (null == val || DBNull.Value == val)
{
val = 0;
}
this.posRecord = Convert.ToInt32(val);
val = tab.Rows[0]["控制器类型"];
this.devtype = Convert.ToString(val);
if (string.IsNullOrEmpty(this.devtype))
{
this.devtype = "考勤机";
}
}
private void FormUpDownWork_Load(object sender, EventArgs e)
{
//初始化参数和单元
this.paramwin = BindManager.getSystemParam();
NameObjectList pstrans = BindManager.getTransParam();
ParamManager.MergeParam(this.paramwin, pstrans);
this.unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName);
//绑定数据
BindManager bg = new BindManager(this);
this.dsUnit = bg.BuildDataset(this.unitItem, this.paramwin);
bg.BindFld(this, this.dsUnit);
DataTable tab = this.dsUnit.Tables["接班人员"];
if (null == tab || tab.Rows.Count < 1)
{
return;
}
DataTable tabUser = this.dsUnit.Tables["用户信息"];
foreach (DataRow dr in tabUser.Rows)
{
this.ccbNextUser.Items.Add(Convert.ToString(dr["帐号"]));
}
tbUserName.Text = BindManager.getUser().UserAccounts;
}
private void FrmDevSet_Load(object sender, EventArgs e)
{
//初始化参数和单元
this.paramwin = BindManager.getSystemParam();
NameObjectList pstrans = BindManager.getTransParam();
ParamManager.MergeParam(this.paramwin, pstrans);
this.unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName);
//绑定数据
BindManager bg = new BindManager(this);
this.dsUnit = bg.BuildDataset(this.unitItem, this.paramwin);
bg.BindFld(this, this.dsUnit);
//加载串口
string[] Com =
{
"COM1", "COM2", "COM3", "COM4", "COM5", "COM6", "COM7", "COM8", "COM9", "COM10"
};
LoadComBox("串口", Com);
//加载波特率
string[] BTL = { "4800", "9600", "19200", "38400", "56000" };
LoadComBox("波特率", BTL);
//加载数据位
string[] DataW = { "5", "6", "7", "8" };
LoadComBox("数据位", DataW);
//加载停止位
string[] DopW = { "1", "2" };
LoadComBox("停止位", DopW);
}
/// <summary>
/// 导航树节点改变
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void treeUser_FocusedNodeChanged(object sender, FocusedNodeChangedEventArgs e)
{
if (null == e || null == e.Node)
{
return;
}
int rowIndex = 0;
string id = basefun.valtag(Convert.ToString(e.Node.Tag), "ID");
DataTable tab = this.ds.Tables["orgtreegroup"];
BindingManagerBase bindMgrbase = this.BindingContext[tab];
NameObjectList ps = new NameObjectList();
rowIndex = 0;
foreach (DataRow dr in tab.Rows)
{
if (DataRowState.Deleted != dr.RowState && dr["id"].ToString() == id)
{
bindMgrbase.Position = rowIndex;
ps["部门"] = Convert.ToString(dr["部门"]);
break;
}
rowIndex++;
}
tab = this.dbUser.DataSource as DataTable;
if (null == tab)
{
return;
}
tab.Clear();
this.Query.FillDataSet(tab.TableName, ps, tab.DataSet);
}
private void FrmDownTime_Load(object sender, EventArgs e)
{
//初始化参数和单元
this.paramwin = BindManager.getSystemParam();
NameObjectList pstrans = BindManager.getTransParam();
ParamManager.MergeParam(this.paramwin, pstrans);
this.unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), "时段设置");
this.Text = this.unitItem.UnitName;
//绑定数据
BindManager bg = new BindManager(this);
this.dsUnit = bg.BuildDataset(this.unitItem, this.paramwin);
if (this.dsUnit.Tables.Contains("时段设置"))
{
DataTable tab = this.dsUnit.Tables["时段设置"];
if (tab.Columns.Contains("选择"))
{
tab.Columns.Remove("选择");
}
tab.Columns.Add("选择", typeof(bool));
}
bg.BindFld(this, this.dsUnit);
//显示指定字段
//string cols = "选择 40,timeid 编号 40,timename 时段名称 90,timesec1s 起始时间1 90,timesec1e 截止时间1 90,timesec2s 起始时间2 90,timesec2e 截止时间2 90,";
//cols += "date1 起始日期 80,date2 截止日期 80,satrest 星期六 50,sunrest 星期天 50";
//bg.SetGridCols(this.gdValList, cols);
foreach (DataGridViewColumn c in this.gdValList.Columns)
{
c.ReadOnly = !("选择" == c.Name);
}
this.lbDeviceInfo.Text = " " + this.deviceName + "(" + this.deviceID + ")";
}
/// <summary>
/// 清空记录，重置记录位置
/// </summary>
private void ClearRecord()
{
//清空记录
CmdProtocol cmdP = new CmdProtocol(false);
setTimeout(cmdP);
cmdP.IsResposeHandle = isResponse;
string tag = "@设备地址=" + Convert.ToString(this.station);
cmdP.setCommand("门禁", "清空记录", tag);
this.commimgr.SendCommand(this.target, cmdP);
if (!cmdP.EventWh.WaitOne(this.waitTime, false))
{
return;
}
string msg = cmdP.ResponseFormat;
if ("true" == basefun.valtag(msg, "Success"))
{
this.posRecord = 0;
NameObjectList pspos = new NameObjectList();
pspos["控制器"] = this.devid;
try
{
Monitor.Enter(objquery);
this.query.ExecuteNonQuery("重置记录位置", pspos, pspos, pspos);
}
finally
{
Monitor.PulseAll(objquery);
Monitor.Exit(objquery);
}
}
}
private void FrmReadRecord_Load(object sender, EventArgs e)
{
this.UnitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), "收费站");
//初始化下拉框字典
this.Query = new QueryDataRes(this.UnitItem.DataSrcFile);
this.paramSystem = BindManager.getSystemParam();
DataSet ds = new DataSet("卡片类型");
this.Query.FillDataSet("卡片类型", this.paramSystem, ds);
this.Query.FillDataSet("卡片类型", this.paramSystem, ds);
DataRow dr = ds.Tables["卡片类型"].NewRow();
ds.Tables["卡片类型"].Rows.InsertAt(dr, 0);
dr = ds.Tables["卡片类型"].NewRow();
ds.Tables["卡片类型"].Rows.InsertAt(dr, 0);
DataGridViewComboBoxColumn col = this.gdRecord.Columns["卡类"] as DataGridViewComboBoxColumn;
col.ValueType = typeof(int);
col.DataSource = ds.Tables["卡片类型"];
col.DisplayMember = "卡类";
col.ValueMember = "编号";
col = this.gdRecord.Columns["车型"] as DataGridViewComboBoxColumn;
col.ValueType = typeof(int);
col.DataSource = ds.Tables["车型"];
col.DisplayMember = "车类";
col.ValueMember = "编号";
lbDevInfo.Text = this.DeviceName + "(" + this.DeviceID + ")";
}
/// <summary>
/// 加载控制参数
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void DownComBtn_Click(object sender, EventArgs e)
{
int[] indexlist = this.getCheckedList();
if (indexlist.Length < 1)
{
MessageBox.Show("请选择一个设备", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
DataTable tab = this.dbGrid.DataSource as DataTable;
DataRow drtarget = tab.Rows[indexlist[0]];
UnitItem unitPark = new UnitItem(DataAccRes.AppSettings("WorkConfig"), "设备控制维护");
BindManager bg = new BindManager(this);
NameObjectList ps = new NameObjectList();
ps["code"] = drtarget["编号"];
DataSet ds = bg.BuildDataset(unitPark, ps);
FrmCommPara win = new FrmCommPara();
win.DataSource = ds;
win.Query = new QueryDataRes(unitPark.DataSrcFile);
win.Position = 0;
win.Target = this.getTarget(drtarget);
win.FunType = "通讯";
win.ShowDialog(this);
}
private void FrmRight_Load(object sender, EventArgs e)
{
//初始化参数和单元
this.paramwin = BindManager.getSystemParam();
NameObjectList pstrans = BindManager.getTransParam();
ParamManager.MergeParam(this.paramwin, pstrans);
this.unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName);
//绑定数据0
this.bindMgr = new BindManager(this);
this.paramwin["code"] = DBNull.Value;
this.ds = this.bindMgr.BuildDataset(this.unitItem, this.paramwin);
this.Query = new QueryDataRes(this.unitItem.DataSrcFile);
DataTable tabEquipment = this.ds.Tables["停车场设备信息"];
this.bindMgr.BindTrv(this.treEquipmentAll, tabEquipment, "名称", "id", "PID", "@ID={ID},@PID={PID},@编号={编号}");
this.treEquipmentAll.ExpandAll();
DataTable tabDept = this.ds.Tables["停车场卡"];
this.bindMgr.BindTrv(this.treDept, tabDept, "名称", "id", "PID", "@ID={ID},@PID={PID},@用户编号={用户编号},@卡号={卡号}");
this.treDept.ExpandAll();
this.treDept.AfterCheckNode += new NodeEventHandler(treDept_AfterCheckNode);
this.treDept.FocusedNodeChanged += new FocusedNodeChangedEventHandler(treDept_FocusedNodeChanged);
this.treDept.FocusedNode = this.treDept.Nodes.ParentNode;
this.treEquipmentAll.AfterCheckNode += new NodeEventHandler(treEquipmentAll_AfterCheckNode);
}
private void FrmDorUsers_Load(object sender, EventArgs e)
{
//初始化参数和单元
this.paramwin = BindManager.getSystemParam();
NameObjectList pstrans = BindManager.getTransParam();
ParamManager.MergeParam(this.paramwin, pstrans);
this.unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName);
//绑定数据0
this.bindMgr = new BindManager(this);
this.paramwin["code"] = DBNull.Value;
this.ds = this.bindMgr.BuildDataset(this.unitItem, this.paramwin);
this.Query = new QueryDataRes(this.unitItem.DataSrcFile);
DataTable tabDor = this.ds.Tables["门禁分组"];
this.bindMgr.BindTrv(this.treDoorAll, tabDor, "名称", "id", "PID", "@ID={ID},@PID={PID},@编号={编号},@站址={站址}");
this.treDoorAll.FocusedNodeChanged += new DevExpress.XtraTreeList.FocusedNodeChangedEventHandler(treDoorAll_FocusedNodeChanged);
this.treDoorAll.FocusedNode = null;
this.treDoorAll.AfterCheckNode += new NodeEventHandler(treDoorAll_AfterCheckNode);
this.treDoorAll.ExpandAll();
DataTable tabDept = this.ds.Tables["部门用户信息"];
this.bindMgr.BindTrv(this.treDeptUser, tabDept, "名称", "id", "PID", "@ID={ID},@PID={PID},@用户编号={用户编号},@站址={站址}");
this.treDeptUser.ExpandAll();
}
private void Uc_DoorControlBaseinfo_Load(object sender, EventArgs e)
{
//初始化参数和单元
this.paramwin = BindManager.getSystemParam();
NameObjectList pstrans = BindManager.getTransParam();
ParamManager.MergeParam(this.paramwin, pstrans);
this.unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName);
//绑定数据
this.bindMgr = new BindManager(this);
this.paramwin["code"] = DBNull.Value;
this.ds = this.bindMgr.BuildDataset(this.unitItem, this.paramwin);
this.Query = new QueryDataRes(this.unitItem.DataSrcFile);
this.bindMgr.BindFld(this, ds);
// this.bindMgr.BindFld(this, ds, true);
//对树的操作
DataTable tab = this.ds.Tables["门禁管理"];
this.bindMgr.BindTrv(this.TreeGroup, tab, "名称", "id", "PID", "@ID={ID},@PID={PID},@编号={编号},@站址={站址}");
this.TreeGroup.ExpandAll();
this.txtDoorName.EditValueChanged += new EventHandler(txtEditValueChanged);
this.txtGroupName.EditValueChanged += new EventHandler(txtEditValueChanged);
this.txtControlDor.EditValueChanged += new EventHandler(txtEditValueChanged);
BandCheckChangeEventargs(this.xtraTabExtendPara);
GetEffTime();
}
/// <summary>
/// This method returns a sorted <see cref="List{Slide}"/> with the whole
/// slideshow.
/// </summary>
/// <returns>A sorted <see cref="List{Slide}"/> with all slides from the whole
/// slideshow.</returns>
private NameObjectList <Slide> GetSlides()
{
NameObjectList <Slide> slides = new NameObjectList <Slide>();
this.ParseNodeForSlides(ref slides, this);
return(slides);
}
private void FrmDepart_Load(object sender, EventArgs e)
{
//读取业务单元和传递参数
this.paramwin = BindManager.getSystemParam();
NameObjectList pstrans = BindManager.getTransParam();
ParamManager.MergeParam(this.paramwin, pstrans);
unitName = pstrans["name"].ToString();//单元
//获取当前单元名称
Dictionary <string, string> dict = new Dictionary <string, string>();
dict.Add("组织机构管理", "@db=组织机构");
//数据源
string datasource = dict[this.unitName];
NameObjectList ps = new NameObjectList();
ParamManager.MergeParam(ps, this.paramwin);
ps["UnitCode"] = "10";
unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName);
//绑定数据
BindManager bg = new BindManager(this);
dsUnit = bg.BuildDataset(this.unitItem, ps);
bg.BindFld(this, dsUnit);
//对树的操作
bg.BindTrv(this.trvDept, this.dsUnit.Tables["组织机构"], "名称", "ID", "PID", "@名称={名称},@代码={代码},@序号={序号},@ParentCode={ParentCode},@独立管理={独立管理},@分类={分类},@性质={性质},@部门主管={部门主管},@部门职责={部门职责},@班次代码={班次代码},@班次名称={班次名称},@周一={周},@周二={周二},@周三={周三},@周四={周四},@周五={周五},@周六={周六},@周日={周日},@level={level}");
this.trvDept.ExpandAll();
}
private void BtQuery_Click(object sender, EventArgs e)
{
if (this.dateStart.Text == string.Empty)
{
XtraMessageBox.Show("请输入开始时间", "系统提示！");
return;
}
if (this.dateEnd.Text == string.Empty)
{
XtraMessageBox.Show("请输入结束时间", "系统提示！");
return;
}
NameObjectList pstrans = new NameObjectList();
ParamManager.MergeParam(pstrans, this.paramwin);
pstrans["StartDate"] = this.dateStart.EditValue.ToString();
pstrans["EndDate"] = this.dateEnd.EditValue.ToString();
pstrans["Dept"] = this.lookDept.EditValue;
pstrans["EmployNO"] = (object)this.txtEmployName.Text;
//查询数据
QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
BindManager bg = new BindManager(this);
ds = bg.BuildDataset(this.unitItem, pstrans);
Granity.granityMgr.Report.viwReports View = new Granity.granityMgr.Report.viwReports();
View.ReportName = "考勤明细查询";
View.ds = ds;
View.StartTime = this.dateStart.Text.Trim();
View.EndTime = this.dateEnd.Text.Trim();
View.Activate();
View.Dock = DockStyle.Fill;
this.groReport.Controls.Clear();
this.groReport.Controls.Add(View);
}
/// <summary>
/// 条件查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtQuery_Click(object sender, EventArgs e)
{
if (this.dateStart.Text == string.Empty)
{
XtraMessageBox.Show("请输入开始时间", "系统提示！");
return;
}
if (this.dateEnd.Text == string.Empty)
{
XtraMessageBox.Show("请输入结束时间", "系统提示！");
return;
}
NameObjectList pstrans = new NameObjectList();
ParamManager.MergeParam(pstrans, this.paramwin);
pstrans["StartTime"] = this.dateStart.EditValue.ToString();
pstrans["EndTime"] = this.dateEnd.EditValue.ToString();
pstrans["CardType"] = this.CbCardtype.EditValue != null?this.CbCardtype.EditValue.ToString() : string.Empty;
pstrans["CarNo"] = this.TxtCarNo.Text.Trim();
pstrans["UsrNo"] = this.txtuserID.Text.Trim();
pstrans["Name"] = this.txtuserName.Text.Trim();
pstrans["CardNo"] = this.TxtCardNo.Text.Trim();
//查询数据
QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
BindManager bg = new BindManager(this);
DataSet ds = bg.BuildDataset(this.unitItem, pstrans);
bg.BindFld(this, ds);
}
/// <summary>
/// 窗口初始化
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ParkStallSetFrm_Load(object sender, EventArgs e)
{
//初始化参数和单元
this.paramwin = BindManager.getSystemParam();
NameObjectList pstrans = BindManager.getTransParam();
ParamManager.MergeParam(this.paramwin, pstrans);
this.unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName);
//绑定数据
this.bindMgr = new BindManager(this);
this.paramwin["code"] = DBNull.Value;
this.ds = this.bindMgr.BuildDataset(this.unitItem, this.paramwin);
this.Query = new QueryDataRes(this.unitItem.DataSrcFile);
this.bindMgr.BindFld(this, ds);
//对树的操作
DataTable tab = this.ds.Tables["停车场管理"];
this.bindMgr.BindTrv(this.trvParkStall, tab, "名称", "ID", "PID", "@ID={ID},@PID={PID},@编号={编号},@站址={站址}");
this.trvParkStall.ExpandAll();
tab.ColumnChanged += new DataColumnChangeEventHandler(tab_ColumnChanged);
if (this.trvParkStall.Nodes.Count > 0)
{
this.trvParkStall.SelectedNode = this.trvParkStall.Nodes[0];
}
this.panGrpParam.Hide();
this.panGrpFee.Dock = DockStyle.Fill;
this.panGrpParam.Dock = DockStyle.Fill;
//初始化收费参数编辑控件事件
this.setTextChanged(this.tabFeeStd);
this.setCheckedChanged(this.grpbAccept);
this.setCheckedChanged(this.grpbCardType);
this.setCheckedChanged(this.grpbChannel);
}
/// <summary>
/// 根据条件，查询出相应的记录
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtQuery_Click(object sender, EventArgs e)
{
if (this.dateStart.Text == string.Empty)
{
XtraMessageBox.Show("请输入开始时间", "系统提示！");
return;
}
if (this.dateEnd.Text == string.Empty)
{
XtraMessageBox.Show("请输入结束时间", "系统提示！");
return;
}
NameObjectList pstrans = new NameObjectList();
ParamManager.MergeParam(pstrans, this.paramwin);
pstrans["StartDate"] = this.dateStart.EditValue.ToString();
pstrans["EndDate"] = this.dateEnd.EditValue.ToString();
//查询数据
QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
DataTable tab = this.grdConsumeList.DataSource as DataTable;
if (null == tab)
{
return;
}
tab.Clear();
query.FillDataSet(tab.TableName, pstrans, this.ds);
}
private void trvDept_AfterSelect(object sender, TreeViewEventArgs e)
{
if (null == e.Node)
{
return;
}
//查询明细数据
DataTable tabDetail = this.dsUnit.Tables["组织机构"];
string tag = Convert.ToString(e.Node.Tag);
NameObjectList ps = new NameObjectList();
ParamManager.MergeParam(ps, this.paramwin);
ParamManager.MergeParam(ps, ParamManager.createParam(tag));
ps["UnitCode"] = basefun.valtag(e.Node.Tag.ToString(), "代码");
if (null != tabDetail)
{
tabDetail.Clear();
}
QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
query.FillDataSet("组织机构", ps, this.dsUnit);
checkBox1.Checked = Convert.ToBoolean(this.dsUnit.Tables[0].Rows[0]["独立管理"].ToString());
checkBox2.Checked = Convert.ToBoolean(this.dsUnit.Tables[0].Rows[0]["周一"].ToString());
checkBox3.Checked = Convert.ToBoolean(this.dsUnit.Tables[0].Rows[0]["周二"].ToString());
checkBox4.Checked = Convert.ToBoolean(this.dsUnit.Tables[0].Rows[0]["周三"].ToString());
checkBox5.Checked = Convert.ToBoolean(this.dsUnit.Tables[0].Rows[0]["周四"].ToString());
checkBox6.Checked = Convert.ToBoolean(this.dsUnit.Tables[0].Rows[0]["周五"].ToString());
checkBox7.Checked = Convert.ToBoolean(this.dsUnit.Tables[0].Rows[0]["周六"].ToString());
checkBox8.Checked = Convert.ToBoolean(this.dsUnit.Tables[0].Rows[0]["周日"].ToString());
//if (null == tabChanged)
// return;
//tabDetail = this.dsUnit.Tables["组织机构"];
//TreeNode trnsel, trn;
//trn = trnsel = e.Node;
//string strdept = "";
//while (null != trnsel)
//{
// if (null != trn.FirstNode)
// {
// trn = trn.FirstNode;
// continue;
// }
// string t = Convert.ToString(trn.Tag);
// strdept += " or 部门='" + basefun.valtag(t, "部门") + "'";
// if (trnsel == trn)
// break;
// if (null != trn.NextNode)
// trn = trn.NextNode;
// else
// trn = trn.Parent;
// if (trnsel == trn)
// break;
//}
//if (strdept.Length > 0)
// strdept = strdept.Substring(3);
//BindManager.UpdateTable(tabDetail, tabChanged, strdept);
}
private void FrmParkDeposit_Load(object sender, EventArgs e)
{
this.setContainerTagValue(this.grpInfo, this.tag, "pm");
//直接通讯获取停车费用
if (this.addrst < 0 || null == this.target)
{
return;
}
string cardnum = basefun.valtag(this.tag, "卡号");
string cardtype = basefun.valtag(this.tag, "卡类");
string cartype = basefun.valtag(this.tag, "车型");
string dtparkin = basefun.valtag(this.tag, "入场时间");
if (string.IsNullOrEmpty(cardtype) || string.IsNullOrEmpty(cartype) || string.IsNullOrEmpty(dtparkin))
{
return;
}
string data = "";
NameObjectList ps = ParamManager.createParam(this.tag);
foreach (string key in ps.AllKeys)
{
data = basefun.setvaltag(data, "{" + key + "}", Convert.ToString(ps[key]));
}
data = basefun.setvaltag(data, "设备地址", Convert.ToString(this.addrst));
data = basefun.setvaltag(data, "{设备地址}", Convert.ToString(this.addrst));
string dtparkout = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
data = basefun.setvaltag(data, "{出场时间}", dtparkout);
data = basefun.setvaltag(data, "{出入场时间}", dtparkout);
data = basefun.setvaltag(data, "{开闸方式}", "00");
this.tag = data;
CmdProtocol cmdP = new CmdProtocol(false);
cmdP.setCommand("停车场", "计算收费金额", data);
CommiManager.GlobalManager.SendCommand(this.target, cmdP);
if (!cmdP.EventWh.WaitOne(2000, false))
{
return;
}
string money = basefun.valtag(cmdP.ResponseFormat, "{收费金额}");
if (string.IsNullOrEmpty(money))
{
return;
}
this.tbPkmoney.Text = money;
this.tag = basefun.setvaltag(this.tag, "{收费金额}", money);
string cardmoney = basefun.valtag(this.tag, "{卡片余额}");
try
{
money = Convert.ToString(Convert.ToDecimal(money) - Convert.ToDecimal(cardmoney));
this.tbPkfee.Text = money;
this.tag = basefun.setvaltag(this.tag, "{收费}", money);
}
catch { }
}
/// <summary>
/// 利用参数数组分别按照新增,更新,删除的类别来更新数据;保证事务的一致性
/// 在执行更新时,按照删除,更新,新增的顺序执行,以避免并发冲突问题
/// </summary>
/// <param name="item">要提交的数据项目</param>
/// <param name="paramsIns">提交的新增参数</param>
/// <param name="paramsUpt">提交的更新参数</param>
/// <param name="paramsDel">提交的删除参数</param>
/// <param name="strParams">附加字符串数组参数</param>
/// <returns>操作是否成功</returns>
public bool ExecuteNonQuery(string item, NameObjectList paramsIns, NameObjectList paramsUpt, NameObjectList paramsDel, string[] strParams)
{
if ("" == item || null == paramsIns || null == paramsUpt || null == paramsDel)
{
return(false);
}
return(this._QueryDAO.ExecuteNonQuery(item, paramsIns, paramsUpt, paramsDel, strParams));
}
/// <summary>
/// 利用参数按照"delete"项来删除数据
/// </summary>
/// <param name="item">要提交的数据项目</param>
/// <param name="parameters">提交的参数</param>
/// <param name="strParams">约定??num为自定义变量，通过传递的定符串替代之</param>
/// <returns>操作是否成功</returns>
public bool ExecuteDelete(string item, NameObjectList parameters, string[] strParams)
{
if (item == "" || parameters == null)
{
return(false);
}
return(this._QueryDAO.ExecuteDelete(item, parameters, strParams));
}
/// <summary>
/// 更新大字段内容,一次只能更新一条记录,大字段使用stream类型传递
/// </summary>
/// <param name="item">数据项目名称</param>
/// <param name="paramlist">字段参数列表,大字段使用stream类型传递</param>
/// <returns>更新是否成功</returns>
public bool WriteSingleStream(string item, NameObjectList paramlist)
{
if (item == "" || paramlist == null)
{
return(false);
}
return(this._QueryDAO.WriteSingleStream(item, paramlist));
}
///////////////////////////////////////////////////////////////////////////////
// Eventhandler //
///////////////////////////////////////////////////////////////////////////////
#region EVENTS
///////////////////////////////////////////////////////////////////////////////
// Eventhandler for UI, Menu, Buttons, Toolbars etc. //
///////////////////////////////////////////////////////////////////////////////
#region WINDOWSEVENTHANDLER
#endregion //WINDOWSEVENTHANDLER
///////////////////////////////////////////////////////////////////////////////
// Eventhandler for Custom Defined Events //
///////////////////////////////////////////////////////////////////////////////
#region CUSTOMEVENTHANDLER
#endregion //CUSTOMEVENTHANDLER
#endregion //EVENTS
///////////////////////////////////////////////////////////////////////////////
// Methods and Eventhandling for Background tasks //
///////////////////////////////////////////////////////////////////////////////
#region BACKGROUNDWORKER
#endregion //BACKGROUNDWORKER
///////////////////////////////////////////////////////////////////////////////
// Methods for doing main class job //
///////////////////////////////////////////////////////////////////////////////
#region METHODS
/// <summary>
/// This method returns a sorted <see cref="List{Slide}"/> with the whole
/// slideshow.
/// </summary>
/// <returns>A sorted <see cref="List{Slide}"/> with all slides from the whole
/// slideshow.</returns>
private NameObjectList<Slide> GetSlides()
{
NameObjectList<Slide> slides = new NameObjectList<Slide>();
this.ParseNodeForSlides(ref slides, this);
return slides;
}
/// <summary>
/// This method iterates recursively through the tree to return only the slides
/// contained in the tree.
/// </summary>
/// <param name="slides">Ref. The output <see cref="NameObjectList{Slide}"/> of slides.</param>
/// <param name="node">The <see cref="TreeNode"/> to parse.</param>
private void ParseNodeForSlides(ref NameObjectList<Slide> slides, TreeNode node)
{
// Check all child nodes
foreach (TreeNode subNode in node.Nodes)
{
// If a slide is contained, add it to the list
Slide slide = ((SlideshowTreeNode)subNode).Slide;
if (slide != null)
{
slides.Add(slide.Name, slide);
}
// Iterate recursively
this.ParseNodeForSlides(ref slides, subNode);
}
}
