private void frmbasDictData_Load(object sender, EventArgs e) { AddDetailData("basDataDictDetailDAL", "MainID", "ID", "sDictDataNo"); gcDetail.DataSource = LDetailDataSet[LDetailDALName.IndexOf("basDataDictDetailDAL")]; gcDetail.DataMember = "ds"; DataStateChange(sender, e); }
private void frmsalGoodInfo_Load(object sender, EventArgs e) { AddDetailData("salGoodInfoDetailDAL", "MainID", "ID"); gcDetail.DataSource = LDetailDataSet[LDetailDALName.IndexOf("salGoodInfoDetailDAL")]; gcDetail.DataMember = "ds"; DataStateChange(sender, e); }
public override void MasterAllScroll(object sender, EventArgs e) { base.MasterAllScroll(sender, e); gcDetail.DataSource = LDetailDataSet[LDetailDALName.IndexOf("stkGoodOutStockDetailDAL")]; lkpsGoodID.DataBindings.Clear(); lkpsGoodID.DataBindings.Add("EditValue", LDetailDataSet[LDetailDALName.IndexOf("stkGoodOutStockDetailDAL")], "ds.sGoodID"); }
public override void DoPrint() { base.DoPrint(); report.AddReportData((DataRowView)bdsMain.Current, "dtMain"); report.AddReportData(LDetailDataSet[LDetailDALName.IndexOf("stkGoodOutStockDetailDAL")].Tables[0], "dtDetail"); report.ReportMenu.Show(btnPrintBill, new Point(0, btnPrintBill.Height)); }
private void frmsysSecurityManage_Load(object sender, EventArgs e) { //添加明细逻辑层处理 AddDetailData("sysRolesUserDAL", "RoleID", "ID", "sUserID"); AddDetailData("sysRolesRightsDAL", "RoleID", "ID", "iSort"); //绑定数据集 //角色用户 gcRoleUser.DataSource = LDetailDataSet[LDetailDALName.IndexOf("sysRolesUserDAL")]; gcRoleUser.DataMember = "ds"; //角色权限-树形菜单 tvRoleRight.DataSource = LDetailDataSet[LDetailDALName.IndexOf("sysRolesRightsDAL")]; tvRoleRight.DataMember = "ds"; tvRoleRight.KeyFieldName = "MenuID"; tvRoleRight.ParentFieldName = "iParentID"; //初始化选择菜单 initSystemMenu(); //初始化LookUp控件 BWS.ERP.Common.SystemPublic.InitLkpSystemUser(lkpUser); report = new BWS.ERP.Report.InitReport(ReportGUID); pnlDetailMenu.Visible = false; DataStateChange(sender, e); }
private void frmsysQueryReportSet_Load(object sender, EventArgs e) { AddDetailData("sysQueryReportDetailDAL", "MainID", "ID", "iSort"); gcDetail.DataSource = LDetailDataSet[LDetailDALName.IndexOf("sysQueryReportDetailDAL")]; gcDetail.DataMember = "ds"; DataStateChange(sender, e); }
public override void DoPrint() { base.DoPrint(); report.AddReportData(BWS.ERP.DataAccess.DbHelperSQL.Query("SELECT * FROM sysRoles WHERE ID=" + BillID.ToString()).Tables[0], "主表"); //report.AddReportData((IEnumerable)bdsMain.Current, "主表"); report.AddReportData(LDetailDataSet[LDetailDALName.IndexOf("sysRolesRightsDAL")].Tables[0], "角色权限"); report.AddReportData(LDetailDataSet[LDetailDALName.IndexOf("sysRolesUserDAL")].Tables[0], "角色用户"); report.ReportMenu.Show(btnPrint, new Point(0, btnPrint.Height)); }
public override void MasterAllScroll(object sender, EventArgs e) { base.MasterAllScroll(sender, e); gcDetail.DataSource = LDetailDataSet[LDetailDALName.IndexOf("hrCompanyDetailDAL")]; gcDept.DataSource = LDetailDataSet[LDetailDALName.IndexOf("hrDepartmentDAL")]; gcShopInfo.DataSource = LDetailDataSet[LDetailDALName.IndexOf("hrCompanyShopInfoDAL")]; lkpsCurrency.DataBindings.Clear(); lkpsCurrency.DataBindings.Add("EditValue", LDetailDataSet[LDetailDALName.IndexOf("hrCompanyDetailDAL")], "ds.sCurrency"); }
private void frmstkGoodSaleOutStock_Load(object sender, EventArgs e) { AddDetailData("stkGoodOutStockDetailDAL", "MainID", "ID"); gcDetail.DataSource = LDetailDataSet[LDetailDALName.IndexOf("stkGoodOutStockDetailDAL")]; gcDetail.DataMember = "ds"; btnPrintBill.Visible = bool.Parse(BWS.ERP.BasePublic.BasePublic.FormParaList(FormID)["IsShowPrintButton"].ToString().ToLower()); DataStateChange(sender, e); //自动新增 btnAdd_Click(sender, e); }
public override bool DoBeforeSave() { base.DoBeforeSave(); if (LDetailDataSet[LDetailDALName.IndexOf("salGoodInfoDetailDAL")].Tables[0].Select("bIsStop=0").Length > 1) { BWS.ERP.BaseControl.Public.SystemInfo("明细数据中不允许存在多条可用价格,请确认!", true); return(false); } else { return(true); } }
private void tvRoleRight_DragDrop(object sender, DragEventArgs e) { for (int i = 0; i < LMenuID.Count; i++) { if (!GetRoleMenuIDList().Contains(LMenuID[i])) { DataRow drNew = LDetailDataSet[LDetailDALName.IndexOf("sysRolesRightsDAL")].Tables[0].NewRow(); drNew["MenuID"] = int.Parse(LMenuID[i]); drNew["iParentID"] = int.Parse(LMenuParentID[i]); drNew["sMenuName"] = LMenuName[i]; LDetailDataSet[LDetailDALName.IndexOf("sysRolesRightsDAL")].Tables[0].Rows.Add(drNew); } } tvRoleRight.Refresh(); }
private void frmhrCompany_Load(object sender, EventArgs e) { AddDetailData("hrCompanyDetailDAL", "MainID", "ID"); AddDetailData("hrDepartmentDAL", "iCompanyID", "ID"); AddDetailData("hrCompanyShopInfoDAL", "MainID", "ID"); gcDetail.DataSource = LDetailDataSet[LDetailDALName.IndexOf("hrCompanyDetailDAL")]; gcDetail.DataMember = "ds"; gcDept.DataSource = LDetailDataSet[LDetailDALName.IndexOf("hrDepartmentDAL")]; gcDept.DataMember = "ds"; gcShopInfo.DataSource = LDetailDataSet[LDetailDALName.IndexOf("hrCompanyShopInfoDAL")]; gcShopInfo.DataMember = "ds"; lkpsCurrency.DataBindings.Add("EditValue", LDetailDataSet[LDetailDALName.IndexOf("hrCompanyDetailDAL")], "ds.sCurrency"); colbtnsCurrency.ButtonClick += new DevExpress.XtraEditors.Controls.ButtonPressedEventHandler(colbtnsCurrency_ButtonClick); DataStateChange(sender, e); }
private void btnDetailAdd_Click(object sender, EventArgs e) { lkpUser.SearchFormFilter = BulitLkpFilterString(); lkpUser.LookUpSelfClick(sender, null); if (lkpUser.ReturnData.Rows.Count > 0) { foreach (DataRow dr in lkpUser.ReturnData.Rows) { DataRow dtNew = LDetailDataSet[LDetailDALName.IndexOf("sysRolesUserDAL")].Tables[0].NewRow(); dtNew["UserID"] = dr["ID"]; dtNew["sRoleUserID"] = dr["sUserID"]; dtNew["sRoleUserCName"] = dr["sUserCName"]; LDetailDataSet[LDetailDALName.IndexOf("sysRolesUserDAL")].Tables[0].Rows.Add(dtNew); } } }
private string GetRoleMenuIDList() { string sResult = ""; foreach (DataRow dr in LDetailDataSet[LDetailDALName.IndexOf("sysRolesRightsDAL")].Tables[0].Rows) { if (dr.RowState != DataRowState.Deleted) { sResult += dr["MenuID"].ToString() + ","; } } if (sResult != "") { sResult = sResult.Substring(0, sResult.Length - 1); } return(sResult); }
private void frmstkGoodInStock_Load(object sender, EventArgs e) { AddDetailData("stkGoodInStockDetailDAL", "MainID", "ID"); gcDetail.DataSource = LDetailDataSet[LDetailDALName.IndexOf("stkGoodInStockDetailDAL")]; gcDetail.DataMember = "ds"; lkpsGoodID.DataBindings.Add("EditValue", LDetailDataSet[LDetailDALName.IndexOf("stkGoodInStockDetailDAL")], "ds.sGoodID"); colbtnsGoodID.ButtonClick += new DevExpress.XtraEditors.Controls.ButtonPressedEventHandler(colbtnsGoodID_ButtonClick); lkpsGoodID.AutoSetValue(ref gvDetail, "sGoodID", "sGoodID"); lkpsGoodID.AutoSetValue(ref gvDetail, "sGoodCName", "sGoodCName"); lkpsGoodID.AutoSetValue(ref gvDetail, "sUnitCName", "sUnitCName"); lkpsGoodID.AutoSetValue(ref gvDetail, "fBasePrice", "fBasePrice"); lkpsGoodID.AutoSetValue(ref gvDetail, "fSalePrice", "fSalePrice"); lkpFlag.AutoSetValue(ref gvMain, "sFlagName", "sFlagName"); lkpsStockInType.AutoSetValue(ref gvMain, "sStockInTypeName", "sDictDataCName"); DataStateChange(sender, e); }
/// <summary> /// 打印收银条 /// </summary> private void PrintBill() { try { if (IsPrint) { report.ShowPrintDialog = false; report.AddReportData((DataRowView)bdsMain.Current, "dtMain"); report.AddReportData(LDetailDataSet[LDetailDALName.IndexOf("stkGoodOutStockDetailDAL")].Tables[0], "dtDetail"); if (BWS.ERP.BasePublic.BasePublic.FormParaList(FormID)["PrintOrPreview"].ToString().ToLower() == "print") { report.PrintReport(); } else { report.PreviewReport(); } } } catch (Exception) { } }
private void frmstkGoodSaleOutStock_KeyDown(object sender, KeyEventArgs e) { try { //按ESC退出 if (e.KeyCode == Keys.Escape) { this.Close(); } //销售员 else if (e.KeyCode == Keys.F1) { lkpsUserID.Focus(); } //会员卡 else if (e.KeyCode == Keys.F2) { txtsVipCardNo.Focus(); } //收款结账 else if (e.KeyCode == Keys.ShiftKey) { if (gvDetail.RowCount > 0) { //去除最后的空行 gvDetail.MoveLast(); if (gvDetail.GetFocusedDataRow()["sGoodID"].ToString() == "") { gvDetail.DeleteRow(gvDetail.FocusedRowHandle); } gvDetail.Columns["fAmount"].SummaryItem.SetSummary(DevExpress.Data.SummaryItemType.Sum, "{0:0.00}"); ((DataRowView)bdsMain.Current).Row["fSaleAmount"] = gvDetail.Columns["fAmount"].SummaryItem.SummaryValue; if (gvDetail.RowCount > 0) { frmstkGoodSaleOutStockCheckOut frm = new frmstkGoodSaleOutStockCheckOut(gvDetail.Columns["fAmount"].SummaryItem.SummaryValue.ToString()); if (frm.ShowDialog() == DialogResult.OK) { ((DataRowView)bdsMain.Current).Row["fPayMoney"] = frm.fPayMoney; bdsMain.EndEdit(); //先打印收银条再保存单据 PrintBill(); //保存,不显示保存提示 ShowSaveInfo = false; btnSave_Click(sender, null); //保存以后再自动新增 btnAdd_Click(sender, null); } } } } //删除交易明细 else if (e.KeyCode == Keys.Delete) { if (gvDetail.FocusedRowHandle >= 0) { gvDetail.DeleteRow(gvDetail.FocusedRowHandle); } } else if (e.KeyCode == Keys.F12) { if (gvDetail.RowCount > 0) { LDetailDataSet[LDetailDALName.IndexOf("stkGoodOutStockDetailDAL")].Tables[0].Clear(); } } } catch (Exception) { } }
public override void MasterAllScroll(object sender, EventArgs e) { base.MasterAllScroll(sender, e); gcRoleUser.DataSource = LDetailDataSet[LDetailDALName.IndexOf("sysRolesUserDAL")]; tvRoleRight.DataSource = LDetailDataSet[LDetailDALName.IndexOf("sysRolesRightsDAL")]; }
public override void MasterAllScroll(object sender, EventArgs e) { base.MasterAllScroll(sender, e); gcDetail.DataSource = LDetailDataSet[LDetailDALName.IndexOf("basDataDictDetailDAL")]; }
public override void MasterAllScroll(object sender, EventArgs e) { base.MasterAllScroll(sender, e); AutoSetFieldNameToComboBox(((DataRowView)(bdsMain.Current))["sReportSQL"].ToString()); gcDetail.DataSource = LDetailDataSet[LDetailDALName.IndexOf("sysQueryReportDetailDAL")]; }
/// <summary> /// 批量设置权限值 /// </summary> /// <param name="value">权限值</param> private void SetAllValue(int value) { switch (sOperationColumn) { case "iView": { if (tvRoleRight.Selection.Count > 1) { foreach (DevExpress.XtraTreeList.Nodes.TreeListNode item in tvRoleRight.Selection) { item.SetValue("iView", value); } } else { foreach (DataRow item in LDetailDataSet[LDetailDALName.IndexOf("sysRolesRightsDAL")].Tables[0].Rows) { if (item.RowState != DataRowState.Deleted) { item["iView"] = value; } } } break; } case "iAdd": { if (tvRoleRight.Selection.Count > 1) { foreach (DevExpress.XtraTreeList.Nodes.TreeListNode item in tvRoleRight.Selection) { item.SetValue("iAdd", value); } } else { foreach (DataRow item in LDetailDataSet[LDetailDALName.IndexOf("sysRolesRightsDAL")].Tables[0].Rows) { if (item.RowState != DataRowState.Deleted) { item["iAdd"] = value; } } } break; } case "iEdit": { if (tvRoleRight.Selection.Count > 1) { foreach (DevExpress.XtraTreeList.Nodes.TreeListNode item in tvRoleRight.Selection) { item.SetValue("iEdit", value); } } else { foreach (DataRow item in LDetailDataSet[LDetailDALName.IndexOf("sysRolesRightsDAL")].Tables[0].Rows) { if (item.RowState != DataRowState.Deleted) { item["iEdit"] = value; } } } break; } case "iDelete": { if (tvRoleRight.Selection.Count > 1) { foreach (DevExpress.XtraTreeList.Nodes.TreeListNode item in tvRoleRight.Selection) { item.SetValue("iDelete", value); } } else { foreach (DataRow item in LDetailDataSet[LDetailDALName.IndexOf("sysRolesRightsDAL")].Tables[0].Rows) { if (item.RowState != DataRowState.Deleted) { item["iDelete"] = value; } } } break; } case "iPrint": { if (tvRoleRight.Selection.Count > 1) { foreach (DevExpress.XtraTreeList.Nodes.TreeListNode item in tvRoleRight.Selection) { item.SetValue("iPrint", value); } } else { foreach (DataRow item in LDetailDataSet[LDetailDALName.IndexOf("sysRolesRightsDAL")].Tables[0].Rows) { if (item.RowState != DataRowState.Deleted) { item["iPrint"] = value; } } } break; } case "iNum": { if (tvRoleRight.Selection.Count > 1) { foreach (DevExpress.XtraTreeList.Nodes.TreeListNode item in tvRoleRight.Selection) { item.SetValue("iNum", value); } } else { foreach (DataRow item in LDetailDataSet[LDetailDALName.IndexOf("sysRolesRightsDAL")].Tables[0].Rows) { if (item.RowState != DataRowState.Deleted) { item["iNum"] = value; } } } break; } case "iPrice": { if (tvRoleRight.Selection.Count > 1) { foreach (DevExpress.XtraTreeList.Nodes.TreeListNode item in tvRoleRight.Selection) { item.SetValue("iPrice", value); } } else { foreach (DataRow item in LDetailDataSet[LDetailDALName.IndexOf("sysRolesRightsDAL")].Tables[0].Rows) { if (item.RowState != DataRowState.Deleted) { item["iPrice"] = value; } } } break; } } }