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;
}
}
}
