/// <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 BtnRefsh_Click_1(object sender, EventArgs e)
{
QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
this.dsUnit.Tables["时段设置"].Clear();
query.FillDataSet("时段设置", this.paramwin, this.dsUnit);
}
/// <summary>
/// 根据部门检索
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cboDept_TextChanged(object sender, EventArgs e)
{
string filter = "c.名称 like '%{0}%'";
if (cboDept.Text == "全部")
{
filter = "";
}
else
{
filter = string.Format(filter, this.cboDept.Text.Replace("'", "''"));
}
//得到数据源
QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
DataTable tab = dsUnit.Tables["补助管理"];;
if (null == tab)
{
return;
}
tab.Clear();
query.FillDataSet(tab.TableName, this.paramwin, ParamManager.setMacroParam(MacroPmType.FW, filter), this.dsUnit);
detpList.Items.Clear();
foreach (DataRow dr in tab.Rows)
{
this.detpList.Items.Add(dr["姓名"] + "(" + dr["卡号"] + ")");
}
}
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);
}
/// <summary>
/// 查询设备清单
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void DevListBtn_Click(object sender, EventArgs e)
{
dbGrid.Show();
DevListGrid.Hide();
QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
this.dsUnit.Tables["compara"].Clear();
query.FillDataSet("compara", this.paramwin, this.dsUnit);
}
/// <summary>
/// 保存补助记录，修改卡片余额
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click_1(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtMoney.Text) || moneyList.Items.Count < 1)
{
XtraMessageBox.Show("补助金额为空或者卡号为空!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
#region 循环写入数据
for (int i = 0; i < moneyList.Items.Count; i++)
{
string[] sArray = moneyList.Items[i].ToString().Split('(');
foreach (string j in sArray)
{
if (j.ToString().Contains(")"))
{
string[] ssArray = j.ToString().Split(')');
foreach (string h in ssArray)
{
if (!string.IsNullOrEmpty(h.ToString()))
{
string CardNo = h.ToString();
NameObjectList ps = new NameObjectList();
ParamManager.MergeParam(ps, this.paramwin);
ps["卡号"] = CardNo;
#region 查询当前记录
QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
DataTable tab = dsUnit.Tables["补助信息"];
if (null == tab)
{
return;
}
tab.Clear();
query.FillDataSet(tab.TableName, ps, this.dsUnit);
#endregion
//保存充值记录并且更新卡片余额
DataRow dr = tab.Rows[0];
dr["卡号"] = CardNo;
dr["补助充值"] = txtMoney.Text;
dr["操作员"] = BindManager.getUser().UserName;
NameObjectList ps1 = ParamManager.createParam(dr);
ParamManager.MergeParam(ps1, this.paramwin, false);
this.Query.ExecuteNonQuery("补助信息", ps1, ps1, ps1);
}
}
}
}
}
#endregion
moneyList.Items.Clear();
MessageBox.Show("补助成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);
}
/// <summary>
/// 获取最新数据
/// </summary>
public void getNewDataByCardNo(string cardno)
{
NameObjectList pstrans = new NameObjectList();
ParamManager.MergeParam(pstrans, this.paramwin);
pstrans["卡号"] = cardno;
//查询数据
QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
DataTable tab = dsUnit.Tables["卡检测"];
tab.Clear();
query.FillDataSet(tab.TableName, pstrans, this.dsUnit);
}
/// <summary>
/// 查询是否是操作员，操作员要交班
/// </summary>
/// <returns></returns>
public DataTable User()
{
//得到数据源
QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
this.dsUnit.Tables["操作员"].Clear();
//执行查询操作
NameObjectList ps = new NameObjectList();
ps["帐号"] = cbbAccount.Text;
query.FillDataSet("操作员", ps, this.dsUnit);
return(dsUnit.Tables["操作员"]);
}
/// <summary>
/// 初始化发行器
/// </summary>
/// <returns></returns>
public DataTable initDev()
{
IPHostEntry IpEntry = Dns.GetHostEntry(Dns.GetHostName());
string myip = IpEntry.AddressList[0].ToString();
string filter = "(电脑='{0}' or IP地址='{1}') and 通讯类别='发行器'";
filter = string.Format(filter, Dns.GetHostName(), myip);
DataTable tab = this.dsUnit.Tables["发行器"];
tab.Clear();
QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
query.FillDataSet("发行器", this.paramwin, ParamManager.setMacroParam(MacroPmType.FW, filter), this.dsUnit);
return(tab);
}
/// <summary>
/// 初始化发行器
/// </summary>
public void initCmdCard()
{
IPHostEntry IpEntry = Dns.GetHostEntry(Dns.GetHostName());
string myip = IpEntry.AddressList[0].ToString();
NameObjectList pstrans = new NameObjectList();
ParamManager.MergeParam(pstrans, this.paramwin);
pstrans["IP地址"] = myip;
//查询数据
QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
DataTable tab = dsUnit.Tables["设备设置"];
tab.Clear();
query.FillDataSet(tab.TableName, pstrans, this.dsUnit);
if (null == tab || tab.Rows.Count < 1)
{
return;
}
if (tab.Rows.Count < 1)
{
MessageBox.Show("请设置发行器");
return;
}
DataRow dr = this.dsUnit.Tables["设备设置"].Rows[0];
string port = Convert.ToString(dr["串口"]);
int baudrate = Convert.ToInt32(dr["波特率"]);
Parity parity = Parity.None;
int databits = Convert.ToInt32(dr["数据位"]);
StopBits stopbits = StopBits.One;
switch (Convert.ToString(dr["停止位"]))
{
case "1.5位": stopbits = StopBits.OnePointFive; break;
case "2位": stopbits = StopBits.Two; break;
default: stopbits = StopBits.One; break;
}
CommiTarget target = new CommiTarget(port, baudrate, parity, databits, stopbits);
int addrst = Convert.ToInt32(dr["站址"]);
bool success = this.cmdCard.SetTarget(target, addrst, this.radic.Checked);
if (success)
{
this.cmdCard.Buzz(true);
}
}
/// <summary>
/// 条件查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnCheck_Click(object sender, EventArgs e)
{
string filter = "a.NAME like '%{0}%' or a.EMPCODE like '%{0}%' or b.名称 like '%{0}%'";
filter = string.Format(filter, this.txtCheck.Text.Replace("'", "''"));
//得到数据源
QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
DataTable tab = this.dbUser.DataSource as DataTable;
if (null == tab)
{
return;
}
tab.Clear();
query.FillDataSet(tab.TableName, this.paramwin, ParamManager.setMacroParam(MacroPmType.FW, filter), this.ds);
}
/// <summary>
/// 时间段查询,部门，班制 检索
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSelect_Click(object sender, EventArgs e)
{
DataTable tab = this.dbDeptRpt.DataSource as DataTable;
if (null == tab)
{
return;
}
string filter = "a.日期>=(SELECT convert(datetime,'{0}',121)) and a.日期<=(SELECT convert(datetime, '{1}',121)) and (c.名称 like '%{2}%')";
filter = string.Format(filter, this.cboStart.Text.Replace("'", "''"), this.cboEnd.Text.Replace("'", "''"), this.cboDept.Text.Replace("'", "''"));
QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
tab.Clear();
query.FillDataSet(tab.TableName, this.paramwin, ParamManager.setMacroParam(MacroPmType.FW, filter), this.dsUnit);
}
/// <summary>
/// 条件查询 用户编号，卡号，姓名，部门检索
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnCheck_Click(object sender, EventArgs e)
{
DataTable tab = this.dbGrid.DataSource as DataTable;
if (null == tab)
{
return;
}
string filter = "";
filter = "(a.用户编号 like '%{0}%' or a.卡号 like '%{0}%' or b.name like '%{0}%' or e.名称 like '%{0}%') and f.类别 like '%{1}%'";
filter = string.Format(filter, this.tbcardno.Text.Replace("'", "''"), this.cboType.Text.Replace("'", "''"));
QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
tab.Clear();
query.FillDataSet(tab.TableName, this.paramwin, ParamManager.setMacroParam(MacroPmType.FW, filter), this.dsUnit);
}
/// <summary>
/// 根据条件查询相应的记录
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtQuery_Click(object sender, EventArgs e)
{
NameObjectList ps = new NameObjectList();
ps["StartDate"] = this.dateStart.EditValue;
ps["EndDate"] = this.dateEnd.EditValue;
ps["Type"] = this.lookType.EditValue;
ps["Dept"] = this.lookDept.EditValue;
ps["EmployNO"] = (object)this.txtEmployNo.Text;
ParamManager.MergeParam(ps, this.paramwin, false);
//查询数据
QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
DataTable tab = this.grdConsumeList.DataSource as DataTable;
tab.Clear();
query.FillDataSet(tab.TableName, ps, this.ds);
}
/// <summary>
/// 根据门岗查询设备
/// </summary>
public void GetDEvById(string DoorID)
{
//获取当前单元名称
DataTable tab = this.dbDev.DataSource as DataTable;
if (null == tab)
{
return;
}
string filter = "";
filter = "门岗ID='{0}'";
filter = string.Format(filter, DoorID.Replace("'", "''"));
QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
tab.Clear();
query.FillDataSet(tab.TableName, this.paramwin, ParamManager.setMacroParam(MacroPmType.FW, filter), this.ds);
}
/// <summary>
/// 条件检索
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void sbtFilter_Click(object sender, EventArgs e)
{
//获取当前单元名称
DataTable tab = dsUnit.Tables["用户选择"];
if (null == tab)
{
return;
}
//数据源
string filter = "姓名 like '%{0}%' or 用户编号 like '%{0}%' or 卡号 like '%{0}%' or 部门名称 like '%{0}%' or 车牌 like '%{0}%' or 车辆类型 like '%{0}%'";
filter = string.Format(filter, this.tbFilter.Text.Replace("'", "''"));
QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
tab.Clear();
query.FillDataSet(tab.TableName, this.paramwin, ParamManager.setMacroParam(MacroPmType.FW, filter), this.dsUnit);
}
/// <summary>
/// 根据餐厅检索 消费时段,菜单,消费机ddd
/// </summary>
/// <param name="db">GridControl</param>
/// <param name="flag">类别标示</param>
/// <param name="ID">编号</param>
public void CheckByDin(DevExpress.XtraGrid.GridControl db, string flag, string ID)
{
try
{
DataTable tab = db.DataSource as DataTable;
if (null == tab)
{
return;
}
if (string.IsNullOrEmpty(ID))
{
return;
}
string filter = "";
switch (flag)
{
case "1":
filter = "餐厅ID='{0}' order by 星期序号";
break;
case "2":
filter = "餐厅ID='{0}'";
break;
case "4":
filter = "a.餐厅ID='{0}'";
break;
case "3":
filter = "餐厅ID='{0}'";
break;
default:
break;
}
filter = string.Format(filter, ID.Replace("'", "''"));
QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
tab.Clear();
query.FillDataSet(tab.TableName, this.paramwin, ParamManager.setMacroParam(MacroPmType.FW, filter), this.ds);
}
catch (Exception ex)
{
}
}
/// <summary>
/// 根据部门查询
/// </summary>
public void GetUserByDept(string Num)
{
try
{
DataTable tab = this.dbUser.DataSource as DataTable;
if (null == tab)
{
return;
}
string filter = "DEPARTMENT='{0}'";
filter = string.Format(filter, Num.Replace("'", "''"));
QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
tab.Clear();
query.FillDataSet(tab.TableName, this.paramwin, ParamManager.setMacroParam(MacroPmType.FW, filter), this.ds);
}
catch (Exception ex)
{
}
}
/// <summary>
/// 根据卡号获取当前信息
/// </summary>
public DataTable getNewDataByCardNo(string cardno)
{
NameObjectList pstrans = new NameObjectList();
ParamManager.MergeParam(pstrans, this.paramwin);
pstrans["卡号"] = cardno;
//查询数据
QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
DataTable tab = dsUnit.Tables["selectcard"];
tab.Clear();
query.FillDataSet(tab.TableName, pstrans, this.dsUnit);
if (null == tab || tab.Rows.Count < 1)
{
return(tab);
}
status = Convert.ToString(tab.Rows[0]["状态"]);
return(tab);
}
/// <summary>
/// 条件查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtQuery_Click(object sender, EventArgs e)
{
string StartDtTime = this.StartDate.Text + " " + this.cboStartTime.Text;
string EndDtTime = this.EndDate.Text + " " + this.cboEndTime.Text;
//获取当前单元名称
DataTable tab = this.dbGridIn.DataSource as DataTable;
if (null == tab)
{
return;
}
string filter = "";
filter = " a.日期 between (SELECT convert(datetime,'{0}',121)) and (SELECT convert(datetime,'{1}',121)+1) and a.用户编号 like '%{2}%' and b.name like '%{3}%' and c.卡类 like '%{4}%' and (a.车牌 like '%{5}%' or a.车牌 is null) and a.卡号 like '%{6}%' and p.名称 like '%{7}%'";
filter = string.Format(filter, StartDtTime.Replace("'", "''"), EndDtTime.Replace("'", "''"), txtuserID.Text.Replace("'", "''"), this.txtuserName.Text.Replace("'", "''"), this.CbCardtype.Text.Replace("'", "''"), TxtCarNo.Text.Replace("'", "''"), TxtCardNo.Text.Replace("'", "''"), this.dtDev.Text.Replace("'", "''"));
QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
tab.Clear();
query.FillDataSet(tab.TableName, this.paramwin, ParamManager.setMacroParam(MacroPmType.FW, filter), this.dsUnit);
}
/// <summary>
/// 条件查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnCheck_Click(object sender, EventArgs e)
{
string StartDtTime = this.cboStartDate.Text + " " + this.cboStartTime.Text;
string EndDtTime = this.cboEndDate.Text + " " + this.cboEndTime.Text;
//获取当前单元名称
DataTable tab = this.dbGrid.DataSource as DataTable;
if (null == tab)
{
return;
}
string filter = "";
filter = "a.接班时间 between '{0}' and '{1}'and a.接班人 like '%{2}%'and a.交班人 like '%{3}%'";
filter = string.Format(filter, StartDtTime.Replace("'", "''"), EndDtTime.Replace("'", "''"), this.cboStartEmp.Text.Replace("'", "''"), this.cboEndEmp.Text.Replace("'", "''"));
QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
tab.Clear();
query.FillDataSet(tab.TableName, this.paramwin, ParamManager.setMacroParam(MacroPmType.FW, filter), this.dsUnit);
}
/// <summary>
/// 初始化发行器
/// </summary>
/// <returns></returns>
public DataTable initDev()
{
IPHostEntry IpEntry = Dns.GetHostEntry(Dns.GetHostName());
string myip = IpEntry.AddressList[0].ToString();
NameObjectList pstrans = new NameObjectList();
ParamManager.MergeParam(pstrans, this.paramwin);
pstrans["IP地址"] = myip;
//查询数据
QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
DataTable tab = dsUnit.Tables["设备设置"];
tab.Clear();
query.FillDataSet(tab.TableName, pstrans, this.dsUnit);
if (null == tab || tab.Rows.Count < 1)
{
return(tab);
}
return(tab);
}
/// <summary>
/// 当前行改变,更改用户编号
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void gridView_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
if (flag == 1)
{
return;
}
else
{
flag = 0;
}
if (gridView.RowCount <= e.FocusedRowHandle || e.FocusedRowHandle < 0)
{
return;
}
//设置参数
NameObjectList ps = new NameObjectList();
ParamManager.MergeParam(ps, this.paramwin);
ps["卡号"] = textEdit1.Text;
QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
DataTable tab1 = this.dsUnit.Tables["发行"];
if (null == tab1)
{
return;
}
tab1.Clear();
query.FillDataSet(tab1.TableName, ps, this.dsUnit);
if (blstatus.Text == "")
{
lbState.Text = "未发行";
}
else
{
lbState.Text = this.blstatus.Text;
}
}
private void QueryBtn_Click(object sender, EventArgs e)
{
//设置参数
NameObjectList ps = new NameObjectList();
ParamManager.MergeParam(ps, this.paramwin);
string s = Convert.ToDateTime(this.dtpDate.Value).ToString("yyyy-MM-dd").ToString();
ps["dt"] = Convert.ToDateTime(this.dtpDate.Value).ToString("yyyy-MM-dd").ToString();
ps["type"] = this.cbRecordTp.SelectedIndex + 1;
//查询数据
QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
DataTable tab = this.RecordGrid.DataSource as DataTable;
if (null == tab)
{
return;
}
tab.Clear();
query.FillDataSet(tab.TableName, ps, this.ds);
//特殊业务处理
this.lbcount.Text = "总记录: " + Convert.ToString(ds.Tables[0].Rows.Count) + " 条";
}
