using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Runtime.InteropServices; using gregn6Lib; using DBUtility; using SQLHelper; namespace WarM { public partial class Kf_UnCheckMoveStockBill_TB : Form //简单报表－直接有一个存储过程＋简单过滤，返回生成报表 { public Kf_UnCheckMoveStockBill_TB() { InitializeComponent(); } public string ModName = ""; public string ModCaption = "淘宝仓需求数量列表"; Pub_Class.ClsGridListSum oSumGrid = new Pub_Class.ClsGridListSum(); #region 固定代码 private void initGrid() { DBUtility.Xt_BaseBillFun.initGridRpt(grdMain, this.Name); } //得到对应列 private Int32 Fun_GetCol(string sCol) { return DBUtility.Xt_BaseBillFun.Fun_GetCol(sCol, grdMain); } private void tc_Click(object sender, EventArgs e) { this.Close(); } //Kf_UnCheckMoveStockBill_TBDlg oDlg = new Kf_UnCheckMoveStockBill_TBDlg(); private void cx_Click(object sender, EventArgs e) { //oDlg.ShowDialog(); //if (oDlg.IsOk == 1) //{ timer1.Enabled = true; //} } //设置报表名称 private void SetFormCaption() { this.Text = ModCaption; lblCaption.Text = this.Text; initGrid();//网格标题初始化 initHeadCaption();//表头初始化 } private void Frm_EasyReport_Load(object sender, EventArgs e) { SetFormCaption(); oSumGrid.ogrdMain = grdMain; //初始化 new oSumGrid.oGridsum = grdSum; } private void timer1_Tick(object sender, EventArgs e) { timer1.Enabled = false; if (Fun_AllowQuery()) { initGrid(); Xt_Wait oFrm = new Xt_Wait(); oFrm.Show(); System.Windows.Forms.Application.DoEvents(); Display(); System.Windows.Forms.Application.DoEvents(); oFrm.Close(); oFrm.Dispose(); } } private void Xs_SellOutPriceReport_KeyUp(object sender, KeyEventArgs e) { if (e.KeyValue == 13) timer1.Enabled = true; } private void mrlk_Click(object sender, EventArgs e) { DBUtility.Xt_BaseBillFun.DefaultGridView(grdMain, this.Name); } private void bclk_Click(object sender, EventArgs e) { //保存列宽 DBUtility.Xt_BaseBillFun.SaveGrid(grdMain, this.Name); } //打印 private void dy_Click(object sender, EventArgs e) { Sub_SetReport(); Report.Print(true); } //预览 private void view_Click(object sender, EventArgs e) { Sub_SetReport(); Report.PrintPreview(true); } #endregion #region 界面处理 //初始化表头显示 private void initHeadCaption() { } private bool Fun_AllowQuery()//审核查询条件 { //if (txtHBDeptID.Text.Trim().Length == 0) //{ // MessageBox.Show(this, "请选择开始部门！", "提示"); // return false; //} return true; } private void Display() { ClsCN SubCn = new ClsCN(); DataSet DSet = new DataSet(); //显示报表头 标题 //停止GRID刷新 加快速度 //显示过滤条件 //过滤条件Dlg string sDlgWhere = ""; if (sDlgWhere.Trim().Length > 0) { sDlgWhere = sDlgWhere.Substring(1, sDlgWhere.Length - 1); } // DSet = SubCn.RunProcReturn("exec h_p_Kf_UnCheckMoveStockBill_TB " + sDlgWhere, "Gy_Czygl", ref Pub_Class.ClsPub.sExeReturnInfo); //生成首行标题 if (DSet == null) { MessageBox.Show("没有返回任何结果,尝试再次查询！" + DBUtility.ClsPub.sExeReturnInfo); return; } // grdMain.DataSource = DSet.Tables[0].DefaultView; //设置合计列 string sTotalCol = ""; sTotalCol = DBUtility.Gy_BaseFun.GetTotalCols(DSet); string[] sT; sT = sTotalCol.Split(Convert.ToChar(",")); oSumGrid.BuildTotalCols(sT); // DBUtility.Xt_BaseBillFun.DisplayGrid(grdMain, this.Name, "是", 0); // DBUtility.Xt_BaseBillFun.GetGrid(grdMain, this.Name); Total(); } #endregion #region 打印设置 //打印设置 GridppReport Report; //设置打印模版路径 private void Sub_SetReport() { Report = new GridppReport(); Report.LoadFromFile(ClsPub.AppPath + @"\Report\应收款明细表.grf"); //here . Report.BeforePostRecord += new _IGridppReportEvents_BeforePostRecordEventHandler(ReportBeforePostRecord); Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ReportFetchRecordByDataTable); } //填入单据表头信息 private void ReportBeforePostRecord()//your report?kao { //Report.FieldByName("HDateItemID").AsString = lblHDateItemID.Text; //Report.FieldByName("CusNumber").AsString = lblHCusNumber.Text; //Report.FieldByName("CusName").AsString = lblHCusName.Text; //Report.FieldByName("BeginBalance").AsString = lblHBeginBalance.Text; } //填入单据明细信息 private void ReportFetchRecordByDataTable() { //BLL.Utility.FillRecordToReport(Report, grdMain, false); } #endregion #region 数据导出 private void yc_Click(object sender, EventArgs e) { } #endregion private void timer2_Tick(object sender, EventArgs e) { timer2.Enabled = false; //oDlg.ShowDialog(); //if (oDlg.IsOk == 1) //{ timer1.Enabled = true; //} } private void Total() { if (grdMain.Rows.Count > 0 && grdMain.ColumnCount > 0) { oSumGrid.SetGridsum(); oSumGrid.Total(); } } private void grdMain_CellMouseUp(object sender, DataGridViewCellMouseEventArgs e) { Total(); } private void grdMain_ColumnWidthChanged(object sender, DataGridViewColumnEventArgs e) { Total(); } private void grdMain_Paint(object sender, PaintEventArgs e) { DBUtility.Xt_BaseBillFun.GraphicsGrid(grdMain); } private void RW_Click(object sender, EventArgs e) { string sItemID = ""; if (grdMain.CurrentRow == null) { MessageBox.Show("请选择需要生成预测单的记录！"); return; } if (MessageBox.Show("是否生成预测单，此操作不可逆！", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.Cancel) { return; } for (int i = 0; i <= grdMain.SelectedRows.Count - 1; i++) { sItemID = sItemID + DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("HItemID")].Value) + ","; } sItemID = "," + sItemID; if (!AddPPorder(sItemID)) { MessageBox.Show("生成预测单失败！"); return; } MessageBox.Show("生成预测单成功！"); } private bool AddPPorder(string sItemID) { SQLHelper.ClsCNK3 oCnK3 = new SQLHelper.ClsCNK3(); SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); DataSet Ds; try { //得到mainid Ds = oCnK3.RunProcReturn("declare @InterID int set @InterID=0 exec GetICMaxNum 'PPOrder', @InterID output, 1, 16394 select ltrim(@InterID)", "GetICMaxNum"); long HInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]); // Ds = oCnK3.RunProcReturn("exec HX_GetICBillNo 1,'87'", "t_billcodeby"); string HBillNo = Ds.Tables[0].Rows[0][0].ToString().Trim(); // oCn.RunProc("exec h_p_K3_Sc_PPOrder_Add " + HInterID + ",'" + HBillNo + "','" + sItemID + "'"); return true; } catch (Exception e) { throw (e); } } private void sc_Click(object sender, EventArgs e) { long sItemID = 0; if (grdMain.CurrentRow == null) { MessageBox.Show("请选择需要删除的记录！"); return; } if (MessageBox.Show("是否删除需求记录，此操作不可逆！", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.Cancel) { return; } for (int i = 0; i <= grdMain.SelectedRows.Count - 1; i++) { sItemID = DBUtility.ClsPub.isLong(grdMain.SelectedRows[i].Cells[Fun_GetCol("HItemID")].Value); if (!Delete(sItemID)) { MessageBox.Show("删除失败！"); return; } } MessageBox.Show("删除成功！"); } private bool Delete(long sItemID) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); DataSet Ds; try { oCn.RunProc("delete from K3_Kf_MoveStockBill_Tmp where HItemID=" + sItemID.ToString()); return true; } catch (Exception e) { throw (e); } } } }