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 { } } } }