/// <summary>
/// 导入Bom单主表资料
/// </summary>
/// <param name="values"></param>
private void ImportBomDetail(System.Array values)
{
int len1 = values.GetLength(0);
int len2 = values.GetLength(1);
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet dsBom = myHelper.GetDs("select * from t_BomDetail");
System.Data.DataTable dt = dsBom.Tables[0];
System.Data.DataTable dtTmp = dt.Copy();
//dt.Columns["F_BillID"].Unique = true;
string strID;
try
{
for (int i = 1; i < len1; i++)
{
strID = values.GetValue(i, 1).ToString();
if (strID.Length == 0)
{
continue;
}
if (dt.Select("F_BillID = '" + strID + "' and ").Length > 0)
{
MessageBox.Show(this, "数据库已存在编码为'" + strID + "'的BOM单号,请检查待导入Excel文件!", "提示");
break;
}
DataRow drNew = dsBom.Tables[0].NewRow();
drNew["F_BillID"] = values.GetValue(i, 1).ToString();
drNew["AID"] = values.GetValue(i, 2).ToString();
drNew["F_ItemID"] = values.GetValue(i, 3).ToString();
drNew["F_Qty"] = values.GetValue(i, 4).ToString();
drNew["F_Waste"] = values.GetValue(i, 5).ToString();
drNew["F_DeptID"] = values.GetValue(i, 6).ToString();
drNew["F_ProcessID"] = values.GetValue(i, 6).ToString();
dsBom.Tables[0].Rows.Add(drNew);
}
myHelper.SaveData(dsBom, "select * from t_BomDetail");
}
catch (Exception E)
{
MessageBox.Show(this, E.Message, "错误");
}
}
private void SetDropSource()
{
string strSQL = "";
strSQL = "select F_ID,F_Name from t_Class where left(F_UPID,2) like '03%'";
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds = myHelper.GetDs(strSQL);
lupControl2.LookUpDataSource = ds.Tables[0].DefaultView;
lupControl2.LookUpDisplayField = "F_Name";
lupControl2.LookUpKeyField = "F_ID";
ds.Dispose();
if (strSelectValue == "销售发货出库")
BindClient();
else
BindSupplier();
}
/// <summary>
/// 提取相关单据
/// </summary>
/// <param name="strType"></param>
public void GetBill(string strType)
{
this.strBillType = strType;
string strSQL = "select * from t_BillImport where F_Type = '" + strType + "'";
DataLib.DataHelper myHelper = new DataLib.DataHelper();
dsTmp = myHelper.GetDs(strSQL);
foreach (DataRow dr in dsTmp.Tables[0].Rows)
{
cbBill.Properties.Items.Add(dr["F_Class"].ToString());
}
if (dsTmp.Tables[0].Rows.Count > 0)
{
cbBill.SelectedIndex = 0;
cbBill_SelectedIndexChanged(null, null);
}
}
public frmEditSendCard()
{
InitializeComponent();
string strSQL = "select F_ID,F_Name,dbo.fn_GetPy(F_Name) as F_Spell from t_Emp";
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet dsEmp = myHelper.GetDs(strSQL);
lupEmp.LookUpDataSource = dsEmp.Tables[0].DefaultView;
lupEmp.LookUpDisplayField = "F_ID";
lupEmp.LookUpKeyField = "F_ID";
lupEmp.LookUpControl.Properties.AutoSearchColumnIndex = 2;
lupEmp.LookUpControl.Properties.SortColumnIndex = 2;
lupEmp.LookUpControl.Properties.SearchMode = DevExpress.XtraEditors.Controls.SearchMode.AutoComplete;
}
protected override void DataBind(string strType)
{
base.DataBind(strType);
string strSQL = @"select a.*,b.F_ID as F_EmpID,b.F_Name as F_EmpName,c.F_Name as F_Dept from t_RealCard a
left join t_Emp b
on a.F_CardNo = b.F_CardNo
left join t_Class c
on c.F_ID = b.F_Type
where a.F_Time >= '" + ucDate1.dtStart.ToString() + @"'
and a.F_Time <= '" + ucDate1.dtEnd.ToString() + @"'
and (b.F_Type = '" + strType + "' or '" + strType + "' = '')";
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds = myHelper.GetDs(strSQL);
gridQuery.DataSource = ds.Tables[0];
}
private void frmBillList_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F7 && DataLib.SysVar.strUGroup == "超级用户")
{
frmSetGrid myGrid = new frmSetGrid();
myGrid.gvSource = gvList;
myGrid.ShowDialog();
myGrid.Dispose();
}
if (e.KeyCode == Keys.F5 && DataLib.SysVar.strUGroup == "超级用户")
{
DataLib.sysClass.SaveGridToDB(gvList, BillTag, cbType.SelectedIndex);
//SaveFieldFormat();
}
if (e.Control == true && e.KeyCode == Keys.F9)
{
frmSQL mySQL = new frmSQL();
mySQL.MeSQL.Text = strQuerySQL;
if (mySQL.ShowDialog() == DialogResult.OK)
{
strQuerySQL = mySQL.MeSQL.Text;
if (BindData() == 0)
{
DataLib.DataHelper myHelper = new DataLib.DataHelper();
string strSQL = "select * from t_SQL where F_Class = '" + BillTag + "' and F_Tag = '" + cbType.SelectedIndex.ToString() + "'";
DataSet ds = myHelper.GetDs(strSQL);
if (ds.Tables[0].Rows.Count == 0)
{
DataRow drNew = ds.Tables[0].NewRow();
drNew["F_Class"] = BillTag;
drNew["F_Tag"] = cbType.SelectedIndex.ToString();
drNew["F_SQL"] = strQuerySQL;
ds.Tables[0].Rows.Add(drNew);
}
else
{
ds.Tables[0].Rows[0]["F_SQL"] = strQuerySQL;
}
myHelper.SaveData(ds, strSQL);
}
}
mySQL.Dispose();
}
}
private void DataBind()
{
string strSQL = @"select '任务' as F_Type,F_Title,F_ExeDate,F_PreFinishDate,F_Task from t_OATask
where CONVERT(varchar(10),F_ExeDate,120) = CONVERT(varchar(10),GETDATE(),120)
and F_EmpID = '" + DataLib.SysVar.strUID + @"'
union all
select '通知',a.F_Title,a.F_ExeDate,'1900-1-1',a.F_Memo from t_OANotice a
left join t_OANoticeEmp b
on a.Aid = b.Aid
where CONVERT(varchar(10),a.F_ExeDate,120) = CONVERT(varchar(10),GETDATE(),120)
and b.F_EmpID = '" + DataLib.SysVar.strUID + "'";
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds = myHelper.GetDs(strSQL);
gcList.DataSource = ds.Tables[0];
}
private void BindData()
{
string strSQL = "select * from t_BalanceType";
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds = myHelper.GetDs(strSQL);
binMain.DataSource = ds.Tables[0].DefaultView;
txtID.DataBindings.Add("EditValue", binMain, "F_ID");
txtName.DataBindings.Add("EditValue", binMain, "F_Name");
spMonth.DataBindings.Add("EditValue", binMain, "F_PayMonth");
spDay.DataBindings.Add("EditValue", binMain, "F_PayDay");
txtRemark.DataBindings.Add("EditValue", binMain, "F_Remark");
rgOption.DataBindings.Add("EditValue", binMain, "F_Type");
spValue.DataBindings.Add("EditValue", binMain, "F_Date");
}
private void DataBind()
{
string strSQL = @"select a.*,b.F_Name,c.F_Name as F_Dept,d.F_Name as F_ClassName from t_UserCard a
left join t_Emp b
on a.F_ID = b.F_ID
left join t_Class c
on b.F_Type = c.F_ID
left join t_SetClass d
on a.F_Class = d.F_ID
where a.F_Date >= '" + ucDate1.dtStart.ToString() + @"'
and a.F_Date <= '" + ucDate1.dtEnd.ToString() + "'";
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds = myHelper.GetDs(strSQL);
gridQuery.DataSource = ds.Tables[0];
}
/// <summary>
/// 取得科目名称
/// </summary>
/// <param name="sID"></param>
/// <returns></returns>
private string GetSubjectName(string sID)
{
string strSQL = "";
strSQL = "select F_ID + '-' + F_Name as F_Name from t_Subject where F_ID = '" + sID + "'";
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds = myHelper.GetDs(strSQL);
if (ds.Tables[0].Rows.Count > 0)
{
return(ds.Tables[0].Rows[0]["F_Name"].ToString());
}
else
{
return("");
}
}
/// <summary>
/// 设置SQL语句
/// </summary>
private void SetSQL()
{
gvReport.Columns.Clear();
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds = myHelper.GetDs("select * from t_UserReport where F_Name = '" + strName + "'");
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["F_SQL"] != Convert.DBNull)
{
strQuerySQL = ds.Tables[0].Rows[0]["F_SQL"].ToString();
DataBind();
}
}
ds.Dispose();
}
/// <summary>
/// 数据绑定
/// </summary>
private void DataBind()
{
string strSQL = "";
strSQL = @"select a.*,b.F_Name,b.F_Type,c.F_Name as F_TypeName from t_GenWage a
left join t_Emp b
on a.F_EmpID = b.F_ID
left join t_Class c
on b.F_Type = c.F_ID
where a.F_Month = '" + GetDate() + @"'
order by b.F_Type,a.F_EmpID";
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds = myHelper.GetDs(strSQL);
this.gcList.DataSource = ds.Tables[0].DefaultView;
}
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);
}
/// <summary>
/// 导入外加工厂商资料
/// </summary>
/// <param name="values"></param>
private void ImportOutSupplier(System.Data.DataTable values)
{
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet dsEmp = myHelper.GetDs("select * from t_OutSupplier");
System.Data.DataTable dt = dsEmp.Tables[0];
dt.Columns["F_ID"].Unique = true;
string strID = "";
foreach (DataRow dr in values.Rows)
{
strID = dr["厂商编码"].ToString();
if (strID == "")
{
continue;
}
if (dt.Select("F_ID = '" + strID + "'").Length > 0)
{
MessageBox.Show(this, "数据库已存在编码为'" + strID + "'的外加工厂商,请检查待导入Excel文件!", "提示");
break;
}
DataRow drNew = dt.NewRow();
drNew["F_ID"] = strID;
drNew["F_Name"] = dr["厂商名称"];
drNew["F_Type"] = dr["类别编码"];
drNew["F_LinkMan"] = dr["联系人"];
drNew["F_Tel"] = dr["电话"];
drNew["F_OtherTel"] = dr["其它电话"];
drNew["F_Bank"] = dr["银行"];
drNew["F_BankNo"] = dr["银行帐号"];
drNew["F_PostCode"] = dr["邮编"];
drNew["F_Adr"] = dr["地址"];
drNew["F_Remark"] = dr["备注"];
drNew["F_Use"] = true;
drNew["F_QcMoney"] = dr["期初"];
drNew["F_PreMoney"] = dr["预付"];
dt.Rows.Add(drNew);
}
myHelper.SaveData(dsEmp, "select * from t_OutSupplier");
}
/// <summary>
/// 直接打印报表
/// </summary>
protected virtual void PrintReport()
{
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.DoPrint(this.Text, plZer, this.printingSystem);
}
/// <summary>
/// 销售退货明细
/// </summary>
private void BindSellBackDetail(string strID)
{
string strSQL = "";
strSQL = "select a.*,c.F_Name,c.F_Spec,c.F_Brand,c.F_Material ";
strSQL = strSQL + "from t_SellBackDetail a ";
strSQL = strSQL + "left join t_SellBack b ";
strSQL = strSQL + "on a.F_BillID = b.F_BillID ";
strSQL = strSQL + "left join t_Item c ";
strSQL = strSQL + "on a.F_ItemID = c.F_ID ";
strSQL = strSQL + "where b.F_ClientID = '" + strID + "'";
strSQL = strSQL + " and b.F_Check = 1 ";
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds = myHelper.GetDs(strSQL);
gvSellBack.Columns.Clear();
gcSellBack.DataSource = ds.Tables[0].DefaultView;
}
private void ReadCard()
{
Int64 iSerialNo = 0;
IntPtr hPort = EastRiver.OpenCommPort(iPort, iRate);
if (EastRiver.ReadICCardSerialNo(hPort, ref iSerialNo, true) == true)
{
editControl1.SetValue(iSerialNo.ToString());
string sSQL = "select F_ID,F_Name from t_Emp where F_CardNo = '" + iSerialNo.ToString() + "'";
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet dsEmp = myHelper.GetDs(sSQL);
if (dsEmp.Tables[0].Rows.Count > 0)
{
editControl4.SetValue(dsEmp.Tables[0].Rows[0]["F_ID"].ToString());
editControl2.SetValue(dsEmp.Tables[0].Rows[0]["F_Name"].ToString());
}
}
}
private void FillEmp(string sGroup)
{
string strSQL = "select F_ID,F_Name from t_Emp where F_Group = '" + sGroup + "' and isnull(F_Out,0) = 0";
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds = myHelper.GetDs(strSQL);
DataTable dt = ((DataView)gcEmp.DataSource).Table;
dt.Clear();
foreach (DataRow dr in ds.Tables[0].Rows)
{
DataRow drNew = dt.NewRow();
drNew["F_EmpID"] = dr["F_ID"];
drNew["F_Name"] = dr["F_Name"];
dt.Rows.Add(drNew);
}
}
public static MemoryStream LoadFormDB(string CurrentForm)
{
string SQL = "select * from t_FormFormat where F_FormName = '" + CurrentForm + "'";
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds = myHelper.GetDs(SQL);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["F_Stream"] == DBNull.Value)
{
return(null);
}
MemoryStream stream = new MemoryStream((byte[])ds.Tables[0].Rows[0]["F_Stream"]);
return(stream);
}
return(null);
}
public static bool TestCastValid(string sItemID, ref int iDay)
{
string sSQL = @"select top 1 DATEDIFF(day,getdate(),a.F_End) as F_Day
from t_Cast a,t_CastDetail b
where a.F_ID = b.F_ID
and b.F_ItemID = '" + sItemID + @"'
and DATEDIFF(day,getdate(),a.F_End) <= 30";
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds = myHelper.GetDs(sSQL);
if (ds.Tables[0].Rows.Count == 0)
{
return(false);
}
iDay = Convert.ToInt32(ds.Tables[0].Rows[0]["F_Day"]);
return(true);
}
private void FillSubject()
{
string strSQL = "select F_ID,F_Name,F_Direction from t_Subject";
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds = myHelper.GetDs(strSQL);
foreach (DataRow dr in ds.Tables[0].Rows)
{
DataRow drNew = ((DataRowView)binCW.AddNew()).Row;
drNew["F_Init"] = true;
drNew["F_Year"] = DateTime.Now.Year;
drNew["F_Month"] = DateTime.Now.Month;
drNew["F_Subject"] = dr["F_ID"];
drNew["F_SubjectName"] = dr["F_Name"];
drNew.EndEdit();
}
}
private decimal GetWorkPrice(string sItemID, string sDeptID, string sProceID)
{
string strSQL = @"select isnull(F_WorkPrice,0) from t_ProductProcess a,t_ProductProcessDetail b
where a.F_BillID = b.F_BillID
and a.F_ItemID = '" + sItemID + @"'
and b.F_DeptID = '" + sDeptID + @"'
and b.F_ProcessID = '" + sProceID + "'";
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds = myHelper.GetDs(strSQL);
if (ds.Tables[0].Rows.Count == 0)
{
return(0);
}
return(Convert.ToDecimal(ds.Tables[0].Rows[0][0]));
}
/// <summary>
/// 绑定员工资料
/// </summary>
private void DataBind()
{
string strSQL = "";
if (strDept == "")
{
strSQL = "select a.*,b.F_Name as F_GroupName from t_Emp a,t_WorkGroup b where a.F_Group = b.F_ID";
}
else
{
strSQL = "select a.*,b.F_Name as F_GroupName from t_Emp a,t_WorkGroup b where a.F_Group = b.F_ID and a.F_Type = '" + strDept + "'";
}
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds = myHelper.GetDs(strSQL);
gcMain.DataSource = ds.Tables[0].DefaultView;
}
/// <summary>
/// 授权
/// </summary>
private void SaveRight()
{
string strSQL = "select * from t_RightDetail where F_Group = '" + lbGroup.Text.ToString() + "' and F_Class = '" + tvRight.SelectedNode.Tag.ToString() + "'";
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds = myHelper.GetDs(strSQL);
DataTable dt = ds.Tables[0];
DataRow drField;
int intCnt = ckRight.Items.Count;
for (int i = 0; i < intCnt; i++)
{
DataRow[] dr = dt.Select("F_Name = '" + ckRight.Items[i].Value.ToString() + "'");
if (dr.Length == 0)
{
drField = dt.NewRow();
drField["F_Group"] = lbGroup.Text.ToString();
drField["F_Class"] = tvRight.SelectedNode.Tag.ToString();
drField["F_Name"] = ckRight.Items[i].Value.ToString();
if (ckRight.Items[i].CheckState == CheckState.Checked)
{
drField["F_Enable"] = true;
}
else
{
drField["F_Enable"] = false;
}
dt.Rows.Add(drField);
}
else
{
drField = dr[0];
if (ckRight.Items[i].CheckState == CheckState.Checked)
{
drField["F_Enable"] = true;
}
else
{
drField["F_Enable"] = false;
}
}
}
myHelper.SaveData(ds, strSQL);
}
/// <summary>
/// 绑定明细权限
/// </summary>
private void BindDetailRight()
{
if (gvModule.FocusedRowHandle < 0)
{
return;
}
if (gvUser.FocusedRowHandle < 0)
{
return;
}
DataRow drModule = gvModule.GetDataRow(gvModule.FocusedRowHandle);
DataRow drUser = gvUser.GetDataRow(gvUser.FocusedRowHandle);
string strSQL = "select * from t_DetailRight where F_UID = '" + drUser["F_ID"].ToString() + "' and F_Module = '" + drModule["F_ID"].ToString() + "'";
DataLib.DataHelper myHelp = new DataLib.DataHelper();
DataSet ds = myHelp.GetDs(strSQL);
GridRight.DataSource = ds.Tables[0].DefaultView;
}
/// <summary>
/// 将选定BOM单明细填入领料单中
/// </summary>
private int FillBom()
{
if (editControl6.GetValue() == DBNull.Value)
{
return(-1);
}
string strItemID = editControl6.GetValue().ToString();
string strSQL = @"select b.F_ID,b.F_Name,b.F_Spec,b.F_Color,b.F_Brand,b.F_Material,
a.F_Unit,b.F_StockPrice,b.F_StorageID,isnull(a.F_ActuQty,0) as F_ActuQty
from t_BomDetail a,t_Item b,t_Bom c
where a.F_ItemID = b.F_ID
and a.F_BillID = c.F_BillID
and c.F_ItemID = '" + strItemID + "'";
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet dsBomDetail = myHelper.GetDs(strSQL);
DataTable dtBill = ((DataView)binSlaver.DataSource).Table;
while (binSlaver.Count > 0)
{
binSlaver.RemoveCurrent();
}
foreach (DataRow dr in dsBomDetail.Tables[0].Rows)
{
DataRow drNew = dtBill.NewRow();
drNew["F_ItemID"] = dr["F_ID"];
drNew["F_ItemName"] = dr["F_Name"];
drNew["F_Spec"] = dr["F_Spec"];
drNew["F_Color"] = dr["F_Color"];
drNew["F_Brand"] = dr["F_Brand"];
drNew["F_Material"] = dr["F_Material"];
drNew["F_Unit"] = dr["F_Unit"];
drNew["F_Price"] = dr["F_StockPrice"];
drNew["F_StorageID"] = dr["F_StorageID"];
drNew["F_Qty"] = Convert.ToDecimal(dr["F_ActuQty"]) * Convert.ToDecimal(spinControl1.GetValue());
dtBill.Rows.Add(drNew);
}
return(1);
}
/// <summary>
/// 库存重算操作方法,主要执行存储过程sp_AdjustStorage
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void sbOK_Click(object sender, EventArgs e)
{
string strSQL = "";
DateTime dtValue = Convert.ToDateTime(dtMonth.EditValue);
string strYear = dtValue.Year.ToString();
string strMonth = dtValue.Month.ToString().PadLeft(2, '0');
string strValue = strYear + strMonth;
strSQL = "select top 1 * from t_StorageCheck where F_Month = '" + strValue + "'";
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds = myHelper.GetDs(strSQL);
if (ds.Tables[0].Rows.Count > 0)
{
MessageBox.Show("本月已结过帐,不能进行重算!!");
return;
}
ds.Dispose();
if (MessageBox.Show(this, "真的要进行库存重算吗,运算时间取决于数据量！！", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No)
{
return;
}
dtMonth.Enabled = false;
sbOK.Enabled = false;
lbFlag.Visible = true;
this.Update();
try
{
strSQL = "exec sp_AdjustStorage '" + dtMonth.EditValue.ToString() + "'";
if (myHelper.ExecuteSQL(strSQL) == 0)
{
MessageBox.Show("库存重算操作成功!!");
}
}
finally
{
dtMonth.Enabled = true;
sbOK.Enabled = true;
lbFlag.Visible = false;
}
}
private void CheckOut()
{
if (MessageBox.Show(this, "真的要对本期间进行结帐吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No)
{
return;
}
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds = myHelper.GetDs("select * from t_User where F_ID = '" + DataLib.SysVar.strUID + "' and F_Psw = '" + textBox1.Text + "'");
if (ds.Tables[0].Rows.Count == 0)
{
MessageBox.Show(this, "用户密码错误，请检查!!", "提示");
return;
}
if (myHelper.ExecuteSQL("exec sp_CashCheckOut " + spYear.Value.ToString() + "," + spMonth.Value.ToString()) == 0)
{
MessageBox.Show(this, "出纳结帐成功!!", "提示");
}
}
/// <summary>
/// 添加生产任务单明细
/// </summary>
private void AddTaskDetail()
{
string strSQL;
DataTable dt = ((DataView)gcTaskTmp.DataSource).Table;
DataLib.DataHelper myHelper = new DataLib.DataHelper();
int intCnt = gvTaskMain.RowCount;
for (int i = 0; i < intCnt; i++)
{
DataRow dr = gvTaskMain.GetDataRow(i);
if (Convert.ToBoolean(dr["F_Select"]) == false)
{
continue;
}
string strBill = dr["F_BillID"].ToString();
strSQL = "select F_BillID,Aid,F_ItemID,b.F_Name as F_ItemName,b.F_Spec,a.F_Unit,a.F_Qty ";
strSQL = strSQL + "from t_TaskGoods a,t_Item b ";
strSQL = strSQL + "where a.F_ItemID = b.F_ID ";
strSQL = strSQL + "and F_BillID = '" + strBill + "'";
DataSet ds = myHelper.GetDs(strSQL);
foreach (DataRow drItem in ds.Tables[0].Rows)
{
DataRow[] drTmp = dt.Select("(F_BillID = '" + drItem["F_BillID"].ToString() + "') and (Aid = " + drItem["Aid"].ToString() + ")");
if (drTmp.Length > 0)
{
continue;
}
DataRow drNew = dt.NewRow();
drNew["F_Select"] = false;
drNew["F_BillID"] = drItem["F_BillID"];
drNew["Aid"] = drItem["Aid"];
drNew["F_ItemID"] = drItem["F_ItemID"];
drNew["F_ItemName"] = drItem["F_ItemName"];
drNew["F_Spec"] = drItem["F_Spec"];
drNew["F_Unit"] = drItem["F_Unit"];
drNew["F_Qty"] = drItem["F_Qty"];
dt.Rows.Add(drNew);
}
}
}
private void sbExport_Click(object sender, EventArgs e)
{
if (DataLib.SysVar.strUGroup != "超级用户")
{
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds = myHelper.GetDs("select F_Export from t_UserGroup where F_Group = '" + DataLib.SysVar.strUGroup + "'");
if (Convert.ToBoolean(ds.Tables[0].Rows[0][0]) == false)
{
MessageBox.Show(this, "你没有权限!", "提示");
return;
}
}
string strFile = DataLib.sysClass.ShowSaveFileDialog("Excel 文件", "Excel 文件|*.Xls");
if (strFile != "")
{
Chart.ExportToXls(strFile);
}
}
