private void SetInfo() { if (lupAccount.EditValue == DBNull.Value) { return; } DataRow dr = ((DataRowView)lupAccount.Properties.GetDataSourceRowByDisplayValue(lupAccount.Text)).Row; //DataLib.SysVar.strSysCon = "Data Source=.;Initial Catalog=" + dr["FDBName"].ToString() + ";Persist Security Info=True;User ID=" + DataLib.SysVar.strLogID + ";Password="******"."; if (DataLib.SysVar.strServer == "localhost") { DataLib.sysClass myClass = new DataLib.sysClass(); string[] strIP = myClass.GetIP(); strHost = strIP[0]; } else { strHost = DataLib.SysVar.strServer; } DataLib.DataHelper myHelper = new DataLib.DataHelper(); myHelper.SetPrintInfo(); DataLib.SysVar.strDB = dr["FDBName"].ToString(); DataLib.SysVar.strCon = "Provider=SQLOLEDB.1;Password="******";Persist Security Info=False;User ID=" + DataLib.SysVar.strLogID + ";Initial Catalog=" + dr["FDBName"].ToString() + ";Data Source=" + strHost; // MessageBox.Show(DataLib.SysVar.strCon); }
private void frmBomEdit_Shown(object sender, EventArgs e) { strBillFlag = "BM"; strMTable = "t_Bom"; strMasterSQL = "select * from t_Bom where F_BillID = @Value"; strSlaverSQL = @"select a.*,b.F_Name as F_ItemName,b.F_Spec,b.F_Brand,b.F_Color,b.F_StockPrice as F_Price from t_BomDetail a,t_Item b where a.F_ItemID = b.F_ID and F_BillID = '" + strBillID + @"' order by a.Aid"; strSaveSlaverSQL = "select * from t_BomDetail where F_BillID = @Value"; if (strBillID == "") { NewBill(); if (strItemID != "") { CopyBom(); } } else { BindData(); DataRow dr = ((DataRowView)binMaster.Current).Row; DataLib.sysClass myClass = new DataLib.sysClass(); DataRow drItem = myClass.FindItem(dr["F_ItemID"].ToString()); if (drItem != null) { editControl7.SetValue(drItem["F_Name"].ToString()); editControl8.SetValue(drItem["F_Spec"].ToString()); editControl9.SetValue(drItem["F_Unit"].ToString()); } } }
private void sbOK_Click(object sender, EventArgs e) { if (gvAccount.FocusedRowHandle < 0) { return; } DataRow dr = gvAccount.GetDataRow(gvAccount.FocusedRowHandle); //DataLib.SysVar.strSysCon = "Data Source=.;Initial Catalog=" + dr["FDBName"].ToString() + ";Persist Security Info=True;User ID=" + DataLib.SysVar.strLogID + ";Password="******"."; if (DataLib.SysVar.strServer == "localhost") { DataLib.sysClass myClass = new DataLib.sysClass(); string[] strIP = myClass.GetIP(); strHost = strIP[0]; } else { strHost = DataLib.SysVar.strServer; } DataLib.DataHelper myHelper = new DataLib.DataHelper(); myHelper.SetPrintInfo(); DataLib.SysVar.strDB = dr["FDBName"].ToString(); DataLib.SysVar.strCon = "Provider=SQLOLEDB.1;Password="******";Persist Security Info=False;User ID=" + DataLib.SysVar.strLogID + ";Initial Catalog=" + dr["FDBName"].ToString() + ";Data Source=" + strHost; this.DialogResult = DialogResult.OK; }
private void frmInstall_Shown(object sender, EventArgs e) { strBillFlag = "IT"; strMTable = "t_Install"; strMasterSQL = "select * from t_Install where F_BillID = @Value"; strSlaverSQL = "select a.*,b.F_Name as F_ItemName,b.F_Spec,F_Material,b.F_Brand,(select F_Name from t_Class where F_ID = b.F_Type) as F_Type "; strSlaverSQL = strSlaverSQL + "from t_InstallDetail a,t_Item b "; strSlaverSQL = strSlaverSQL + "where a.F_ItemID = b.F_ID "; strSlaverSQL = strSlaverSQL + "and F_BillID = @Value"; strSaveSlaverSQL = "select * from t_InstallDetail where F_BillID = @Value"; SetDropSource(); if (strBillID == "") { NewBill(); } else { BindData(); DataRow dr = ((DataRowView)binMaster.Current).Row; DataLib.sysClass myClass = new DataLib.sysClass(); DataRow drItem = myClass.FindItem(dr["F_ItemID"].ToString()); if (drItem != null) { editControl7.SetValue(drItem["F_Name"].ToString()); editControl8.SetValue(drItem["F_Spec"].ToString()); } } }
/// <summary> /// 预览 /// </summary> protected virtual void Print() { PreviewLocalizer plZer = new XtraChinese.DxperienceXtraPrintingLocalizationCHS(); DataLib.sysClass myClass = new DataLib.sysClass(); myClass.DoPreview(this.Text, plZer, this.printingSystem); }
private void btnPreview_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { PreviewLocalizer plZer = new XtraChinese.DxperienceXtraPrintingLocalizationCHS(); DataLib.sysClass myClass = new DataLib.sysClass(); myClass.DoPreview(this.Text, plZer, this.printingSystem); }
private void frmProductProcess_Shown(object sender, EventArgs e) { strBillFlag = "PS"; strMTable = "t_ProductProcess"; strMasterSQL = "select * from t_ProductProcess where F_BillID = @Value"; strSlaverSQL = "select * from t_ProductProcessDetail where F_BillID = @Value"; strSaveSlaverSQL = "select * from t_ProductProcessDetail where F_BillID = @Value"; SetDropSource(); if (strBillID == "") { NewBill(); } else { BindData(); DataRow dr = ((DataRowView)binMaster.Current).Row; DataLib.sysClass myClass = new DataLib.sysClass(); DataRow drItem = myClass.FindItem(dr["F_ItemID"].ToString()); if (drItem != null) { editControl7.SetValue(drItem["F_Name"].ToString()); editControl8.SetValue(drItem["F_Spec"].ToString()); editControl9.SetValue(drItem["F_Unit"].ToString()); } } }
private void sbView_Click(object sender, EventArgs e) { DataRow dr = ((DataRowView)binData.Current).Row; DataLib.sysClass myClass = new DataLib.sysClass(); myClass.LoadFileFromDr(dr, "F_FileName", "F_File"); }
private void PrintReport(int iFlag) { if (DataLib.SysVar.strUGroup != "超级用户") { DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs("select isnull(F_Print,0) as F_Print from t_UserGroup where F_Group = '" + DataLib.SysVar.strUGroup + "'"); if (Convert.ToBoolean(ds.Tables[0].Rows[0][0]) == false) { MessageBox.Show(this, "你没有权限!", "提示"); return; } } PreviewLocalizer plZer = new Common.XtraChinese.DxperienceXtraPrintingLocalizationCHS(); DataLib.sysClass myClass = new DataLib.sysClass(); if (iFlag == 0) { myClass.DoPreview(this.Text, plZer, this.printingSystem); } else { myClass.DoPrint(this.Text, plZer, this.printingSystem); } }
/// <summary> /// 预览 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void tbPreview_Click(object sender, EventArgs e) { PreviewLocalizer plZer = new Common.XtraChinese.DxperienceXtraPrintingLocalizationCHS(); DataLib.sysClass myClass = new DataLib.sysClass(); myClass.DoPreview(this.Text, plZer, this.printingSystem); }
private void SlaverBtnClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { Common.frmSelItem mySelItem = new Common.frmSelItem(); mySelItem.myBill = this; if (mySelItem.ShowDialog() == DialogResult.OK) { DataRow dr; DataRow drCurrent = ((DataRowView)binItem.Current).Row; DataLib.sysClass myClass = new DataLib.sysClass(); if (mySelItem.TabControl.SelectedTabPageIndex == 0) { dr = mySelItem.gvMain.GetDataRow(mySelItem.gvMain.FocusedRowHandle); myClass.GetItem(dr["F_ID"].ToString(), 0, drCurrent, this.Name); gvItem.UpdateCurrentRow(); } else { dr = mySelItem.gvStore.GetDataRow(mySelItem.gvStore.FocusedRowHandle); myClass.GetStoreItem(dr, 0, drCurrent, this.Name); gvItem.UpdateCurrentRow(); } } mySelItem.Dispose(); }
/// <summary> /// 打印 /// </summary> private void Print() { // DevExpress.XtraPrinting.Localization.PreviewLocalizer plZer = new DevExpress.LocalizationCHS.DevExpressXtraPrintingLocalizationCHS(); // PreviewLocalizer plZer = new Common.XtraChinese.DxperienceXtraPrintingLocalizationCHS(); DataLib.sysClass myClass = new DataLib.sysClass(); // myClass.DoPrint(this.Text, plZer, this.printingSystem); myClass.DoPrint2(this.Text, this.printingSystem); }
/// <summary> /// 预览 /// </summary> private void Preview() { if (TestRight("预览", this.Name) == false) { return; } //PreviewLocalizer plZer = new Common.XtraChinese.DxperienceXtraPrintingLocalizationCHS(); DataLib.sysClass myClass = new DataLib.sysClass(); myClass.DoPreview2(this.Text, this.printingSystem); }
private void sbSelItem_Click(object sender, EventArgs e) { Common.frmSelItem mySelItem = new Common.frmSelItem(); mySelItem.intTag = 1; DataRow dr = null; if (mySelItem.ShowDialog() == DialogResult.OK) { if (mySelItem.TabControl.SelectedTabPageIndex == 0) { if (mySelItem.gvMain.FocusedRowHandle >= 0) { dr = mySelItem.gvMain.GetDataRow(mySelItem.gvMain.FocusedRowHandle); DataLib.sysClass myClass = new DataLib.sysClass(); DataRow drItem = myClass.FindItem(dr["F_ID"].ToString()); DataTable dt = ((DataView)binMaster.DataSource).Table; DataRow drNew = dt.Rows[0]; drNew["F_ItemID"] = drItem["F_ID"]; editControl7.SetValue(drItem["F_Name"].ToString()); editControl8.SetValue(drItem["F_Spec"].ToString()); drNew["F_Unit"] = drItem["F_Unit"]; drNew["F_StorageID"] = drItem["F_StorageID"]; drNew["F_Color"] = drItem["F_Color"]; drNew["F_Grade"] = drItem["F_Grade"]; binMaster.EndEdit(); } } else { if (mySelItem.gvStore.FocusedRowHandle >= 0) { dr = mySelItem.gvStore.GetDataRow(mySelItem.gvStore.FocusedRowHandle); //DataLib.sysClass myClass = new DataLib.sysClass(); //DataRow drItem = myClass.FindItem(dr["F_ID"].ToString()); DataTable dt = ((DataView)binMaster.DataSource).Table; DataRow drNew = dt.Rows[0]; drNew["F_ItemID"] = dr["F_ID"]; editControl7.SetValue(dr["F_Name"].ToString()); editControl8.SetValue(dr["F_Spec"].ToString()); drNew["F_Unit"] = dr["F_Unit"]; drNew["F_StorageID"] = dr["F_StorageID"]; drNew["F_BatchNo"] = dr["F_BatchNo"]; drNew["F_Color"] = dr["F_Color"]; drNew["F_Grade"] = dr["F_Grade"]; binMaster.EndEdit(); } } } mySelItem.Dispose(); }
/// <summary> /// 大二进制文件处理 /// </summary> /// <param name="intFlag"></param> /// <param name="intTag"></param> private void SaveOrOpenFile(int intFlag, int intTag) { DataRow dr = ((DataRowView)binSource.Current).Row; DataLib.sysClass myClass = new DataLib.sysClass(); if (intFlag == 0) { myClass.SaveFileToDr(dr, intTag); } else { myClass.LoadFileFromDr(dr, intTag); } }
private void sbAdd_Click(object sender, EventArgs e) { DataLib.sysClass myClass = new DataLib.sysClass(); if (myClass.TestRight("frmEditUser") == false) { return; } frmEditUser myEditUser = new frmEditUser(); myEditUser.DataBind(""); if (myEditUser.ShowDialog() == DialogResult.OK) { DataBind(); } myEditUser.Dispose(); }
private void btnPreview_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (DataLib.SysVar.strUGroup != "超级用户") { DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs("select isnull(F_Print,0) as F_Print from t_UserGroup where F_Group = '" + DataLib.SysVar.strUGroup + "'"); if (Convert.ToBoolean(ds.Tables[0].Rows[0][0]) == false) { MessageBox.Show(this, "你没有权限!", "提示"); return; } } PreviewLocalizer plZer = new XtraChinese.DxperienceXtraPrintingLocalizationCHS(); DataLib.sysClass myClass = new DataLib.sysClass(); myClass.DoPreview(this.Text, plZer, this.printingSystem); }
private void sbDel_Click(object sender, EventArgs e) { DataLib.sysClass myClass = new DataLib.sysClass(); if (myClass.TestRight("frmEditUser") == false) { return; } if (gvMain.FocusedRowHandle < 0) { return; } if (MessageBox.Show(this, "真的要删除选定用户吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No) { return; } DataLib.DataHelper myHelper = new DataLib.DataHelper(); if (myHelper.ExecuteSQL("delete from t_User where F_ID = '" + gvMain.GetRowCellValue(gvMain.FocusedRowHandle, "F_ID").ToString() + "'") == 0) { gvMain.DeleteRow(gvMain.FocusedRowHandle); } }
private void sbEdit_Click(object sender, EventArgs e) { DataLib.sysClass myClass = new DataLib.sysClass(); if (myClass.TestRight("frmEditUser") == false) { return; } if (gvMain.FocusedRowHandle < 0) { return; } DataRow dr = gvMain.GetDataRow(gvMain.FocusedRowHandle); frmEditUser myEditUser = new frmEditUser(); myEditUser.DataBind(dr["F_ID"].ToString()); if (myEditUser.ShowDialog() == DialogResult.OK) { DataBind(); } myEditUser.Dispose(); }
private void ItemBtnClick1(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { Common.frmSelItem mySelItem = new Common.frmSelItem(); if (mySelItem.ShowDialog() == DialogResult.OK) { if (mySelItem.gvMain.FocusedRowHandle >= 0) { DataRow dr; if (mySelItem.TabControl.SelectedTabPageIndex == 0) { dr = mySelItem.gvMain.GetDataRow(mySelItem.gvMain.FocusedRowHandle); } else { dr = mySelItem.gvStore.GetDataRow(mySelItem.gvStore.FocusedRowHandle); } DataLib.sysClass myClass = new DataLib.sysClass(); DataRow drTmp = myClass.FindItem(dr["F_ID"].ToString()); if (drTmp == null) { return; } DataRow drItem = ((DataRowView)binItem.Current).Row; drItem["F_ItemID"] = drTmp["F_ID"]; drItem["F_ItemName"] = drTmp["F_Name"]; drItem["F_Spec"] = drTmp["F_Spec"]; drItem["F_Brand"] = drTmp["F_Brand"]; drItem["F_Material"] = drTmp["F_Material"]; drItem["F_Type"] = drTmp["F_TypeName"]; drItem["F_Unit"] = drTmp["F_Unit"]; binItem.EndEdit(); } } mySelItem.Dispose(); }
public void NewBill() { //DataTable dt = ((DataView)binMaster.DataSource).Table; DataRow dr = ((DataRowView)binMaster.AddNew()).Row; DataLib.sysClass myClass = new DataLib.sysClass(); //dr["F_BillID"] = myClass.GetMaxCode(strBillFlag); dr["F_Date"] = DataLib.SysVar.GetDate(); dr["F_BillMan"] = DataLib.SysVar.strUName; dr["F_Checker"] = ""; dr["F_Order"] = GetMaxOrder(DataLib.SysVar.GetDate()); dr["F_Annex"] = GetMaxOrder(DataLib.SysVar.GetDate()); //dr["F_CheckDate"] = "1900-1-1"; dr["F_Check"] = false; dr["F_Record"] = false; dr["F_Key"] = "转"; //DataLib.SysVar.SetLog(this.Text, "新增", "单号为" + dr["F_BillID"].ToString()); binMaster.EndEdit(); Status(0); }
private void txtBarCode_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { DataLib.sysClass myClass = new DataLib.sysClass(); DataRow dr = null; if (myBill.binSlaver.Count == 0) { dr = ((DataRowView)myBill.binSlaver.AddNew()).Row; } else { dr = ((DataRowView)myBill.binSlaver.Current).Row; } if (myClass.GetItem(txtBarCode.Text, 1, dr, myBill.Name) == false) { txtBarCode.SelectAll(); } else { txtBarCode.Text = ""; } } }
/// <summary> /// 取最大资料编号 /// </summary> /// <param name="strTag"></param> /// <returns></returns> protected string GetMaxCode(string strTag, string strTable) { DataLib.sysClass myClass = new DataLib.sysClass(); return(myClass.GetMaxCode(strTag, "F_ID", strTable)); }