using System; 
 | 
using System.Collections.Generic; 
 | 
using System.ComponentModel; 
 | 
using System.Data; 
 | 
using System.Drawing; 
 | 
using System.Text; 
 | 
using System.Windows.Forms; 
 | 
using gregn6Lib; 
 | 
using Pub_Class; 
 | 
using SQLHelper; 
 | 
using DBUtility; 
 | 
  
 | 
namespace EAM 
 | 
{ 
 | 
    public partial class Sc_MouldCostList : Form 
 | 
    { 
 | 
        public Sc_MouldCostList() 
 | 
        { 
 | 
            InitializeComponent(); 
 | 
        } 
 | 
        public frmBillQueryCondition_New frmCondition; 
 | 
        const string ViewName = "h_v_Sc_MouldCostList"; 
 | 
        const string ModCaption = "模具费用列表"; 
 | 
        public const string ModName = "1814"; 
 | 
        public const string ModRightName = "Sc_MouldCostMoneyBill"; 
 | 
        public const string ModRightNameEdit = ModRightName + "_Edit"; 
 | 
        public const string ModRightNameCheck = ModRightName + "_Check"; 
 | 
        public const string ModRightNameClose = ModRightName + "_Close"; 
 | 
        public const string ModRightNameDelete = ModRightName + "_Delete"; 
 | 
        public const string ModRightNameMoney = ModRightName + "_Money"; 
 | 
        public const string ModRightNameQty = ModRightName + "_Qty"; 
 | 
        DAL.ClsSc_MouldCostMoneyBill oBill = new DAL.ClsSc_MouldCostMoneyBill(); 
 | 
        public Sc_MouldCostMoneyBill oFrm; 
 | 
        public string sDlgWhere = "";  //外窗体递入 
 | 
        Pub_Class.ClsGridListSum oSumGrid = new Pub_Class.ClsGridListSum(); 
 | 
        public long HMainID = 0; 
 | 
        public long HMainID_New = 0; 
 | 
  
 | 
  
 | 
        #region  固定代码 
 | 
        //初始化网格 
 | 
        private void initGrid() 
 | 
        { 
 | 
            DBUtility.Xt_BaseBillFun.initGridList(grdMain,this.Name); 
 | 
        } 
 | 
        // 
 | 
        //显示 
 | 
        private void Display() 
 | 
        { 
 | 
            ClsCN SubCn = new ClsCN(); 
 | 
            DataSet DSet; 
 | 
            string sSql = ""; 
 | 
            string sWhere = "";  //特殊条件(日期限制,部门限制) 
 | 
            DBUtility.Xt_BaseBillFun.Sub_SQLWhere(ref sWhere); 
 | 
            if (sDlgWhere == "") 
 | 
            { 
 | 
                //过滤条件 
 | 
                if (frmCondition.SqlStr.Trim().Length == 0) 
 | 
                    return; 
 | 
                sSql = frmCondition.SqlStr + sWhere + " order by 年,月 "; 
 | 
            } 
 | 
            else 
 | 
            { 
 | 
                sSql = "Select * from " + ViewName + " Where 1=1 " + sWhere + sDlgWhere + " order by  年,月"; 
 | 
            } 
 | 
            // 
 | 
            DSet = SubCn.RunProcReturn(sSql, ViewName, ref DBUtility.ClsPub.sExeReturnInfo); 
 | 
            //生成首行标题 
 | 
            if (DSet == null) 
 | 
            { 
 | 
                MessageBox.Show("没有返回任何结果,请在过滤框中点击【恢复】按钮,尝试再次查询!" + DBUtility.ClsPub.sExeReturnInfo); 
 | 
                return; 
 | 
            } 
 | 
            //释放冻结 
 | 
            DBUtility.Xt_BaseBillFun.CancelFrozenCol(grdMain); 
 | 
            //绑定 
 | 
            grdMain.DataSource = DSet.Tables[0].DefaultView; 
 | 
            //设置合计列 
 | 
            string sTotalCol = ""; 
 | 
            sTotalCol = DBUtility.Gy_BaseFun.GetTotalCols(DSet); 
 | 
            string[] sT; 
 | 
            sT = sTotalCol.Split(Convert.ToChar(",")); 
 | 
            oSumGrid.BuildTotalCols(sT); 
 | 
            //   
 | 
            //冻结 
 | 
            int FrCol = DBUtility.ClsPub.isInt(frmCondition.txtFrozenCol.Text); 
 | 
            string s = frmCondition.cmbHComplete.Text; 
 | 
            DBUtility.Xt_BaseBillFun.DisplayGrid(grdMain, this.Name, s, FrCol); 
 | 
            //画线 
 | 
            GraphLine(); 
 | 
            // 
 | 
            Total(); 
 | 
             
 | 
            //  
 | 
        } 
 | 
        //时间控件 
 | 
        private void timer1_Tick(object sender, EventArgs e) 
 | 
        { 
 | 
            timer1.Enabled=false; 
 | 
            initGrid(); 
 | 
            Display(); 
 | 
        } 
 | 
        //退出 
 | 
        private void tc_Click(object sender, EventArgs e) 
 | 
        { 
 | 
            this.Close(); 
 | 
        } 
 | 
        //刷新 
 | 
        private void sx_Click(object sender, EventArgs e) 
 | 
        { 
 | 
            timer1.Enabled = true; 
 | 
        } 
 | 
        //显示单据 
 | 
        private void dj_Click(object sender, EventArgs e) 
 | 
        { 
 | 
            Sub_ShowBill(); 
 | 
        } 
 | 
        //显示单据 
 | 
        private void Sub_ShowBill() 
 | 
        { 
 | 
            //Int64 lngBillKey = 0; 
 | 
            //if (grdMain.CurrentRow == null) 
 | 
            //    return; 
 | 
            //lngBillKey =DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("hmainid")].Value); 
 | 
            //if (lngBillKey == 0) 
 | 
            //    return; 
 | 
            //DAL.ClsSc_MouldCostMoneyBill oBill = new DAL.ClsSc_MouldCostMoneyBill(); 
 | 
            //if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) 
 | 
            //{ 
 | 
            //    oFrm = new Sc_MouldCostMoneyBill(); 
 | 
            //    oFrm.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_View; 
 | 
            //    oFrm.BillOld = oBill; 
 | 
            //    oFrm.ShowDialog(); 
 | 
            //    if (oFrm.BillChange) 
 | 
            //    { 
 | 
            //        if (MessageBox.Show("单据列表已经发生变化,是否刷新", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) 
 | 
            //        { 
 | 
            //            timer1.Enabled = true; 
 | 
            //        } 
 | 
            //    } 
 | 
            //} 
 | 
            //else  
 | 
            //{ 
 | 
            //    MessageBox.Show("单据未找到", "提示"); 
 | 
            //} 
 | 
            //oBill = null; 
 | 
        } 
 | 
        // 
 | 
        private Int32 Fun_GetCol(string sCol) 
 | 
        { 
 | 
            return DBUtility.Xt_BaseBillFun.Fun_GetCol(sCol, grdMain); 
 | 
        } 
 | 
        // 
 | 
        private void Sc_MouldCostList_Load(object sender, EventArgs e) 
 | 
        { 
 | 
            // 
 | 
            frmCondition = new frmBillQueryCondition_New(); 
 | 
            this.Text = ModCaption; 
 | 
            lblCaption.Text = ModCaption; 
 | 
            oSumGrid.ogrdMain = grdMain;  //初始化 new 
 | 
            oSumGrid.oGridsum = grdSum; 
 | 
            initGrid(); 
 | 
        } 
 | 
        //双击查看 
 | 
        private void grdMain_DblClick(object sender, EventArgs e) 
 | 
        { 
 | 
            Sub_ShowBill(); 
 | 
        } 
 | 
        //查询 
 | 
        private void cx_Click(object sender, EventArgs e) 
 | 
        { 
 | 
            frmCondition = new frmBillQueryCondition_New(); 
 | 
            SetCondition(frmCondition, ViewName, this.Name); 
 | 
            frmCondition.ShowDialog(); 
 | 
            if (frmCondition.Tag.ToString() == "OK") 
 | 
            { 
 | 
                Display(); 
 | 
            } 
 | 
        } 
 | 
  
 | 
        public void SetCondition(frmBillQueryCondition_New frmCondition, string ViewName, string Name) 
 | 
        { 
 | 
            frmCondition.Tag = ""; 
 | 
            frmCondition.ViewName = ViewName; 
 | 
            frmCondition.ModName = Name; 
 | 
        } 
 | 
  
 | 
        private void xz_Click(object sender, EventArgs e) 
 | 
        { 
 | 
            // 
 | 
            //oFrm = new Sc_MouldCostMoneyBill(); 
 | 
            //oFrm.ShowDialog(); 
 | 
        } 
 | 
  
 | 
        private void sc_Click(object sender, EventArgs e) 
 | 
        { 
 | 
            Sub_DeleteBill(); 
 | 
        } 
 | 
        //删除 
 | 
        private void Sub_DeleteBill() 
 | 
        { 
 | 
            //编辑权限 
 | 
            //if (!DBUtility.ClsPub.Security_Log(ModRightNameEdit, 1, true,DBUtility.ClsPub.CurUserName)) 
 | 
            //{ 
 | 
            //    return; 
 | 
            //} 
 | 
            // 
 | 
            //Int64 lngBillKey = 0; 
 | 
            //if (grdMain.CurrentRow == null) 
 | 
            //    return; 
 | 
            //lngBillKey = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("hmainid")].Value); 
 | 
            //if (lngBillKey == 0) 
 | 
            //    return; 
 | 
            //DAL.ClsSc_MouldCostMoneyBill  oBill = new DAL.ClsSc_MouldCostMoneyBill(); 
 | 
            //if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) 
 | 
            //{ 
 | 
            //    if (oBill.omodel.HBillStatus > 1) 
 | 
            //    { 
 | 
            //        MessageBox.Show("单据当前处于不能删除状态,不能删除!", "提示"); 
 | 
            //        return; 
 | 
            //    } 
 | 
            //    if (oBill.omodel.HChecker != "") 
 | 
            //    { 
 | 
            //        MessageBox.Show("单据已经审核,不能删除!", "提示"); 
 | 
            //        return; 
 | 
            //    } 
 | 
            //    if (MessageBox.Show("确定要删除当前单据?", "提示", MessageBoxButtons.OKCancel)==DialogResult.OK) 
 | 
            //    { 
 | 
                     
 | 
            //        if (!oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo)) 
 | 
            //        { 
 | 
            //            MessageBox.Show(DBUtility.ClsPub.sExeReturnInfo, "提示"); 
 | 
            //            return; 
 | 
            //        } 
 | 
            //        else 
 | 
            //        { 
 | 
                         
 | 
            //            Display(); 
 | 
  
 | 
            //        } 
 | 
  
 | 
            //    } 
 | 
            //} 
 | 
            //else 
 | 
            //{ 
 | 
            //    MessageBox.Show("单据未找到", "提示"); 
 | 
            //} 
 | 
        } 
 | 
  
 | 
        private void timer2_Tick(object sender, EventArgs e) 
 | 
        { 
 | 
            timer2.Enabled = false; 
 | 
            //if (sDlgWhere == "") 
 | 
            //{ 
 | 
            //    frmCondition = new frmBillQueryCondition_New(); 
 | 
            //    SetCondition(frmCondition, ViewName, this.Name); 
 | 
            //    frmCondition.ShowDialog(); 
 | 
            //    if (frmCondition.Tag.ToString() == "OK") 
 | 
            //    { 
 | 
            //        timer1.Enabled = true; 
 | 
            //    } 
 | 
            //} 
 | 
            //else 
 | 
            //{ 
 | 
            //    timer1.Enabled = true; 
 | 
            //} 
 | 
        } 
 | 
        // 
 | 
        private void bclk_Click(object sender, EventArgs e) 
 | 
        { 
 | 
            //保存列宽 
 | 
            DBUtility.Xt_BaseBillFun.SaveGrid(grdMain, this.Name); 
 | 
        } 
 | 
  
 | 
        private void mrlk_Click(object sender, EventArgs e) 
 | 
        { 
 | 
            DBUtility.Xt_BaseBillFun.DefaultGridView(grdMain, this.Name); 
 | 
        } 
 | 
        //  
 | 
        private void GraphLine() 
 | 
        { 
 | 
            int MainIDCol = Fun_GetCol("hmainid"); 
 | 
            int SubIDCol = Fun_GetCol("hsubid"); 
 | 
            string s = frmCondition.cmbHComplete.Text; 
 | 
            long n=0; 
 | 
            DBUtility.Xt_BaseBillFun.GraphLine(grdMain, MainIDCol, SubIDCol, s,ref n); 
 | 
            //显示 
 | 
            lbldj.Text = "查询出 " + n.ToString() + " 张单据"; 
 | 
            lbljl.Text = "共有 " + grdMain.RowCount.ToString() + " 条记录";  
 | 
  
 | 
        } 
 | 
        //审核 
 | 
        private void sh_Click(object sender, EventArgs e) 
 | 
        { 
 | 
            //this.Sub_CheckBill(); 
 | 
        } 
 | 
  
 | 
        //审核单据 
 | 
        private void Sub_CheckBill() 
 | 
        { 
 | 
            //审核权限 
 | 
            //if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true,DBUtility.ClsPub.CurUserName)) 
 | 
            //{ 
 | 
            //    return; 
 | 
            //} 
 | 
            //// 
 | 
            //Int64 lngBillKey = 0; 
 | 
            //if (grdMain.CurrentRow == null) 
 | 
            //    return; 
 | 
            //lngBillKey = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("hmainid")].Value); 
 | 
            //if (lngBillKey == 0) 
 | 
            //    return; 
 | 
            //DAL.ClsSc_MouldCostMoneyBill  oBill = new DAL.ClsSc_MouldCostMoneyBill(); 
 | 
            ////查看是否已审核,关闭,作废 
 | 
            //if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) 
 | 
            //{ 
 | 
            //    if (oBill.omodel.HChecker.Trim() != "") 
 | 
            //    { 
 | 
            //        MessageBox.Show("单据已审核!不能再次审核", "提示"); 
 | 
            //        return; 
 | 
            //    } 
 | 
            //    if (oBill.omodel.HCloseMan.Trim() != "") 
 | 
            //    { 
 | 
            //        MessageBox.Show("单据已关闭!不能再次审核", "提示"); 
 | 
            //        return; 
 | 
            //    } 
 | 
            //    if (oBill.omodel.HDeleteMan.Trim() != "") 
 | 
            //    { 
 | 
            //        MessageBox.Show("单据已作废!不能再次审核", "提示"); 
 | 
            //        return; 
 | 
            //    } 
 | 
            //} 
 | 
            //else 
 | 
            //{ 
 | 
            //    MessageBox.Show("单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo, "提示"); 
 | 
            //    return; 
 | 
            //} 
 | 
            ////审核 
 | 
            //if (oBill.CheckBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) 
 | 
            //{ 
 | 
            //    MessageBox.Show("审核成功!", "提示"); 
 | 
            //    return; 
 | 
            //} 
 | 
            //else 
 | 
            //{ 
 | 
            //    MessageBox.Show("审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo, "提示"); 
 | 
            //    return; 
 | 
            //} 
 | 
        } 
 | 
        //反审单据 
 | 
        private void Sub_AbandonCheck() 
 | 
        { 
 | 
            ////审核权限 
 | 
            //if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true,DBUtility.ClsPub.CurUserName)) 
 | 
            //{ 
 | 
            //    return; 
 | 
            //} 
 | 
            //// 
 | 
            //Int64 lngBillKey = 0; 
 | 
            //if (grdMain.CurrentRow == null) 
 | 
            //    return; 
 | 
            //lngBillKey = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("hmainid")].Value); 
 | 
            //if (lngBillKey == 0) 
 | 
            //    return; 
 | 
            //DAL.ClsSc_MouldCostMoneyBill  oBill = new DAL.ClsSc_MouldCostMoneyBill(); 
 | 
            ////查看是否已审核,关闭,作废 
 | 
            //if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) 
 | 
            //{ 
 | 
            //    if (oBill.omodel.HChecker.Trim() == "") 
 | 
            //    { 
 | 
            //        MessageBox.Show("单据未审核!不需要反审核!", "提示"); 
 | 
            //        return; 
 | 
            //    } 
 | 
            //    if (oBill.omodel.HCloseMan.Trim() != "") 
 | 
            //    { 
 | 
            //        MessageBox.Show("单据已关闭!不能再次审核", "提示"); 
 | 
            //        return; 
 | 
            //    } 
 | 
            //    if (oBill.omodel.HDeleteMan.Trim() != "") 
 | 
            //    { 
 | 
            //        MessageBox.Show("单据已作废!不能再次审核", "提示"); 
 | 
            //        return; 
 | 
            //    } 
 | 
            //} 
 | 
            //else 
 | 
            //{ 
 | 
            //    MessageBox.Show("单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo, "提示"); 
 | 
            //    return; 
 | 
            //} 
 | 
            ////反审核 
 | 
            //if (oBill.AbandonCheck(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) 
 | 
            //{ 
 | 
            //    MessageBox.Show("反审核成功!", "提示"); 
 | 
            //    return; 
 | 
            //} 
 | 
            //else 
 | 
            //{ 
 | 
            //    MessageBox.Show("反审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo, "提示"); 
 | 
            //    return; 
 | 
            //} 
 | 
        } 
 | 
        //反审核 
 | 
        private void qsh_Click(object sender, EventArgs e) 
 | 
        { 
 | 
            //Sub_AbandonCheck(); 
 | 
        } 
 | 
  
 | 
        private void GraphicsGrid() 
 | 
        { 
 | 
            DBUtility.Xt_BaseBillFun.GraphicsGrid(grdMain); 
 | 
        } 
 | 
  
 | 
        // 
 | 
        private void grdMain_Paint(object sender, PaintEventArgs e) 
 | 
        { 
 | 
            GraphicsGrid(); 
 | 
        } 
 | 
        //合计 new 
 | 
        private void Total() 
 | 
        { 
 | 
            if (grdMain.Rows.Count > 0 && grdMain.ColumnCount > 0) 
 | 
            { 
 | 
                oSumGrid.SetGridsum(); 
 | 
                oSumGrid.Total(); 
 | 
            } 
 | 
        } 
 | 
        //合计 new 
 | 
        private void grdMain_ColumnWidthChanged(object sender, DataGridViewColumnEventArgs e) 
 | 
        { 
 | 
            Total(); 
 | 
        } 
 | 
        //合计 new 
 | 
        private void grdMain_CellMouseUp(object sender, DataGridViewCellMouseEventArgs e) 
 | 
        { 
 | 
            Total(); 
 | 
        } 
 | 
  
 | 
        private void dc_Click(object sender, EventArgs e) 
 | 
        { 
 | 
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain); 
 | 
        } 
 | 
  
 | 
  
 | 
        #endregion 
 | 
  
 | 
        #region  //打印设置 
 | 
  
 | 
        GridppReport Report; 
 | 
  
 | 
        private void set_Click(object sender, EventArgs e) 
 | 
        { 
 | 
             //选择打印模板 
 | 
            BLL.Gy_OpenTmp oFrm = new BLL.Gy_OpenTmp(); 
 | 
            oFrm.sBillName = ModName; 
 | 
            oFrm.sBillModel = ModCaption; 
 | 
            oFrm.ShowDialog();  
 | 
        } 
 | 
  
 | 
        private void dy_Click(object sender, EventArgs e) 
 | 
        { 
 | 
            //选择打印模板 
 | 
            BLL.Gy_OpenTmp oFrm = new BLL.Gy_OpenTmp(); 
 | 
            oFrm.sBillName = ModName; 
 | 
            oFrm.sBillModel = ModCaption; 
 | 
            oFrm.ShowDialog(); 
 | 
            if (oFrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK) 
 | 
            { 
 | 
                // 
 | 
                Sub_SetReport(oFrm.sOpenTmp); 
 | 
                Report.Print(true); 
 | 
            } 
 | 
        } 
 | 
  
 | 
        //预览 
 | 
        private void yl_Click(object sender, EventArgs e) 
 | 
        { 
 | 
            //选择打印模板 
 | 
            BLL.Gy_OpenTmp oFrm = new BLL.Gy_OpenTmp(); 
 | 
            oFrm.sBillName = ModName; 
 | 
            oFrm.sBillModel = ModCaption; 
 | 
            oFrm.ShowDialog(); 
 | 
            if (oFrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK) 
 | 
            { 
 | 
                // 
 | 
                Sub_SetReport(oFrm.sOpenTmp); 
 | 
                HMainID = 0; 
 | 
                HMainID_New = 0; 
 | 
                for (int i = 0; i <= grdMain.Rows.Count - 1; i++) 
 | 
                { 
 | 
                    HMainID_New = DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[Fun_GetCol("HMainID")].Value); 
 | 
                    if (HMainID_New != HMainID && HMainID_New != 0) 
 | 
                    { 
 | 
                        HMainID = HMainID_New; 
 | 
                        Report.PrintPreview(true); 
 | 
                    } 
 | 
                } 
 | 
            } 
 | 
  
 | 
        } 
 | 
  
 | 
        private void Sub_SetReport(string sOpenTmp) 
 | 
        { 
 | 
            //判断行数 
 | 
            // 
 | 
            Report = new GridppReport(); 
 | 
            Report.LoadFromFile(DBUtility.ClsPub.AppPath + @"\" + sOpenTmp + ".grf");  //here . 
 | 
            Report.BeforePostRecord += new _IGridppReportEvents_BeforePostRecordEventHandler(ReportBeforePostRecord); 
 | 
            Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ReportFetchRecordByDataTable); 
 | 
        } 
 | 
  
 | 
        private void ReportBeforePostRecord() 
 | 
        { 
 | 
            try 
 | 
            { 
 | 
                //Report.FieldByName("单据号").AsString = "123"; 
 | 
  
 | 
                int HPeriodCol = Fun_GetCol("会计月"); 
 | 
                int HDateCol = Fun_GetCol("日期"); 
 | 
                int HRoomNumberCol = Fun_GetCol("业户代码"); 
 | 
                int HRoomNameCol = Fun_GetCol("业户"); 
 | 
                int HItMoneyNameCol = Fun_GetCol("费用项目"); 
 | 
                int HQtyCol = Fun_GetCol("数量"); 
 | 
                int HPriceCol = Fun_GetCol("单价"); 
 | 
                int HMoneyCol = Fun_GetCol("金额"); 
 | 
                int HWasterCol = Fun_GetCol("损耗"); 
 | 
                int HBeginBalanceCol = Fun_GetCol("开始数值"); 
 | 
                int HEndBalanceCol = Fun_GetCol("结束数值"); 
 | 
                double sQty = 0; 
 | 
                // 
 | 
                for (int i = 0; i <= grdMain.Rows.Count - 1; i++) 
 | 
                { 
 | 
                    if (DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[Fun_GetCol("HMainID")].Value) == HMainID_New) 
 | 
                    { 
 | 
                        if (DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HItMoneyNameCol].Value) == "冷水") 
 | 
                        { 
 | 
                            Report.FieldByName("冷水开始数值").AsString = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HBeginBalanceCol].Value); 
 | 
                            Report.FieldByName("冷水结束数值").AsString = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HEndBalanceCol].Value); 
 | 
                            Report.FieldByName("冷水用量").AsString = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HQtyCol].Value); 
 | 
                            Report.FieldByName("冷水损耗").AsString = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HWasterCol].Value); 
 | 
                            Report.FieldByName("冷水单价").AsString = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HPriceCol].Value); 
 | 
                            Report.FieldByName("冷水金额").AsString = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HMoneyCol].Value); 
 | 
                            sQty = sQty + DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[HMoneyCol].Value); 
 | 
                        } 
 | 
                        else if (DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HItMoneyNameCol].Value) == "热水") 
 | 
                        { 
 | 
                            Report.FieldByName("热水开始数值").AsString = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HBeginBalanceCol].Value); 
 | 
                            Report.FieldByName("热水结束数值").AsString = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HEndBalanceCol].Value); 
 | 
                            Report.FieldByName("热水用量").AsString = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HQtyCol].Value); 
 | 
                            Report.FieldByName("热水损耗").AsString = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HWasterCol].Value); 
 | 
                            Report.FieldByName("热水单价").AsString = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HPriceCol].Value); 
 | 
                            Report.FieldByName("热水金额").AsString = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HMoneyCol].Value); 
 | 
                            sQty = sQty + DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[HMoneyCol].Value); 
 | 
                        } 
 | 
                        else if (DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HItMoneyNameCol].Value) == "空调") 
 | 
                        { 
 | 
                            Report.FieldByName("空调开始数值").AsString = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HBeginBalanceCol].Value); 
 | 
                            Report.FieldByName("空调结束数值").AsString = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HEndBalanceCol].Value); 
 | 
                            Report.FieldByName("空调用量").AsString = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HQtyCol].Value); 
 | 
                            Report.FieldByName("空调损耗").AsString = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HWasterCol].Value); 
 | 
                            Report.FieldByName("空调单价").AsString = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HPriceCol].Value); 
 | 
                            Report.FieldByName("空调金额").AsString = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HMoneyCol].Value); 
 | 
                            sQty = sQty + DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[HMoneyCol].Value); 
 | 
                        } 
 | 
                        //string[] cnNum = { "零", "壹", "贰", "叁", "肆", "伍", "陆", "柒", "捌", "玖" }; 
 | 
  
 | 
                        string sQty_Big = sQty.ToString(); 
 | 
  
 | 
                        //for (int j = 0; j < 10; j++) 
 | 
                        //{ 
 | 
                        //    sQty_Big = sQty_Big.Replace(j.ToString(), cnNum[j]); 
 | 
                        //} 
 | 
                        Report.FieldByName("月").AsString = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HPeriodCol].Value); 
 | 
                        Report.FieldByName("业户编号").AsString = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HRoomNumberCol].Value); 
 | 
                        Report.FieldByName("业户").AsString = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HRoomNameCol].Value); 
 | 
                        Report.FieldByName("日期").AsString = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HDateCol].Value); 
 | 
                        Report.FieldByName("大写金额").AsString = sQty.ToString(); 
 | 
                        Report.FieldByName("小写金额").AsString = sQty_Big; 
 | 
                    } 
 | 
                } 
 | 
            } 
 | 
            catch (Exception e) 
 | 
            { 
 | 
                MessageBox.Show("打印失败!表头:" + e.Message); 
 | 
            } 
 | 
        } 
 | 
  
 | 
        private void ReportFetchRecordByDataTable() 
 | 
        { 
 | 
            try 
 | 
            { 
 | 
                BLL.Utility.FillRecordToReport(Report, grdMain, grdPrint, 0); 
 | 
            } 
 | 
            catch (Exception e) 
 | 
            { 
 | 
                MessageBox.Show("打印失败!表体:" + e.Message); 
 | 
            } 
 | 
        } 
 | 
  
 | 
        #endregion 
 | 
         
 | 
  
 | 
        #region 额外方法 
 | 
  
 | 
        //上查 
 | 
        private void shc_Click(object sender, EventArgs e) 
 | 
        { 
 | 
            // 
 | 
        } 
 | 
  
 | 
        private void xc_Click(object sender, EventArgs e) 
 | 
        { 
 | 
            // 
 | 
        } 
 | 
  
 | 
        #endregion 
 | 
  
 | 
        private void toolStripButton1_Click(object sender, EventArgs e) 
 | 
        { 
 | 
            //InputMode = Enum_InputMode.InputMode_AddNew; 
 | 
            //Init(); 
 | 
            DataSet Ds = new DataSet(); 
 | 
            Sc_MouldCost1 oForm = new Sc_MouldCost1(); 
 | 
            Sc_MouldCost2 oForm2 = new Sc_MouldCost2(); 
 | 
            Sc_MouldCost3 oForm3 = new Sc_MouldCost3(); 
 | 
            Sc_MouldCost4 oForm4 = new Sc_MouldCost4(); 
 | 
            Sc_MouldCost5 oForm5 = new Sc_MouldCost5(); 
 | 
            //----------------------- 
 | 
            oForm3.cmbHPeriod.Text = DateTime.Today.Month.ToString(); 
 | 
            oForm3.cmbHYear.Items.Add(DateTime.Today.AddYears(-2).Year); 
 | 
            oForm3.cmbHYear.Items.Add(DateTime.Today.AddYears(-1).Year); 
 | 
            oForm3.cmbHYear.Items.Add(DateTime.Today.Year); 
 | 
            oForm3.cmbHYear.Items.Add(DateTime.Today.AddYears(1).Year); 
 | 
            oForm3.cmbHYear.SelectedIndex = 2; 
 | 
        //----------------------1:上一步,2:下一步(完成),3:退出 
 | 
        Form1: oForm.ShowDialog(); 
 | 
            if (oForm.HCode == 2) 
 | 
            { 
 | 
            Form2: 
 | 
                oForm2.ShowDialog(); 
 | 
                if (oForm2.HCode == 1)  
 | 
                { 
 | 
                    goto Form1; 
 | 
                } 
 | 
                else if (oForm2.HCode == 2) 
 | 
                { 
 | 
                Form3: 
 | 
                    oForm3.ShowDialog(); 
 | 
                    if (oForm3.HCode == 1) 
 | 
                    { 
 | 
                        goto Form2; 
 | 
                    } 
 | 
                    else if (oForm3.HCode == 2) 
 | 
                    { 
 | 
                    Form4: 
 | 
                        //获取核算信息 
 | 
                        oForm4.HYear = DBUtility.ClsPub.isInt(oForm3.cmbHYear.Text); 
 | 
                        oForm4.HPeriod = DBUtility.ClsPub.isInt(oForm3.cmbHPeriod.Text); 
 | 
                        oForm4.HBDeptNumber = oForm2.txtHBDeptID.Text; 
 | 
                        oForm4.HEDeptNumber = oForm2.txtHEDeptID.Text; 
 | 
                        if (oForm2.rbHDeptAll.Checked == true) 
 | 
                        { 
 | 
                            oForm4.HDeptType = 0;  //全部 
 | 
                        } 
 | 
                        else if (oForm2.rbHDeptAToB.Checked == true) 
 | 
                        { 
 | 
                            oForm4.HDeptType = 1;  //部门段 
 | 
                        } 
 | 
                        else 
 | 
                        { 
 | 
                            oForm4.HDeptType = 2;  //单个部门 
 | 
                            oForm4.HBDeptNumber = oForm2.txtHDeptID.Text; 
 | 
                        } 
 | 
                        // 
 | 
                        //if (oForm3.rbHSetType_CZ.Checked == true) 
 | 
                        //{ 
 | 
                        //    oForm4.HSetType = 0;  //按产值 
 | 
                        //} 
 | 
                        //else if (oForm3.rbHSetType_CL.Checked == true) 
 | 
                        //{ 
 | 
                        //    oForm4.HSetType = 1; //按产量 
 | 
                        //} 
 | 
                        // 
 | 
                        oForm4.ShowDialog(); 
 | 
                        if (oForm4.HCode == 1) 
 | 
                        { 
 | 
                            goto Form3; 
 | 
                        } 
 | 
                        else if (oForm4.HCode == 2) 
 | 
                        { 
 | 
                            //Form5: 
 | 
                            oForm5.ShowDialog(); 
 | 
                            if (oForm5.HCode == 1) 
 | 
                            { 
 | 
                                goto Form4; 
 | 
                            } 
 | 
                            else if (oForm5.HCode == 2) 
 | 
                            { 
 | 
                                //MessageBox.Show(""); 
 | 
                            } 
 | 
                            else 
 | 
                            { 
 | 
  
 | 
                            } 
 | 
                        } 
 | 
                        else { } 
 | 
                    } 
 | 
                    else { } 
 | 
                } 
 | 
                else 
 | 
                { } 
 | 
            } 
 | 
            else 
 | 
            { 
 | 
  
 | 
            } 
 | 
        } 
 | 
  
 | 
         
 | 
  
 | 
         
 | 
  
 | 
         
 | 
    } 
 | 
} 
 |