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