コード例 #1
1
ファイル: uc_gridcontrol.cs プロジェクト: s7loves/mypowerscgl
        public void InitCol(string[] arrCol, LP_Temple lp) {
            m_ColName = arrCol;
            DataTable ds = new DataTable();
            string[] arrColtype = lp.ComBoxItem.Split('|');
            for (int i = 0; i < arrCol.Length; i++) {
                if (arrCol[i].ToString() == "") continue;
                if (arrColtype[i].IndexOf("RepositoryItemCalcEdit") > -1 || arrColtype[i].IndexOf("RepositoryItemSpinEdit") > -1) {
                    ds.Columns.Add(arrCol[i], typeof(double));
                } else
                    if (arrColtype[i].IndexOf("RepositoryItemDateEdit") > -1) {
                        ds.Columns.Add(arrCol[i], typeof(DateTime));
                    } else {
                        ds.Columns.Add(arrCol[i], typeof(string));
                    }
                ds.Columns[i].Caption = arrCol[i];
            }
            try {
                gridControl1.DataSource = ds;
            } catch (Exception err) {

            }
            DevExpress.XtraGrid.Views.Grid.GridView grid = gridView1;
            grid.OptionsBehavior.AllowAddRows = DevExpress.Utils.DefaultBoolean.True;
            grid.OptionsBehavior.AllowDeleteRows = DevExpress.Utils.DefaultBoolean.True;
            grid.OptionsView.NewItemRowPosition = DevExpress.XtraGrid.Views.Grid.NewItemRowPosition.Bottom;
            grid.OptionsView.ShowGroupPanel = false;
            string[] comItem = SelectorHelper.ToDBC(lp.ComBoxItem).Split('|');
            ((System.ComponentModel.ISupportInitialize)(this.gridControl1)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.gridView1)).BeginInit();
            for (int i = 0; i < grid.Columns.Count; i++) {

                if (grid.Columns[i].FieldName == "序号" || grid.Columns[i].FieldName == "月份" || grid.Columns[i].FieldName == "季度") {
                    grid.Columns[i].MinWidth = 20;
                }
                Regex r1 = new Regex(@"(?<=" + i + ":).*?(?=])");
                string strcom = r1.Match(comItem[i]).Value;

                if (strcom.IndexOf("RepositoryItemDateEdit") > -1) {
                    r1 = new Regex(@"(?<=:).*");
                    DevExpress.XtraEditors.Repository.RepositoryItemDateEdit date =
                             new DevExpress.XtraEditors.Repository.RepositoryItemDateEdit();
                    if (r1.Match(strcom).Value != "") {
                        date.Properties.EditMask = r1.Match(strcom).Value;
                        date.Mask.UseMaskAsDisplayFormat = true;
                        if (r1.Match(strcom).Value.ToLower().IndexOf("hh") > -1) {
                            date.VistaDisplayMode = DevExpress.Utils.DefaultBoolean.True;
                            date.VistaEditTime = DevExpress.Utils.DefaultBoolean.True;
                        }
                    }
                    grid.Columns[i].ColumnEdit = date;
                    grid.Columns[i].DisplayFormat.FormatString = date.Properties.EditMask;
                    grid.Columns[i].ColumnEdit.EditFormat.FormatString = date.Properties.EditMask;
                } else if (strcom.IndexOf("RepositoryItemCalcEdit") > -1) {

                    r1 = new Regex(@"(?<=:).*");
                    DevExpress.XtraEditors.Repository.RepositoryItemCalcEdit date =
                             new DevExpress.XtraEditors.Repository.RepositoryItemCalcEdit();
                    if (r1.Match(strcom).Value != "")
                        date.Properties.EditMask = r1.Match(strcom).Value;

                    grid.Columns[i].ColumnEdit = date;
                } else if (strcom.IndexOf("RepositoryItemSpinEdit") > -1) {
                    r1 = new Regex(@"(?<=:).*");
                    DevExpress.XtraEditors.Repository.RepositoryItemSpinEdit lue1 =
                             new DevExpress.XtraEditors.Repository.RepositoryItemSpinEdit();
                    ((System.ComponentModel.ISupportInitialize)(lue1)).BeginInit();
                    if (r1.Match(strcom).Value != "") {
                        if (r1.Match(strcom).Value.IndexOf("p") > -1) {
                            lue1.Increment = (decimal)0.0001;
                            lue1.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
                        } else
                            if (r1.Match(strcom).Value.IndexOf(".") > -1) {
                                Regex r2 = new Regex(@"(?<=\.).*");

                                lue1.Increment = (decimal)Math.Pow(0.1, r2.Match(strcom).Value.Length / 2);
                                lue1.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;

                            }
                        lue1.Name = ("lue1" + i.ToString());

                        lue1.Properties.EditMask = r1.Match(strcom).Value;
                        lue1.DisplayFormat.FormatString = r1.Match(strcom).Value;
                        lue1.Properties.DisplayFormat.FormatString = r1.Match(strcom).Value;
                        lue1.EditMask = r1.Match(strcom).Value;
                    }
                    gridView1.Columns[i].ColumnEdit = lue1;
                    //if (lue1.Properties.EditMask.IndexOf("p") > -1 || lue1.Properties.EditMask.IndexOf("%") > -1)
                    {
                        gridView1.Columns[i].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
                        gridView1.Columns[i].DisplayFormat.FormatString = lue1.Properties.EditMask.ToString();




                    }
                    ((System.ComponentModel.ISupportInitialize)(lue1)).EndInit();
                } else if (strcom.IndexOf("RepositoryItemCheckedComboBoxEdit") > -1) {
                    DevExpress.XtraEditors.Repository.RepositoryItemCheckedComboBoxEdit lue1 = new DevExpress.XtraEditors.Repository.RepositoryItemCheckedComboBoxEdit();

                    lue1.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;
                    grid.Columns[i].ColumnEdit = lue1;
                    //colctrllist.Add(lue1);
                } else {

                    DevExpress.XtraEditors.Repository.RepositoryItemComboBox lue1 = new DevExpress.XtraEditors.Repository.RepositoryItemComboBox();

                    lue1.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;
                    grid.Columns[i].ColumnEdit = lue1;
                    colctrllist.Add(lue1);

                }

            }
            ((System.ComponentModel.ISupportInitialize)(this.gridControl1)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.gridView1)).EndInit();
            gridView1.BestFitColumns();
        }
コード例 #2
0
ファイル: LPFrm.cs プロジェクト: s7loves/mypowerscgl
 public void InitIndex()
 {
     templeList = MainHelper.PlatformSqlMap.GetList<LP_Temple>("SelectLP_TempleList", "where ParentID!='0' and Kind='" + kind + "' Order by SortID");
     IList<LP_Temple> parentlist = MainHelper.PlatformSqlMap.GetList<LP_Temple>("SelectLP_TempleList", "where ParentID='0' and Kind='" + kind + "'");
     if (parentlist.Count > 0)
         parentTemple = parentlist[0];
    // dsoFramerWordControl1.
 }
コード例 #3
0
ファイル: uc_gridcontrol.cs プロジェクト: s7loves/mypowerscgl
        public void iniTableRecordData(string recordId, LP_Temple lp, string WorkflowId, string WorkFlowInsId)
        {
            if (lp != null)
            {
                DataTable ds = gridControl1.DataSource as DataTable;


                string[] arrCellpos = lp.CellPos.Split('|');

                int i = 0;
                for (i = 0; ; i++)
                {
                    IList<WF_TableFieldValue> tfvli;
                    if (lp.ExtraWord == "横向")
                    {
                        string strtemp = " where RecordId='" + recordId
                      + "' and FieldId='" + lp.LPID
                      + "' and   WorkflowId='" + WorkflowId
                      + "' and   YExcelPos='" + (GetCellPos(arrCellpos[0])[1] + i)
                      + "' and WorkFlowInsId='" + WorkFlowInsId + "'   order by XExcelPos,id ";
                        tfvli = MainHelper.PlatformSqlMap.GetList<WF_TableFieldValue>("SelectWF_TableFieldValueList", strtemp
                     );
                    }
                    else
                    {
                        string strtemp = " where RecordId='" + recordId
                      + "' and FieldId='" + lp.LPID
                      + "' and   WorkflowId='" + WorkflowId
                      + "' and   XExcelPos='" + (GetCellPos(arrCellpos[0])[0] + i)
                      + "' and WorkFlowInsId='" + WorkFlowInsId + "'  order by YExcelPos,id ";
                        tfvli = MainHelper.PlatformSqlMap.GetList<WF_TableFieldValue>("SelectWF_TableFieldValueList", strtemp
                     );
                    }
                    if (tfvli.Count == 0) break;
                    ds.Rows.Add(ds.NewRow());
                    foreach (WF_TableFieldValue tfv in tfvli)
                    {
                        Regex r2 = new Regex(@"(?<=-).*");
                        string strname = r2.Match(tfv.FieldName).Value;
                        if (tfv.ControlValue.Trim() != "")
                            ds.Rows[i][strname] = tfv.ControlValue;
                        else
                        {
                            try
                            {
                                ds.Rows[i][strname] = "";
                            }
                            catch { }
                        }
                        //gridView1.SetRowCellValue(i, strname, tfv.ControlValue);
                    }

                }

            }
        }
コード例 #4
0
ファイル: SetTaskTableFm.cs プロジェクト: s7loves/mypowerscgl
        void gridViewOperation_AfterAdd(LP_Temple e) {

            this.dsoFramerWordControl1.FileSave();
            this.dsoFramerWordControl1.Refresh();
            this.Refresh();
            this.Update();
            this.Hide();
            Thread.Sleep(10);
            this.Show();
        }
コード例 #5
0
ファイル: SetTaskTableFm.cs プロジェクト: s7loves/mypowerscgl
        void gridViewOperation_AfterEdit(LP_Temple e) {

            //this.dsoFramerWordControl1.FileSave();
            this.dsoFramerWordControl1.Refresh();
            this.Refresh();
            this.Update();
            this.Hide();
            this.Show();

        }
コード例 #6
0
ファイル: UCmExcel.cs プロジェクト: s7loves/mypowerscgl
        void gridViewOperation_AfterDelete(LP_Temple obj)
        {
            string slqwhere = " where ParentID='" + obj.ParentID + "' ";

            slqwhere = slqwhere + " order by SortID";
            IList<LP_Temple> li = MainHelper.PlatformSqlMap.GetListByWhere<LP_Temple>(slqwhere);
            int i = 1;
            List<LP_Temple> list = new List<LP_Temple>();
            foreach (LP_Temple ob in li)
            {
                ob.SortID= i;
                if (ob.SignImg == null)
                {
                    ob.SignImg = new byte[0];
                }
                if (ob.ImageAttachment == null)
                {
                    ob.ImageAttachment = new byte[0];
                }
                if (ob.DocContent == null)
                {
                    ob.DocContent = new byte[0];
                }
                i++;
                list.Add(ob);
            }
            List<SqlQueryObject> list3 = new List<SqlQueryObject>();
            if (list.Count > 0)
            {
                SqlQueryObject obj3 = new SqlQueryObject(SqlQueryType.Update, list.ToArray());
                list3.Add(obj3);
            }

            MainHelper.PlatformSqlMap.ExecuteTransationUpdate(list3);
            inidata();
        }
コード例 #7
0
        public void ExportExcelSubmit(ref LP_Temple parentTemple,  string orgid, bool isShow)
        {
            DSOFramerControl dsoFramerWordControl1 = new DSOFramerControl();
            string fname = Application.StartupPath + "\\00记录模板\\设备标志缺失变更明细表三.xls";
            dsoFramerWordControl1.FileOpen(fname);

            if (parentTemple == null)
            {
                parentTemple = new LP_Temple();
                parentTemple.Status = "文档生成";
            }
            parentTemple.DocContent = dsoFramerWordControl1.FileDataGzip;
            dsoFramerWordControl1.FileSave();
            dsoFramerWordControl1.FileClose();
            dsoFramerWordControl1.FileDataGzip = parentTemple.DocContent;
            ExcelAccess ex = new ExcelAccess();
            Microsoft.Office.Interop.Excel.Workbook wb = dsoFramerWordControl1.AxFramerControl.ActiveDocument as Microsoft.Office.Interop.Excel.Workbook;
            ex.MyWorkBook = wb;
            ex.MyExcel = wb.Application;
            string filter = "";
           
           
           
                filter = "  where 1=1 ";
                if (orgid != "") filter += " and OrgCode='" + orgid + "'";

                if (isWorkflowCall)
                {
                    filter = filter + " and id not in (select ModleRecordID from WF_ModleRecordWorkTaskIns where  WorkFlowId='"
                        + WorkFlowData.Rows[0]["WorkFlowId"].ToString() + "') "
                            + " or id in  (select ModleRecordID from WF_ModleRecordWorkTaskIns where "
                        + "    RecordID='" + currRecord.ID + "') "
                        ;
                }
                IList<PJ_sbbzqsbgmxb3> datalist = Client.ClientHelper.PlatformSqlMap.GetListByWhere<PJ_sbbzqsbgmxb3>(
                 filter
                   );
                ExportExcel(ex, datalist, orgid);
            
          
            
            //ex.ActiveSheet(1);
            //ex.DeleteWorkSheet(1);
            //Excel.Worksheet sheet;
            //for (int i = 1; i <= wb.Application.Sheets.Count; i++)
            //{
            //    sheet = wb.Application.Sheets[i] as Excel.Worksheet;
            //    sheet.Cells.Clear();
            //    sheet.Cells.ClearContents();
            //    sheet.Cells.ClearOutline();
            //    sheet.Visible = Excel.XlSheetVisibility.xlSheetHidden;
            //    dsoFramerWordControl1.FileSave();

                
            //    break;
            //}
            if (parentTemple == null)
            {
                parentTemple = new LP_Temple();
                parentTemple.Status = "文档生成";
            }
            dsoFramerWordControl1.FileSave();
            parentTemple.DocContent = dsoFramerWordControl1.FileDataGzip;
            dsoFramerWordControl1.FileSave();
            dsoFramerWordControl1.FileClose();
        }
コード例 #8
0
ファイル: frm20Template.cs プロジェクト: s7loves/mypowerscgl
        private void LPFrm_Load(object sender, EventArgs e) {
            if (tempCtrlList == null) {
                tempCtrlList = new List<Control>();
            }
            this.Text = "20低压线路完好率及台区网络图";
            //InitializeComponent();
            if (valuehs == null)
                valuehs = new Hashtable();

            ExcelAccess ea = new ExcelAccess();
            WF_TableFieldValue wfv = null;
            parentTemple = MainHelper.PlatformSqlMap.GetOne<LP_Temple>(" where ( ParentID not in (select LPID from LP_Temple where 1=1 and  CtrlSize!='目录') and  CtrlSize!='目录' ) and  CellName like '%低压线路完好率及台区网络图%'");
            LP_Temple lp = MainHelper.PlatformSqlMap.GetOne<LP_Temple>(" where  ParentID='" + parentTemple.LPID + "' and SortID=1");
            currRecord = rowData;
            if (lp != null) {
                if (wfv == null) {
                    wfv = new WF_TableFieldValue();
                    wfv.ID = wfv.CreateID();
                    wfv.RecordId = currRecord.ID;
                    wfv.WorkFlowId = currRecord.tqCode;
                    wfv.WorkFlowInsId = currRecord.tqName;
                    wfv.WorkTaskId = "20低压设备完好率及台区网络图";
                    wfv.WorkTaskInsId = "20低压设备完好率及台区网络图";
                    wfv.UserControlId = parentTemple.LPID;
                    wfv.ControlValue = "";
                    wfv.FieldId = lp.LPID;
                    wfv.FieldName = lp.CellName;
                    wfv.XExcelPos = GetCellPos(lp.CellPos)[0];
                    wfv.YExcelPos = GetCellPos(lp.CellPos)[1];
                }

                wfv = MainHelper.PlatformSqlMap.GetOne<WF_TableFieldValue>(" where  UserControlId='" + parentTemple.LPID + "'"
                                 + " and   WorkflowId='" + wfv.WorkFlowId + "'"
                                 + " and   RecordId='" + wfv.RecordId + "'"
                                 + " and   UserControlId='" + wfv.UserControlId + "'"
                                 + " and   WorkFlowInsId='" + wfv.WorkFlowInsId + "'"
                                 + " and   fieldname='" + lp.CellName + "'"
                                 + " and   FieldId='" + lp.LPID + "' and Bigdata is not null"
                                );

            }
            if (parentTemple == null) {
                MsgBox.ShowWarningMessageBox("没有找到表单20低压线路完好率及台区网络图!");
                return;
            }
            //if (currRecord.BigData == null || currRecord.BigData.Length == 0)
            {
                if (status != "edit" || wfv == null || wfv.Bigdata == null || wfv.Bigdata.Length == 0) {
                    this.dsoFramerWordControl1.FileDataGzip = parentTemple.DocContent;
                } else {
                    this.dsoFramerWordControl1.FileDataGzip = wfv.Bigdata;
                }
            }
            //else
            //{

            //    this.dsoFramerWordControl1.FileDataGzip = currRecord.BigData;
            //}
            wb = dsoFramerWordControl1.AxFramerControl.ActiveDocument as Excel.Workbook;
            xx = wb.ActiveSheet as Excel.Worksheet;
            sheet = xx;
            activeSheetName = xx.Name;

            InitIndex();
            InitContorl();
            InitData();

            if (status == "edit") {
                IList<WF_TableFieldValue> tfvli = MainHelper.PlatformSqlMap.GetList<WF_TableFieldValue>("SelectWF_TableFieldValueList",
                 " where RecordId='" + currRecord.ID + "' and UserControlId='" + parentTemple.LPID + "' and   WorkflowId='" + currRecord.tqCode + "' and WorkFlowInsId='" + currRecord.tqName + "' ");

                //wb = dsoFramerWordControl1.AxFramerControl.ActiveDocument as Excel.Workbook;
                //ea.MyWorkBook = wb;
                //ea.MyExcel = wb.Application;

                //xx = wb.Application.Sheets[1] as Excel.Worksheet;
                int i = 0;

                for (i = 0; i < tfvli.Count; i++) {
                    Control ctl = FindCtrl(tfvli[i].FieldId);
                    if (ctl != null) {
                        //ctl.Text = tfvli[i].ControlValue;
                        //ctl.Focus();
                        lp = ctl.Tag as LP_Temple;
                        if (lp.CtrlType.Contains("DevExpress.XtraEditors.DateEdit") == false) {
                            if (lp.CellName != "编号" && lp.CellName.IndexOf("低压线路") == -1
                                 && lp.CellName.IndexOf("最大供电半径") == -1
                                 && lp.CellName.IndexOf("低压杆基数") == -1
                                 && lp.CellName.IndexOf("表箱数") == -1
                                 && lp.CellName.IndexOf("四线的一类") == -1
                                 && lp.CellName.IndexOf("四线的二类") == -1
                                 && lp.CellName.IndexOf("四线的三类") == -1
                                 && lp.CellName.IndexOf("二线的一类") == -1
                                 && lp.CellName.IndexOf("二线的二类") == -1
                                 && lp.CellName.IndexOf("二线的三类") == -1
                                ) {
                                if (ctl.Text.IndexOf(tfvli[i].ControlValue) == -1)
                                    ctl.Text += tfvli[i].ControlValue;
                            } else {
                                ctl.Text = tfvli[i].ControlValue;
                            }
                            ctl.Focus();
                        } else {
                            IList<WF_TableFieldValue> tfvlitemp = MainHelper.PlatformSqlMap.GetList<WF_TableFieldValue>("SelectWF_TableFieldValueList",
                        " where RecordId='" + currRecord.ID + "' and UserControlId='" + parentTemple.LPID + "'   and FieldId='" + tfvli[i].FieldId.ToString() + "' and FieldName='" + tfvli[i].FieldName + "完整时间' order by id desc, YExcelPos,XExcelPos");
                            if (tfvlitemp.Count > 0) {
                                ((DevExpress.XtraEditors.DateEdit)ctl).DateTime = Convert.ToDateTime(tfvlitemp[0].ControlValue);
                            }
                            //((DevExpress.XtraEditors.DateEdit)ctl).DateTime = Convert.ToDateTime(tfvli[i].ControlValue);
                        }
                    }
                }
                dsoFramerWordControl1.FileSave();
            }
        }
コード例 #9
0
ファイル: frm20Template.cs プロジェクト: s7loves/mypowerscgl
        public void FillMutilRows(ExcelAccess ea, int i, LP_Temple lp, string str, List<int> arrCellCount, string[] arrCellPos) {
            StringHelper help = new StringHelper();
            str = help.GetPlitString(str, arrCellCount[1]);
            string[] extraWord = lp.ExtraWord.Split(pchar);

            string[] arrRst = str.Split(new string[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries);
            int j = 0;
            for (; i < arrCellPos.Length; i++) {
                if (j >= arrRst.Length)
                    break;
                ea.SetCellValue("'" + arrRst[j], GetCellPos(arrCellPos[i])[0], GetCellPos(arrCellPos[i])[1]);
                if (valuehs.ContainsKey(lp.LPID + "$" + arrCellPos[i])) {
                    WF_TableFieldValue tfv = valuehs[lp.LPID + "$" + arrCellPos[i]] as WF_TableFieldValue;
                    tfv.ControlValue = arrRst[j];
                    tfv.FieldId = lp.LPID;
                    tfv.FieldName = lp.CellName;
                    tfv.XExcelPos = GetCellPos(arrCellPos[i])[0];
                    tfv.YExcelPos = GetCellPos(arrCellPos[i])[1];
                    tfv.ExcelSheetName = activeSheetName;

                } else {
                    WF_TableFieldValue tfv = new WF_TableFieldValue();
                    tfv.ControlValue = arrRst[j];
                    tfv.FieldId = lp.LPID;
                    tfv.FieldName = lp.CellName;
                    tfv.XExcelPos = GetCellPos(arrCellPos[i])[0];
                    tfv.YExcelPos = GetCellPos(arrCellPos[i])[1];
                    tfv.ExcelSheetName = activeSheetName;
                    valuehs.Add(lp.LPID + "$" + arrCellPos[i], tfv);
                }
                j++;
            }
        }
コード例 #10
0
        public void ExportExcelSubmit(ref LP_Temple parentTemple, string orgid, string strProject, string strfenProject, bool isShow)
        {
            DSOFramerControl dsoFramerWordControl1 = new DSOFramerControl();
            string fname = Application.StartupPath + "\\00记录模板\\出库单.xls";
            dsoFramerWordControl1.FileOpen(fname);

            if (parentTemple == null)
            {
                parentTemple = new LP_Temple();
                parentTemple.Status = "文档生成";
            }
            parentTemple.DocContent = dsoFramerWordControl1.FileDataGzip;
            dsoFramerWordControl1.FileSave();
            dsoFramerWordControl1.FileClose();
            dsoFramerWordControl1.FileDataGzip = parentTemple.DocContent;
            ExcelAccess ex = new ExcelAccess();
            Microsoft.Office.Interop.Excel.Workbook wb = dsoFramerWordControl1.AxFramerControl.ActiveDocument as Microsoft.Office.Interop.Excel.Workbook;
            ex.MyWorkBook = wb;
            ex.MyExcel = wb.Application;

            string strfirst = "";
            string filter = "";
            string filter2 = "";
            string filter3 = "";
            string filter4 = "";
            if (strProject != "全部")
                filter2 = "  where 1=1 and ssgc='" + strProject + "'  and type = '撤旧材料出库单' ";
            else
                filter2 = "  where 1=1  and type = '撤旧材料出库单' ";

            IList mclist = ClientHelper.PlatformSqlMap.GetList("SelectOneStr", "select distinct ssgc  from PJ_clcrkd " + filter2 + " order by ssgc");

            foreach (string mc in mclist)
            {
                if (strfenProject == "全部")
                    filter3 = "  where 1=1 and type = '撤旧材料出库单' ";
                else
                    filter3 = "  where  ssxm='" + strfenProject + "'  and type = '撤旧材料出库单' ";

                IList xmlist = ClientHelper.PlatformSqlMap.GetList("SelectOneStr", "select distinct ssxm  from PJ_clcrkd " + filter3 + " order by ssxm");
                foreach (string xm in xmlist)
                {
                    filter4 = "  where 1=1 and type = '撤旧材料出库单'"
                        + "  and ssgc='" + mc + "' "
                        + "  and ssxm='" + xm + "' ";
                    //IList sjlist = ClientHelper.PlatformSqlMap.GetList("SelectOneStr", "select distinct CONVERT(varchar(50) ,indate, 112 )  from PJ_clcrkd " + filter4 + " ");
                    IList sjlist = ClientHelper.PlatformSqlMap.GetList("SelectOneStr", "select distinct num  from PJ_clcrkd " + filter4 + " ");
                    foreach (string sj in sjlist)
                    {
                        filter = "  where 1=1 and type = '撤旧材料出库单'"
                        + "  and ssgc='" + mc + "' "
                        + "  and ssxm='" + xm
                        + "' and num= '" + sj + "' ";
                        if (isWorkflowCall)
                        {

                            filter = filter + " and id not in (select ModleRecordID from WF_ModleRecordWorkTaskIns where  WorkFlowId='"
                                + WorkFlowData.Rows[0]["WorkFlowId"].ToString() + "') "
                                    + " or id in  (select ModleRecordID from WF_ModleRecordWorkTaskIns where "
                                + "    RecordID='" + currRecord.ID + "') "
                                ;
                        }

                        IList<PJ_clcrkd> datalist = Client.ClientHelper.PlatformSqlMap.GetListByWhere<PJ_clcrkd>(
                         filter
                           );
                        ExportExcel(ex, datalist);
                    }
                }

            }
            //ex.ActiveSheet(1);
            //ex.DeleteWorkSheet(1);
            Excel.Worksheet sheet;
            for (int i = 1; i <= wb.Application.Sheets.Count; i++)
            {
                sheet = wb.Application.Sheets[i] as Excel.Worksheet;
                sheet.Cells.Clear();
                sheet.Cells.ClearContents();
                sheet.Cells.ClearOutline();
                sheet.Visible = Excel.XlSheetVisibility.xlSheetHidden;
                dsoFramerWordControl1.FileSave();


                break;
            }
            if (parentTemple == null)
            {
                parentTemple = new LP_Temple();
                parentTemple.Status = "文档生成";
            }
            dsoFramerWordControl1.FileSave();
            parentTemple.DocContent = dsoFramerWordControl1.FileDataGzip;
            dsoFramerWordControl1.FileClose();
        }
コード例 #11
0
ファイル: ExportJGGCJH.cs プロジェクト: s7loves/mypowerscgl
 public void ExportExcelSubmit(ref LP_Temple parentTemple,  string orgid, bool isShow)
 {
    
 }
コード例 #12
0
ファイル: frmLP.cs プロジェクト: s7loves/mypowerscgl
        public void FillTime(ExcelAccess ea, LP_Temple lp, DateTime dt)
        {
            string[] arrCellPos = lp.CellPos.Split(pchar);
            arrCellPos = StringHelper.ReplaceEmpty(arrCellPos).Split(pchar);
            string[] extraWord = lp.ExtraWord.Split(pchar);
            IList<string> strList = new List<string>();
            //if (arrCellPos.Length == 5)
            //{
            //    strList.Add(dt.Year.ToString()); strList.Add(dt.Month.ToString());
            //    strList.Add(dt.Day.ToString()); strList.Add(dt.Hour.ToString()); strList.Add(dt.Minute.ToString());
            //}
            //else if (arrCellPos.Length == 4)
            //{
            //    strList.Add(dt.Day.ToString()); strList.Add(dt.Hour.ToString()); strList.Add(dt.Minute.ToString());
            //}
            //else if (arrCellPos.Length == 3)
            //{
            //    // strList.Add(dt.Year.ToString()); strList.Add(dt.Month.ToString());
            //    //strList.Add(dt.Day.ToString()); strList.Add(dt.Hour.ToString()); strList.Add(dt.Minute.ToString());
            //    strList.Add(dt.Year.ToString());
            //    strList.Add(dt.Month.ToString());
            //    strList.Add(dt.Day.ToString());
            //}
            //else if (arrCellPos.Length == 2)
            //{
            //    strList.Add(dt.Hour.ToString());
            //    strList.Add(dt.Minute.ToString());
            //}
            //else if (arrCellPos.Length == 1)
            //{
            //    strList.Add(dt.ToString());
            //}
            switch (lp.WordCount)
            {
                case "yyyy-MM-dd":

                    strList.Add(dt.Year.ToString());
                    strList.Add(string.Format("{0:D2}", dt.Month));
                    strList.Add(string.Format("{0:D2}", dt.Day));
                    break;
                case "yyyy-MM-dd HH:mm:ss":
                    strList.Add(dt.Year.ToString());
                    strList.Add(string.Format("{0:D2}", dt.Month));
                    strList.Add(string.Format("{0:D2}", dt.Day));
                    strList.Add(string.Format("{0:D2}", dt.Hour));
                    strList.Add(string.Format("{0:D2}", dt.Minute));
                    strList.Add(string.Format("{0:D2}", dt.Second));
                    break;
                case "HH:mm:ss":
                    strList.Add(dt.Hour.ToString());
                    strList.Add(string.Format("{0:D2}", dt.Minute));
                    strList.Add(string.Format("{0:D2}", dt.Second));
                    break;
                case "MM-dd日 HH:mm":
                    strList.Add(string.Format("{0:D2}", dt.Month));
                    strList.Add(string.Format("{0:D2}", dt.Day));
                    strList.Add(string.Format("{0:D2}", dt.Hour));
                    strList.Add(string.Format("{0:D2}", dt.Minute));
                    break;
                case "dd日 HH:mm":
                    strList.Add(string.Format("{0:D2}", dt.Day));
                    strList.Add(string.Format("{0:D2}", dt.Hour));
                    strList.Add(string.Format("{0:D2}", dt.Minute));
                    break;
                case "HH:mm":
                    strList.Add(string.Format("{0:D2}", dt.Hour));
                    strList.Add(string.Format("{0:D2}", dt.Minute));
                    break;
                default:
                    if (lp.WordCount.IndexOf("yyyy") > -1)
                    {
                        if (lp.WordCount.IndexOf("yyyy年") > -1)
                            strList.Add(dt.Year.ToString() + "年");
                        else
                            strList.Add(dt.Year.ToString());

                    }
                    if (lp.WordCount.IndexOf("MM") > -1)
                    {
                        if (lp.WordCount.IndexOf("MM月") > -1)
                            strList.Add(string.Format("{0:D2}", dt.Month) + "月");
                        else
                            strList.Add(string.Format("{0:D2}", dt.Month));
                    }
                    if (lp.WordCount.IndexOf("dd") > -1)
                    {
                        if (lp.WordCount.IndexOf("dd日") > -1)
                            strList.Add(string.Format("{0:D2}", dt.Day) + "日");
                        else
                            strList.Add(string.Format("{0:D2}", dt.Day));
                    }
                    if (lp.WordCount.IndexOf("HH") > -1)
                    {
                        if (lp.WordCount.IndexOf("HH时") > -1)
                            strList.Add(string.Format("{0:D2}", dt.Hour) + "时");
                        else
                            strList.Add(string.Format("{0:D2}", dt.Hour));
                    }
                    if (lp.WordCount.IndexOf("mm") > -1)
                    {
                        if (lp.WordCount.IndexOf("mm分") > -1)
                            strList.Add(string.Format("{0:D2}", dt.Minute) + "分");
                        else
                            strList.Add(string.Format("{0:D2}", dt.Minute));
                    }
                    if (lp.WordCount.IndexOf("ss") > -1)
                    {
                        if (lp.WordCount.IndexOf("ss秒") > -1)
                            strList.Add(string.Format("{0:D2}", dt.Second) + "秒");
                        else
                            strList.Add(string.Format("{0:D2}", dt.Second));
                    }
                    break;
            }
            // int i = 0;
            string value = lp.ExtraWord;
            for (int i = 0; i < strList.Count; i++)
            {
                //if (extraWord.Length > i)
                //{
                //    ea.SetCellValue(strList[i] + extraWord[i], GetCellPos(arrCellPos[i])[0], GetCellPos(arrCellPos[i])[1]);
                //    if (valuehs.ContainsKey(lp.LPID + "$" + arrCellPos[i]))
                //    {
                //        WF_TableFieldValue tfv = valuehs[lp.LPID + "$" + arrCellPos[i]] as WF_TableFieldValue;
                //        tfv.ControlValue = strList[i] + extraWord[i];
                //        tfv.FieldId = lp.LPID;
                //        tfv.FieldName = lp.CellName;
                //        tfv.XExcelPos = GetCellPos(arrCellPos[i])[0];
                //        tfv.YExcelPos = GetCellPos(arrCellPos[i])[1];
                //        tfv.ExcelSheetName = activeSheetName;

                //    }
                //    else
                //    {
                //        WF_TableFieldValue tfv = new WF_TableFieldValue();
                //        tfv.ControlValue = strList[i] + extraWord[i];
                //        tfv.FieldId = lp.LPID;
                //        tfv.FieldName = lp.CellName;
                //        tfv.XExcelPos = GetCellPos(arrCellPos[i])[0];
                //        tfv.YExcelPos = GetCellPos(arrCellPos[i])[1];
                //        tfv.ExcelSheetName = activeSheetName;
                //        valuehs.Add(lp.LPID + "$" + arrCellPos[i], tfv);
                //    }
                //}
                //else
                //{
                //    ea.SetCellValue(strList[i], GetCellPos(arrCellPos[i])[0], GetCellPos(arrCellPos[i])[1]);
                //    if (valuehs.ContainsKey(lp.LPID + "$" + arrCellPos[i]))
                //    {
                //        WF_TableFieldValue tfv = valuehs[lp.LPID + "$" + arrCellPos[i]] as WF_TableFieldValue;
                //        tfv.ControlValue = strList[i];
                //        tfv.FieldId = lp.LPID;
                //        tfv.FieldName = lp.CellName;
                //        tfv.XExcelPos = GetCellPos(arrCellPos[i])[0];
                //        tfv.YExcelPos = GetCellPos(arrCellPos[i])[1];
                //        tfv.ExcelSheetName = activeSheetName;

                //    }
                //    else
                //    {
                //        WF_TableFieldValue tfv = new WF_TableFieldValue();
                //        tfv.ControlValue = strList[i];
                //        tfv.FieldId = lp.LPID;
                //        tfv.FieldName = lp.CellName;
                //        tfv.XExcelPos = GetCellPos(arrCellPos[i])[0];
                //        tfv.YExcelPos = GetCellPos(arrCellPos[i])[1];
                //        tfv.ExcelSheetName = activeSheetName;
                //        valuehs.Add(lp.LPID + "$" + arrCellPos[i], tfv);
                //    }
                //}
                if (lp.ExtraWord == "")
                {
                    if (arrCellPos.Length > 1)
                    {
                        if (dt.ToString("yyyyMMdd") == "00010101")
                        {
                            strList[i] = " ";
                        }
                        try
                        {
                            if (lp.isExplorer != 1) ea.SetCellValue("'" + strList[i], GetCellPos(arrCellPos[i])[0], GetCellPos(arrCellPos[i])[1]);
                        }
                        catch { }

                        if (valuehs.ContainsKey(lp.LPID + "$" + arrCellPos[i]))
                        {
                            WF_TableFieldValue tfv = valuehs[lp.LPID + "$" + arrCellPos[i]] as WF_TableFieldValue;
                            tfv.ControlValue = strList[i];
                            tfv.FieldId = lp.LPID;
                            tfv.FieldName = lp.CellName;
                            tfv.XExcelPos = GetCellPos(arrCellPos[i])[0];
                            tfv.YExcelPos = GetCellPos(arrCellPos[i])[1];
                            tfv.ExcelSheetName = activeSheetName;

                            tfv = valuehs[lp.LPID + "$" + arrCellPos[i] + "时间"] as WF_TableFieldValue;
                            if (tfv != null)
                            {
                                tfv.ControlValue = dt.ToString();
                                tfv.FieldId = lp.LPID;
                                tfv.FieldName = lp.CellName + "完整时间";
                                tfv.XExcelPos = -1;
                                tfv.YExcelPos = -1;
                                tfv.ExcelSheetName = activeSheetName;
                            }
                        }
                        else
                        {
                            if (dt.ToString("yyyyMMdd") == "00010101")
                            {
                                strList[i] = " ";
                            }
                            WF_TableFieldValue tfv = new WF_TableFieldValue();
                            tfv.ControlValue = strList[i];
                            tfv.FieldId = lp.LPID;
                            tfv.FieldName = lp.CellName;
                            tfv.XExcelPos = GetCellPos(arrCellPos[i])[0];
                            tfv.YExcelPos = GetCellPos(arrCellPos[i])[1];
                            tfv.ExcelSheetName = activeSheetName;
                            valuehs.Add(lp.LPID + "$" + arrCellPos[i], tfv);

                            tfv = new WF_TableFieldValue();
                            tfv.FieldId = lp.LPID;
                            tfv.ControlValue = dt.ToString();
                            tfv.FieldName = lp.CellName + "完整时间";
                            tfv.XExcelPos = -1;
                            tfv.YExcelPos = -1;
                            tfv.ExcelSheetName = activeSheetName;
                            valuehs.Add(lp.LPID + "$" + arrCellPos[i] + "完整时间", tfv);


                        }
                    }
                    else
                    {
                        if (dt.ToString("yyyyMMdd") == "00010101")
                        {
                            //for (int item = 0; i < strList.Count; i++)
                            if (strList[i].IndexOf("年") > -1) strList[i] = "年";
                            else
                                if (strList[i].IndexOf("月") > -1) strList[i] = "      月";
                                else
                                    if (strList[i].IndexOf("日") > -1) strList[i] = "      日";
                                    else
                                        if (strList[i].IndexOf("时") > -1) strList[i] = "      时";
                                        else
                                            if (strList[i].IndexOf("分") > -1) strList[i] = "      分";
                        }
                        value += strList[i];
                        if (strList.Count == i + 1)
                        {
                            try
                            {
                                if (lp.isExplorer != 1) ea.SetCellValue("'" + value, GetCellPos(arrCellPos[0])[0], GetCellPos(arrCellPos[0])[1]);
                            }
                            catch { }
                            if (valuehs.ContainsKey(lp.LPID + "$" + arrCellPos[0]))
                            {
                                WF_TableFieldValue tfv = valuehs[lp.LPID + "$" + arrCellPos[0]] as WF_TableFieldValue;
                                tfv.ControlValue = value;
                                tfv.FieldId = lp.LPID;
                                tfv.FieldName = lp.CellName;
                                tfv.XExcelPos = GetCellPos(arrCellPos[0])[0];
                                tfv.YExcelPos = GetCellPos(arrCellPos[0])[1];
                                tfv.ExcelSheetName = activeSheetName;

                                tfv = valuehs[lp.LPID + "$" + arrCellPos[0] + "时间"] as WF_TableFieldValue;
                                if (tfv != null)
                                {
                                    tfv.ControlValue = dt.ToString();
                                    tfv.FieldId = lp.LPID;
                                    tfv.FieldName = lp.CellName + "完整时间";
                                    tfv.XExcelPos = -1;
                                    tfv.YExcelPos = -1;
                                    tfv.ExcelSheetName = activeSheetName;
                                }

                            }
                            else
                            {
                                WF_TableFieldValue tfv = new WF_TableFieldValue();
                                tfv.ControlValue = value;
                                tfv.FieldId = lp.LPID;
                                tfv.FieldName = lp.CellName;
                                tfv.XExcelPos = GetCellPos(arrCellPos[0])[0];
                                tfv.YExcelPos = GetCellPos(arrCellPos[0])[1];
                                tfv.ExcelSheetName = activeSheetName;
                                valuehs.Add(lp.LPID + "$" + arrCellPos[0], tfv);

                                tfv = new WF_TableFieldValue();
                                tfv.FieldId = lp.LPID;
                                tfv.ControlValue = dt.ToString();
                                tfv.FieldName = lp.CellName + "完整时间";
                                tfv.XExcelPos = -1;
                                tfv.YExcelPos = -1;
                                tfv.ExcelSheetName = activeSheetName;
                                valuehs.Add(lp.LPID + "$" + arrCellPos[0] + "完整时间", tfv);
                            }
                        }
                    }
                }
                else
                {
                    if (dt.ToString("yyyyMMdd") == "00010101")
                    {
                        strList[i] = " ";
                    }
                    if (lp.ExtraWord.IndexOf("|") == -1)
                    {
                        value = value.Replace("{" + i + "}", strList[i]);
                        if (i == strList.Count - 1)
                        {
                            try
                            {
                                if (lp.isExplorer != 1) ea.SetCellValue("'" + value, GetCellPos(arrCellPos[0])[0], GetCellPos(arrCellPos[0])[1]);
                            }
                            catch { }
                            if (valuehs.ContainsKey(lp.LPID + "$" + arrCellPos[0]))
                            {
                                WF_TableFieldValue tfv = valuehs[lp.LPID + "$" + arrCellPos[0]] as WF_TableFieldValue;
                                tfv.ControlValue = value;
                                tfv.FieldId = lp.LPID;
                                tfv.FieldName = lp.CellName;
                                tfv.XExcelPos = GetCellPos(arrCellPos[0])[0];
                                tfv.YExcelPos = GetCellPos(arrCellPos[0])[1];
                                tfv.ExcelSheetName = activeSheetName;

                                tfv = valuehs[lp.LPID + "$" + arrCellPos[0] + "时间"] as WF_TableFieldValue;
                                if (tfv != null)
                                {
                                    tfv.ControlValue = dt.ToString();
                                    tfv.FieldId = lp.LPID;
                                    tfv.FieldName = lp.CellName + "完整时间";
                                    tfv.XExcelPos = -1;
                                    tfv.YExcelPos = -1;
                                    tfv.ExcelSheetName = activeSheetName;
                                }
                            }
                            else
                            {
                                WF_TableFieldValue tfv = new WF_TableFieldValue();
                                tfv.ControlValue = value;
                                tfv.FieldId = lp.LPID;
                                tfv.FieldName = lp.CellName;
                                tfv.XExcelPos = GetCellPos(arrCellPos[0])[0];
                                tfv.YExcelPos = GetCellPos(arrCellPos[0])[1];
                                tfv.ExcelSheetName = activeSheetName;
                                valuehs.Add(lp.LPID + "$" + arrCellPos[0], tfv);

                                tfv = new WF_TableFieldValue();
                                tfv.FieldId = lp.LPID;
                                tfv.ControlValue = dt.ToString();
                                tfv.FieldName = lp.CellName + "完整时间";
                                tfv.XExcelPos = -1;
                                tfv.YExcelPos = -1;
                                tfv.ExcelSheetName = activeSheetName;
                                valuehs.Add(lp.LPID + "$" + arrCellPos[0] + "完整时间", tfv);

                            }
                        }

                    }
                    else
                    {
                        if (dt.ToString("yyyyMMdd") == "00010101")
                        {
                            strList[i] = " ";
                        }
                        string[] strextrlist = lp.ExtraWord.Split('|');
                        value = strList[i];
                        if (strextrlist.Length > i)
                            value += strextrlist[i];
                        try
                        {
                            if (lp.isExplorer != 1) ea.SetCellValue("'" + value, GetCellPos(arrCellPos[i])[0], GetCellPos(arrCellPos[i])[1]);
                        }
                        catch { }
                        if (valuehs.ContainsKey(lp.LPID + "$" + arrCellPos[0]))
                        {
                            WF_TableFieldValue tfv = valuehs[lp.LPID + "$" + arrCellPos[0]] as WF_TableFieldValue;
                            tfv.ControlValue = value;
                            tfv.FieldId = lp.LPID;
                            tfv.FieldName = lp.CellName;
                            tfv.XExcelPos = GetCellPos(arrCellPos[0])[0];
                            tfv.YExcelPos = GetCellPos(arrCellPos[0])[1];
                            tfv.ExcelSheetName = activeSheetName;

                            tfv = valuehs[lp.LPID + "$" + arrCellPos[0] + "时间"] as WF_TableFieldValue;
                            if (tfv != null)
                            {
                                tfv.ControlValue = dt.ToString();
                                tfv.FieldId = lp.LPID;
                                tfv.FieldName = lp.CellName + "完整时间";
                                tfv.XExcelPos = -1;
                                tfv.YExcelPos = -1;
                                tfv.ExcelSheetName = activeSheetName;
                            }
                        }
                        else
                        {
                            WF_TableFieldValue tfv = new WF_TableFieldValue();
                            tfv.ControlValue = value;
                            tfv.FieldId = lp.LPID;
                            tfv.FieldName = lp.CellName;
                            tfv.XExcelPos = GetCellPos(arrCellPos[0])[0];
                            tfv.YExcelPos = GetCellPos(arrCellPos[0])[1];
                            tfv.ExcelSheetName = activeSheetName;
                            valuehs.Add(lp.LPID + "$" + arrCellPos[0], tfv);

                            tfv = new WF_TableFieldValue();
                            tfv.FieldId = lp.LPID;
                            tfv.ControlValue = dt.ToString();
                            tfv.FieldName = lp.CellName + "完整时间";
                            tfv.XExcelPos = -1;
                            tfv.YExcelPos = -1;
                            tfv.ExcelSheetName = activeSheetName;
                            valuehs.Add(lp.LPID + "$" + arrCellPos[0] + "完整时间", tfv);
                        }
                    }
                    //ea.SetCellValue(strList[i], GetCellPos(arrCellPos[i])[0], GetCellPos(arrCellPos[i])[1]);

                }

            }
            //foreach (string str in strList)
            //{
            //    ea.SetCellValue(str, GetCellPos(arrCellPos[i])[0], GetCellPos(arrCellPos[i])[1]);
            //    i++;
            //}
        }
コード例 #13
0
ファイル: frmLP.cs プロジェクト: s7loves/mypowerscgl
        public void FillMutilRows(ExcelAccess ea, int i, LP_Temple lp, string str, List<int> arrCellCount, string[] arrCellPos)
        {
            StringHelper help = new StringHelper();

            string[] extraWord = lp.ExtraWord.Split(pchar);
            if (lp.CtrlType.IndexOf("uc_gridcontrol") > -1)
            {
                str = help.GetPlitString(str, arrCellCount[1]);
                string[] arrRst = str.Split(new string[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries);
                int j = 0;
                for (; i < arrCellPos.Length; i++)
                {
                    if (j >= arrRst.Length)
                        break;
                    try
                    {
                        if (lp.isExplorer != 1) ea.SetCellValue(arrRst[j], GetCellPos(arrCellPos[i])[0], GetCellPos(arrCellPos[i])[1]);
                    }
                    catch { }
                    if (valuehs.ContainsKey(lp.LPID + "$" + arrCellPos[i]))
                    {
                        WF_TableFieldValue tfv = valuehs[lp.LPID + "$" + arrCellPos[i]] as WF_TableFieldValue;
                        tfv.ControlValue = arrRst[j];
                        tfv.FieldId = lp.LPID;
                        tfv.FieldName = lp.CellName;
                        tfv.XExcelPos = GetCellPos(arrCellPos[i])[0];
                        tfv.YExcelPos = GetCellPos(arrCellPos[i])[1];
                        tfv.ExcelSheetName = activeSheetName;

                    }
                    else
                    {
                        WF_TableFieldValue tfv = new WF_TableFieldValue();
                        tfv.ControlValue = arrRst[j];
                        tfv.FieldId = lp.LPID;
                        tfv.FieldName = lp.CellName;
                        tfv.XExcelPos = GetCellPos(arrCellPos[i])[0];
                        tfv.YExcelPos = GetCellPos(arrCellPos[i])[1];
                        tfv.ExcelSheetName = activeSheetName;
                        valuehs.Add(lp.LPID + "$" + arrCellPos[i], tfv);
                    }
                    j++;
                }
            }
            else
            {
                string strarrRst = str;
                int i1 = strarrRst.IndexOf("\r\n");

                for (; i < arrCellPos.Length; i++)
                {
                    i1 = strarrRst.IndexOf("\r\n");
                    if (i1 > help.GetFristLen(strarrRst, arrCellCount[i]))
                        i1 = help.GetFristLen(strarrRst, arrCellCount[i]);
                    if (i1 == 0)
                    {
                        strarrRst = strarrRst.Substring(2);
                        i1 = strarrRst.IndexOf("\r\n");
                        if (i1 > help.GetFristLen(strarrRst, arrCellCount[i]))
                            i1 = help.GetFristLen(strarrRst, arrCellCount[i]);
                    }
                    if (i1 == -1)
                        i1 = help.GetFristLen(str, arrCellCount[i]);
                    if (strarrRst.Length > i1 + 1 && (strarrRst.Substring(i1, 1) == "," || strarrRst.Substring(i1, 1) == "。" || strarrRst.Substring(i1 + 1, 1) == "、" || strarrRst.Substring(i1 + 1, 1) == ":" || strarrRst.Substring(i1 + 1, 1) == "!"))
                    {
                        i1 = i1 + 1;
                    }
                    //if (strarrRst.Length <= help.GetFristLen(str, arrCellCount[i]))
                    //{
                    //    try
                    //    {
                    //        if (lp.isExplorer != 1) ea.SetCellValue(strarrRst, GetCellPos(arrCellPos[i])[0], GetCellPos(arrCellPos[i])[1]);
                    //    }
                    //    catch { }
                    //    if (valuehs.ContainsKey(lp.LPID + "$" + arrCellPos[i]))
                    //    {
                    //        WF_TableFieldValue tfv = valuehs[lp.LPID + "$" + arrCellPos[i]] as WF_TableFieldValue;
                    //        tfv.ControlValue = strarrRst;
                    //        tfv.FieldId = lp.LPID;
                    //        tfv.FieldName = lp.CellName;
                    //        tfv.XExcelPos = GetCellPos(arrCellPos[i])[0];
                    //        tfv.YExcelPos = GetCellPos(arrCellPos[i])[1];
                    //        tfv.ExcelSheetName = activeSheetName;

                    //    }
                    //    else
                    //    {
                    //        WF_TableFieldValue tfv = new WF_TableFieldValue();
                    //        tfv.ControlValue = strarrRst;
                    //        tfv.FieldId = lp.LPID;
                    //        tfv.FieldName = lp.CellName;
                    //        tfv.XExcelPos = GetCellPos(arrCellPos[i])[0];
                    //        tfv.YExcelPos = GetCellPos(arrCellPos[i])[1];
                    //        tfv.ExcelSheetName = activeSheetName;
                    //        valuehs.Add(lp.LPID + "$" + arrCellPos[i], tfv);
                    //    }
                    //    break;
                    //}
                    //else
                    {
                        if (strarrRst.Length >= i1)
                        {
                            try
                            {
                                if (lp.isExplorer != 1) if (lp.isExplorer != 1) ea.SetCellValue(strarrRst.Substring(0, i1), GetCellPos(arrCellPos[i])[0], GetCellPos(arrCellPos[i])[1]);
                            }
                            catch { }
                            if (valuehs.ContainsKey(lp.LPID + "$" + arrCellPos[i]))
                            {
                                WF_TableFieldValue tfv = valuehs[lp.LPID + "$" + arrCellPos[i]] as WF_TableFieldValue;
                                tfv.ControlValue = strarrRst.Substring(0, i1);
                                tfv.FieldId = lp.LPID;
                                tfv.FieldName = lp.CellName;
                                tfv.XExcelPos = GetCellPos(arrCellPos[i])[0];
                                tfv.YExcelPos = GetCellPos(arrCellPos[i])[1];
                                tfv.ExcelSheetName = activeSheetName;

                            }
                            else
                            {
                                WF_TableFieldValue tfv = new WF_TableFieldValue();
                                tfv.ControlValue = strarrRst.Substring(0, i1);
                                tfv.FieldId = lp.LPID;
                                tfv.FieldName = lp.CellName;
                                tfv.XExcelPos = GetCellPos(arrCellPos[i])[0];
                                tfv.YExcelPos = GetCellPos(arrCellPos[i])[1];
                                tfv.ExcelSheetName = activeSheetName;
                                valuehs.Add(lp.LPID + "$" + arrCellPos[i], tfv);
                            }
                            strarrRst = strarrRst.Substring(i1);
                        }
                        else
                        {
                            try
                            {
                                if (lp.isExplorer != 1) if (lp.isExplorer != 1) ea.SetCellValue(strarrRst, GetCellPos(arrCellPos[i])[0], GetCellPos(arrCellPos[i])[1]);
                            }
                            catch { }
                            if (valuehs.ContainsKey(lp.LPID + "$" + arrCellPos[i]))
                            {
                                WF_TableFieldValue tfv = valuehs[lp.LPID + "$" + arrCellPos[i]] as WF_TableFieldValue;
                                tfv.ControlValue = strarrRst;
                                tfv.FieldId = lp.LPID;
                                tfv.FieldName = lp.CellName;
                                tfv.XExcelPos = GetCellPos(arrCellPos[i])[0];
                                tfv.YExcelPos = GetCellPos(arrCellPos[i])[1];
                                tfv.ExcelSheetName = activeSheetName;

                            }
                            else
                            {
                                WF_TableFieldValue tfv = new WF_TableFieldValue();
                                tfv.ControlValue = strarrRst;
                                tfv.FieldId = lp.LPID;
                                tfv.FieldName = lp.CellName;
                                tfv.XExcelPos = GetCellPos(arrCellPos[i])[0];
                                tfv.YExcelPos = GetCellPos(arrCellPos[i])[1];
                                tfv.ExcelSheetName = activeSheetName;
                                valuehs.Add(lp.LPID + "$" + arrCellPos[i], tfv);
                            }
                            strarrRst = "";
                        }
                        //i++;
                        //strarrRst = help.GetPlitString(strarrRst, arrCellCount[i]);
                    }


                }
            }
        }
コード例 #14
0
ファイル: frmLP.cs プロジェクト: s7loves/mypowerscgl
        public static IList GetTaskCtrlData2(LP_Record record, LP_Temple lp, string sqlSentence, WF_WorkTastTrans wtt)
        {

            //LP_Temple lp =null ;
            string ctrltype = "";

            //if (lp.CtrlType.IndexOf(',') == -1)
            //    ctrltype = lp.CtrlType;
            //else
            //    ctrltype = lp.CtrlType.Substring(0, lp.CtrlType.IndexOf(','));
            /*
             * 
             * SELECT   cellname,  SqlSentence,SqlColName
                FROM         LP_Temple
                where SqlSentence !=''
             * 
             * */
            IList li = new ArrayList();
            if (sqlSentence.IndexOf("Excel:") == 0)
            {
                //int index1 = sqlSentence.LastIndexOf(":");
                //string tablename = sqlSentence.Substring(6, index1 - 6);
                //string cellpos = sqlSentence.Substring(index1 + 1);
                //string[] arrCellPos = cellpos.Split('|');
                //arrCellPos = StringHelper.ReplaceEmpty(arrCellPos).Split('|');
                //string strcellvalue = "";
                //Excel.Workbook wb = dsoFramerWordControl1.AxFramerControl.ActiveDocument as Excel.Workbook;
                //ExcelAccess ea = new ExcelAccess();
                //ea.MyWorkBook = wb;
                //ea.MyExcel = wb.Application;
                //Excel.Worksheet sheet;
                //sheet = wb.Application.Sheets[tablename] as Excel.Worksheet;

                //for (int i = 0; i < arrCellPos.Length; i++) {
                //    Excel.Range range = sheet.get_Range(sheet.Cells[GetCellPos(arrCellPos[i])[0], GetCellPos(arrCellPos[i])[1]], sheet.Cells[GetCellPos(arrCellPos[i])[0], GetCellPos(arrCellPos[i])[1]]);//坐标
                //    strcellvalue += range.Value2;
                //}
                //li.Add(strcellvalue);
            }
            else if (sqlSentence != "")
            {
                if (sqlSentence.IndexOf("{recordparentid}") > -1)
                {
                    sqlSentence = sqlSentence.Replace("{recordparentid}", record.ParentID);
                }
                if (sqlSentence.IndexOf("{recordid}") > -1)
                {
                    sqlSentence = sqlSentence.Replace("{recordid}", record.ID);
                }
                if (sqlSentence.IndexOf("{orgcode}") > -1)
                {
                    sqlSentence = sqlSentence.Replace("{orgcode}", MainHelper.User.OrgCode);
                }
                if (sqlSentence.IndexOf("{userid}") > -1)
                {
                    sqlSentence = sqlSentence.Replace("{userid}", MainHelper.User.UserID);
                }
                if (sqlSentence.IndexOf("{orgname}") > -1)
                {
                    sqlSentence = sqlSentence.Replace("{orgname}", MainHelper.User.OrgName);
                }
                if (sqlSentence.IndexOf("{username}") > -1)
                {
                    sqlSentence = sqlSentence.Replace("{username}", MainHelper.User.UserName);
                }
                Regex r1 = new Regex(@"(?<={)[0-9]+(?=})");
                while (r1.Match(sqlSentence).Value != "")
                {
                    string sortid = r1.Match(sqlSentence).Value;
                    IList<LP_Temple> listLPID = ClientHelper.PlatformSqlMap.GetList<LP_Temple>("SelectLP_TempleList", " where sortID = '" + sortid + "' and parentid = '" + lp.ParentID + "'");
                    if (listLPID.Count > 0)
                    {
                        //Control ct = FindCtrl(listLPID[0].LPID);
                        //if (ct != null) {
                        //    if (ct is DateEdit) {
                        //        ((DateEdit)ct).Properties.EditMask = listLPID[0].WordCount;
                        //        ((DateEdit)ct).Properties.DisplayFormat.FormatString = listLPID[0].WordCount;
                        //    }
                        //    sqlSentence = sqlSentence.Replace("{" + sortid + "}", ct.Text);
                        //} else {
                        string strSQL = "select ControlValue from WF_TableFieldValueView where"
                              + " UserControlId='" + listLPID[0].ParentID + "' "
                              + "and FieldId='" + listLPID[0].LPID + "' and ID='" + record.ID + "'";
                        li = Client.ClientHelper.PlatformSqlMap.GetList("SelectOneStr", strSQL);
                        if (li.Count > 0)
                        {
                            sqlSentence = sqlSentence.Replace("{" + sortid + "}", li[0].ToString());
                        }
                        else
                        {
                            sqlSentence = sqlSentence.Replace("{" + sortid + "}", "没有找到对应的值,请检查SQL语句设置");
                            break;
                        }
                        //}

                    }
                    else
                    {
                        sqlSentence = sqlSentence.Replace("{" + sortid + "}", "没有找到对应的值,请检查SQL语句设置");
                        break;
                    }
                }
                //r1 = new Regex(@"(?<={编号规则一:)[0-9]+(?=})");
                //if (r1.Match(sqlSentence).Value != "") {
                //    string sortid = r1.Match(sqlSentence).Value;
                //    IList<LP_Temple> listLPID = ClientHelper.PlatformSqlMap.GetList<LP_Temple>("SelectLP_TempleList", " where sortID = '" + sortid + "' and parentid = '" + lp.ParentID + "'");
                //    if (listLPID.Count > 0) {
                //        Control ct = FindCtrl(listLPID[0].LPID);
                //        if (ct != null) {
                //            IList<mOrg> list = Client.ClientHelper.PlatformSqlMap.GetList<mOrg>("SelectmOrgList",
                //                "where OrgName='" + ct.Text + "'");
                //            if (list.Count > 0)
                //                sqlSentence = sqlSentence.Replace("{编号规则一:" + sortid + "}", RecordWorkTask.CreatWorkFolwNo(list[0], listLPID[0].ParentID, "编号规则一"));
                //            else
                //                sqlSentence = sqlSentence.Replace("{编号规则一:" + sortid + "}", "");

                //        } else {
                //            sqlSentence = sqlSentence.Replace("{编号规则一:" + sortid + "}", "出错,没有找到单位控件");

                //        }
                //    } else {
                //        sqlSentence = sqlSentence.Replace("{编号规则一:" + sortid + "}", "出错,没有找到单位控件");

                //    }

                //}
                try
                {
                    sqlSentence = sqlSentence.Replace("\r\n", " ");

                    if (sqlSentence.IndexOf("where 9=9") > -1)
                    {
                        string strtemp = li[0].ToString();
                        li.Clear();
                        r1 = new Regex(@"[0-9]+\+[0-9]+");
                        if (r1.Match(strtemp).Value != "")
                        {
                            int istart = 1;
                            int ilen = 10;
                            r1 = new Regex(@"[0-9]+(?=\+)");
                            if (r1.Match(strtemp).Value != "")
                            {
                                istart = Convert.ToInt32(r1.Match(strtemp).Value);
                            }
                            r1 = new Regex(@"(?<=\+)[0-9]+");
                            if (r1.Match(strtemp).Value != "")
                            {
                                ilen = Convert.ToInt32(r1.Match(strtemp).Value); ;
                            }
                            for (int i = istart; i <= ilen; i++)
                            {
                                li.Add(string.Format("{0}", i));
                            }
                        }
                        else
                        {
                            string[] strli = SelectorHelper.ToDBC(strtemp).Split(',');
                            foreach (string ss in strli)
                            {
                                li.Add(ss);
                            }
                        }
                    }
                    else
                    {
                        IList ht = Client.ClientHelper.PlatformSqlMap.GetList("Select", sqlSentence);
                        if (ht.Count > 0)
                        {
                            DataTable dt = ConvertHelper.ToDataTable(ht);
                            li.Add(dt.Rows[0][0]);
                        }
                    }
                }
                catch (Exception ex)
                {
                    li.Add("出错:" + ex.Message);
                }
            }
            return li;
        }
コード例 #15
0
ファイル: frmLP.cs プロジェクト: s7loves/mypowerscgl
 public static Dictionary<string, object> ReadTaskData(DataTable workflowdata, LP_Temple temp, LP_Record record)
 {
     Dictionary<string, object> dic = new Dictionary<string, object>();
     IList<WF_WorkTastTrans> wttli = MainHelper.PlatformSqlMap.GetList<WF_WorkTastTrans>(" where WorkFlowId='" + workflowdata.Rows[0]["WorkFlowId"].ToString() + "' AND tlcjdid='" + workflowdata.Rows[0]["WorkTaskId"].ToString() + "' and tlcjdzdlx = '模块'");
     foreach (WF_WorkTastTrans wtt in wttli)
     {
         IList list = GetTaskCtrlData2(record, temp, wtt.sSQL, wtt);
         if (list.Count > 0)
             dic.Add(wtt.tlcjdzdid, list[0]);
     }
     return dic;
 }
コード例 #16
0
ファイル: UCmExcel.cs プロジェクト: s7loves/mypowerscgl
 /// <summary>
 /// 新建对象设置Key值
 /// </summary>
 /// <param name="newobj"></param>
 void gridViewOperation_CreatingObjectEvent(LP_Temple newobj) {
     //newobj.OrgCode = parentID;
     //newobj.OrgName = parentObj.OrgName;
     //newobj.Valid = true;          
     newobj.ParentID = parentID;
     newobj.Kind = ParentObj.Kind;
     byte[] bt = new byte[0];
     newobj.DocContent = bt;
     newobj.ImageAttachment = bt;
     newobj.SignImg = bt;
 }
コード例 #17
0
ファイル: UCmExcel.cs プロジェクト: s7loves/mypowerscgl
 void gridViewOperation_AfterAdd(LP_Temple obj)
 {
     parentID = ParentObj.LPID;
 }
コード例 #18
0
ファイル: WorkFlowTask.cs プロジェクト: s7loves/mypowerscgl
        /// <summary>
        /// 获得任务节点绑定的表单
        /// </summary>
        /// <param name="workflowId">任务模板Id</param>
        /// <returns></returns>
        public static DataTable GetTaskControls(string workTaskId)
        {
            try
            {
                string sqlStr = " where WorkTaskId ='" + workTaskId + "' and  ControlType = '表单' ";
                IList li = MainHelper.PlatformSqlMap.GetList("SelectWF_WorkTaskControlsList", sqlStr);
                if (li.Count == 0 || ((WF_WorkTaskControls)li[0]).UserControlId == "")
                {
                    DataTable dt = new DataTable();

                    return dt;
                }
                else
                {
                    if (((WF_WorkTaskControls)li[0]).UserControlId != "节点审核")
                    {
                        sqlStr = " where LPID ='" + ((WF_WorkTaskControls)li[0]).UserControlId + "'";
                        li = MainHelper.PlatformSqlMap.GetList("SelectLP_TempleList", sqlStr);

                    }
                    else
                    {
                        li.Clear();
                        LP_Temple lp = new LP_Temple();
                        lp.LPID = "节点审核";
                        lp.CellName = "节点提交";
                        li.Add(lp);
                        
                      
                    }

                
                }
                if (li.Count == 0 )
                {
                    DataTable dt = new DataTable();
                    return dt; 
                    
                }
                return ConvertHelper.ToDataTable(li); 
               
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #19
0
ファイル: uc_gridcontrol.cs プロジェクト: s7loves/mypowerscgl
        public void InitCtrlData2(RepositoryItemCheckedComboBoxEdit combox, int index, LP_Temple lp, string sqlSentence, DSOFramerControl dsoFramerWordControl1, LP_Record currRecord) {


            string ctrltype = "";
            if (lp.CtrlType.IndexOf(',') == -1)
                ctrltype = lp.CtrlType;
            else
                ctrltype = lp.CtrlType.Substring(0, lp.CtrlType.IndexOf(','));
            /*
             * 
             * SELECT   cellname,  SqlSentence,SqlColName
                FROM         LP_Temple
                where SqlSentence !=''
             * 
             * */
            IList li = new ArrayList();
            if (sqlSentence.IndexOf("Excel:") == 0) {
                int index1 = sqlSentence.LastIndexOf(":");
                string tablename = sqlSentence.Substring(6, index1 - 6);
                string cellpos = sqlSentence.Substring(index1 + 1);
                string[] arrCellPos = cellpos.Split('|');
                arrCellPos = StringHelper.ReplaceEmpty(arrCellPos).Split('|');
                string strcellvalue = "";
                Excel.Workbook wb = dsoFramerWordControl1.AxFramerControl.ActiveDocument as Excel.Workbook;
                ExcelAccess ea = new ExcelAccess();
                ea.MyWorkBook = wb;
                ea.MyExcel = wb.Application;
                Excel.Worksheet sheet;
                sheet = wb.Application.Sheets[tablename] as Excel.Worksheet;

                for (int i = 0; i < arrCellPos.Length; i++) {
                    Excel.Range range = sheet.get_Range(sheet.Cells[GetCellPos(arrCellPos[i])[0], GetCellPos(arrCellPos[i])[1]], sheet.Cells[GetCellPos(arrCellPos[i])[0], GetCellPos(arrCellPos[i])[1]]);//坐标
                    strcellvalue += range.Value2;
                }
                li.Add(strcellvalue);
            } else if (sqlSentence != "") {
                if (sqlSentence.IndexOf("{recordid}") > -1) {
                    sqlSentence = sqlSentence.Replace("{recordid}", currRecord.ID);
                }
                if (sqlSentence.IndexOf("{orgcode}") > -1) {
                    sqlSentence = sqlSentence.Replace("{orgcode}", MainHelper.User.OrgCode);
                }
                if (sqlSentence.IndexOf("{userid}") > -1) {
                    sqlSentence = sqlSentence.Replace("{userid}", MainHelper.User.UserID);
                }
                Regex r1 = new Regex(@"(?<={)[0-9]+(?=})");
                while (r1.Match(sqlSentence).Value != "") {
                    string sortid = r1.Match(sqlSentence).Value;
                    IList<LP_Temple> listLPID = ClientHelper.PlatformSqlMap.GetList<LP_Temple>("SelectLP_TempleList", " where sortID = '" + sortid + "' and parentid = '" + lp.ParentID + "'");
                    if (listLPID.Count > 0) {



                        string strSQL = "select ControlValue from WF_TableFieldValueView where"
                              + " UserControlId='" + listLPID[0].ParentID + "' "
                              + "and FieldId='" + listLPID[0].LPID + "' and ID='" + currRecord.ID + "'";
                        li = Client.ClientHelper.PlatformSqlMap.GetList("SelectOneStr", strSQL);
                        if (li.Count > 0) {
                            sqlSentence = sqlSentence.Replace("{" + sortid + "}", li[0].ToString());
                        } else {
                            sqlSentence = sqlSentence.Replace("{" + sortid + "}", "没有找到对应的值,请检查SQL语句设置");
                            break;
                        }

                    } else {
                        sqlSentence = sqlSentence.Replace("{" + sortid + "}", "没有找到对应的值,请检查SQL语句设置");
                        break;
                    }
                }
                r1 = new Regex(@"(?<={编号规则一:)[0-9]+(?=})");
                if (r1.Match(sqlSentence).Value != "") {
                    string sortid = r1.Match(sqlSentence).Value;
                    IList<LP_Temple> listLPID = ClientHelper.PlatformSqlMap.GetList<LP_Temple>("SelectLP_TempleList", " where sortID = '" + sortid + "' and parentid = '" + lp.ParentID + "'");
                    if (listLPID.Count > 0) {

                        sqlSentence = sqlSentence.Replace("{编号规则一:" + sortid + "}", "出错,没有找到单位控件");


                    } else {
                        sqlSentence = sqlSentence.Replace("{编号规则一:" + sortid + "}", "出错,没有找到单位控件");

                    }

                }

                sqlSentence = sqlSentence.Replace("\r\n", "");

                try {
                    li = Client.ClientHelper.PlatformSqlMap.GetList("SelectOneStr", sqlSentence);
                } catch (Exception ex) {
                    li.Add(sqlSentence + "出错:" + ex.Message);

                }
                if (sqlSentence.IndexOf("where 9=9") == -1) {
                    foreach (string strname in li) {
                        combox.Items.Add(strname);
                    }
                } else {

                    switch (li[0].ToString()) {
                        case "{年}":
                            combox.Items.Clear();
                            for (int j = 0; j <= 20; j++) {
                                combox.Items.Add(string.Format("{0}", j + DateTime.Now.Year));

                            }

                            break;
                        case "{月}":
                            combox.Items.Clear();
                            for (int j = 1; j <= 12; j++) {
                                combox.Items.Add(string.Format("{0:D2}", j));

                            }
                            break;
                        case "{日}":
                            combox.Items.Clear();
                            for (int j = 1; j <= 31; j++) {
                                combox.Items.Add(string.Format("{0:D2}", j));

                            }
                            break;
                        case "{时}":
                            combox.Items.Clear();
                            for (int j = 1; j <= 24; j++) {
                                combox.Items.Add(string.Format("{0:D2}", j));

                            }
                            break;
                        case "{分}":
                        case "{秒}":
                            combox.Items.Clear();
                            for (int j = 0; j <= 59; j++) {
                                combox.Items.Add(string.Format("{0:D2}", j));

                            }
                            break;
                        default:
                            string strexpress = li[0].ToString();
                            r1 = new Regex(@"[0-9]+\+[0-9]+");
                            if (r1.Match(strexpress).Value != "") {
                                int istart = 1;
                                int ilen = 10;
                                r1 = new Regex(@"[0-9]+(?=\+)");
                                if (r1.Match(strexpress).Value != "") {
                                    istart = Convert.ToInt32(r1.Match(strexpress).Value);
                                }
                                r1 = new Regex(@"(?<=\+)[0-9]+");
                                if (r1.Match(strexpress).Value != "") {
                                    ilen = Convert.ToInt32(r1.Match(strexpress).Value); ;
                                }
                                for (int i = istart; i <= ilen; i++) {
                                    combox.Items.Add(string.Format("{0}", i));
                                }
                            } else {
                                string[] strItem = SelectorHelper.ToDBC(strexpress).Split(',');
                                for (int i = 0; i < strItem.Length; i++) {
                                    combox.Items.Add(strItem[i]);
                                }

                            }
                            break;
                    }

                }
            }
        }
コード例 #20
0
ファイル: frmModleSubmit.cs プロジェクト: s7loves/mypowerscgl
        public void FillMutilRows(ExcelAccess ea, int i, LP_Temple lp, string str, List<int> arrCellCount, string[] arrCellPos)
        {
            StringHelper help = new StringHelper();
            str = help.GetPlitString(str, arrCellCount[1]);            
            string[] extraWord = lp.ExtraWord.Split(pchar);          

            string[] arrRst = str.Split(new string[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries);
            int j = 0;
            for (; i < arrCellPos.Length; i++)
            {
                if (j >= arrRst.Length)
                    break;
                ea.SetCellValue(arrRst[j], GetCellPos(arrCellPos[i])[0], GetCellPos(arrCellPos[i])[1]);
                j++;
            }
        }
コード例 #21
0
ファイル: uc_gridcontrol.cs プロジェクト: s7loves/mypowerscgl
        public void InitData(string sql, string[] sqlColName, string[] comBoxItem, DSOFramerControl dsoFramerWordControl1, LP_Temple lp, LP_Record currRecord) {


            //foreach (DevExpress.XtraEditors.Repository.RepositoryItemComboBox combox in colctrllist)
            for (int i = 0; i < gridView1.Columns.Count; i++) {
                if (gridView1.Columns[i].ColumnEdit is RepositoryItemComboBox) {
                    RepositoryItemComboBox combox = gridView1.Columns[i].ColumnEdit as RepositoryItemComboBox;
                    combox.Items.Clear();

                    Regex r1 = new Regex(@"(?<=\[" + i + ":).*?(?=\\])");
                    string sqlSentence = "";
                    if (r1.Match(sql).Value != "") {
                        sqlSentence = r1.Match(sql).Value;
                    }
                    if (sqlSentence != "")
                        InitCtrlData(combox, i, lp, sqlSentence, dsoFramerWordControl1, currRecord);


                } else if (gridView1.Columns[i].ColumnEdit is RepositoryItemCheckedComboBoxEdit) {
                    RepositoryItemCheckedComboBoxEdit combox = gridView1.Columns[i].ColumnEdit as RepositoryItemCheckedComboBoxEdit;
                    combox.Items.Clear();

                    Regex r1 = new Regex(@"(?<=\[" + i + ":).*?(?=\\])");
                    string sqlSentence = "";
                    if (r1.Match(sql).Value != "") {
                        sqlSentence = r1.Match(sql).Value;
                    }
                    if (sqlSentence != "")
                        InitCtrlData2(combox, i, lp, sqlSentence, dsoFramerWordControl1, currRecord);
                }
            }

        }
コード例 #22
0
ファイル: frmModleSubmit.cs プロジェクト: s7loves/mypowerscgl
 public void FillTime(ExcelAccess ea, LP_Temple lp,DateTime dt)
 {
     string[] arrCellPos = lp.CellPos.Split(pchar);
     arrCellPos = StringHelper.ReplaceEmpty(arrCellPos).Split(pchar);
     string[] extraWord = lp.ExtraWord.Split(pchar);         
     IList<string> strList=new List<string>();
     //if (arrCellPos.Length == 5)
     //{
     //    strList.Add(dt.Year.ToString()); strList.Add(dt.Month.ToString());
     //    strList.Add(dt.Day.ToString()); strList.Add(dt.Hour.ToString()); strList.Add(dt.Minute.ToString());
     //}
     //else if (arrCellPos.Length == 4)
     //{
     //    strList.Add(dt.Day.ToString()); strList.Add(dt.Hour.ToString()); strList.Add(dt.Minute.ToString());
     //}
     //else if (arrCellPos.Length == 3)
     //{
     //    // strList.Add(dt.Year.ToString()); strList.Add(dt.Month.ToString());
     //    //strList.Add(dt.Day.ToString()); strList.Add(dt.Hour.ToString()); strList.Add(dt.Minute.ToString());
     //    strList.Add(dt.Year.ToString());
     //    strList.Add(dt.Month.ToString());
     //    strList.Add(dt.Day.ToString());
     //}
     //else if (arrCellPos.Length == 2)
     //{
     //    strList.Add(dt.Hour.ToString());
     //    strList.Add(dt.Minute.ToString());
     //}
     //else if (arrCellPos.Length == 1)
     //{
     //    strList.Add(dt.ToString());
     //}
     switch (lp.WordCount)
     {
         case "yyyy-MM-dd":
             strList.Add(dt.Year.ToString());
             strList.Add(dt.Month.ToString());
             strList.Add(dt.Day.ToString());
             break;
         case "MM-dd日":
             strList.Add(dt.Month.ToString());
             strList.Add(dt.Day.ToString());
             break;
         case "yyyy-MM-dd HH:mm:ss":
             strList.Add(dt.Year.ToString());
             strList.Add(dt.Month.ToString());
             strList.Add(dt.Day.ToString());
             strList.Add(dt.Hour.ToString());
             strList.Add(dt.Second.ToString());
             break;
         case "HH:mm:ss":
             strList.Add(dt.Hour.ToString());
             strList.Add(dt.Minute.ToString());
             strList.Add(dt.Second.ToString());
             break;
         case "MM-dd日 HH:mm":
             strList.Add(dt.Month.ToString());
             strList.Add(dt.Day.ToString());
             strList.Add(dt.Hour.ToString());
             strList.Add(dt.Minute.ToString());
             break;
         case "dd日 HH:mm":
             strList.Add(dt.Day.ToString());
             strList.Add(dt.Hour.ToString());
             strList.Add(dt.Minute.ToString());
             break;
         case "HH:mm":
             strList.Add(dt.Hour.ToString());
             strList.Add(dt.Minute.ToString());
             break;
         default:
             strList.Add(dt.Year.ToString());
             strList.Add(dt.Month.ToString());
             strList.Add(dt.Day.ToString());
             strList.Add(dt.Hour.ToString());
             strList.Add(dt.Minute.ToString());
             break;
     }
    // int i = 0;
     for (int i = 0; i < strList.Count;i++ )
     {
         if (extraWord.Length>i)
         {
             ea.SetCellValue(strList[i] + extraWord[i], GetCellPos(arrCellPos[i])[0], GetCellPos(arrCellPos[i])[1]);
         }
         else
         {
             ea.SetCellValue(strList[i], GetCellPos(arrCellPos[i])[0], GetCellPos(arrCellPos[i])[1]);
         }
         
     }
     //foreach (string str in strList)
     //{
     //    ea.SetCellValue(str, GetCellPos(arrCellPos[i])[0], GetCellPos(arrCellPos[i])[1]);
     //    i++;
     //}
 }
コード例 #23
0
ファイル: frm20Template.cs プロジェクト: s7loves/mypowerscgl
 public void FillTable(ExcelAccess ea, LP_Temple lp, string[] content) {
     string[] arrCol = lp.CellPos.Split(pchar);
     arrCol = StringHelper.ReplaceEmpty(arrCol).Split(pchar);
     string[] arrtemp = lp.WordCount.Split(pchar);
     arrtemp = StringHelper.ReplaceEmpty(arrtemp).Split(pchar);
     string[] coltemp = lp.ColumnName.Split(pchar);
     arrtemp = StringHelper.ReplaceEmpty(arrtemp).Split(pchar);
     List<int> arrCellCount = String2Int(arrtemp);
     for (int i = 0; i < arrCol.Length; i++) {
         if (string.IsNullOrEmpty(arrCol[i])) {
             continue;
         }
         if (content.Length > i && content[i] != null)
             FillMutilRowsT(ea, lp, content[i], arrCellCount[i], arrCol[i], coltemp[i]);
     }
 }
コード例 #24
0
ファイル: frmModleSubmit.cs プロジェクト: s7loves/mypowerscgl
 public void FillMutilRowsT(ExcelAccess ea, LP_Temple lp, string str, int cellcount, string arrCellPos)
 {
     StringHelper help = new StringHelper();
     //str = help.GetPlitString(str, cellcount);
     string[] arrRst = str.Split(new string[] { "\r\n" },StringSplitOptions.None);
     for (int i=0; i < arrRst.Length; i++)
     {
         ea.SetCellValue(arrRst[i], GetCellPos(arrCellPos)[0] + i, GetCellPos(arrCellPos)[1]);
     }
 }
コード例 #25
0
ファイル: frm20Template.cs プロジェクト: s7loves/mypowerscgl
        public void FillTime(ExcelAccess ea, LP_Temple lp, DateTime dt) {
            string[] arrCellPos = lp.CellPos.Split(pchar);
            arrCellPos = StringHelper.ReplaceEmpty(arrCellPos).Split(pchar);
            string[] extraWord = lp.ExtraWord.Split(pchar);
            IList<string> strList = new List<string>();
            //if (arrCellPos.Length == 5)
            //{
            //    strList.Add(dt.Year.ToString()); strList.Add(dt.Month.ToString());
            //    strList.Add(dt.Day.ToString()); strList.Add(dt.Hour.ToString()); strList.Add(dt.Minute.ToString());
            //}
            //else if (arrCellPos.Length == 4)
            //{
            //    strList.Add(dt.Day.ToString()); strList.Add(dt.Hour.ToString()); strList.Add(dt.Minute.ToString());
            //}
            //else if (arrCellPos.Length == 3)
            //{
            //    // strList.Add(dt.Year.ToString()); strList.Add(dt.Month.ToString());
            //    //strList.Add(dt.Day.ToString()); strList.Add(dt.Hour.ToString()); strList.Add(dt.Minute.ToString());
            //    strList.Add(dt.Year.ToString());
            //    strList.Add(dt.Month.ToString());
            //    strList.Add(dt.Day.ToString());
            //}
            //else if (arrCellPos.Length == 2)
            //{
            //    strList.Add(dt.Hour.ToString());
            //    strList.Add(dt.Minute.ToString());
            //}
            //else if (arrCellPos.Length == 1)
            //{
            //    strList.Add(dt.ToString());
            //}
            switch (lp.WordCount) {
                case "yyyy-MM-dd":
                    strList.Add(dt.Year.ToString());
                    strList.Add(dt.Month.ToString());
                    strList.Add(dt.Day.ToString());
                    break;
                case "MM-dd日":
                    strList.Add(dt.Month.ToString());
                    strList.Add(dt.Day.ToString());
                    break;
                case "yyyy-MM-dd HH:mm:ss":
                    strList.Add(dt.Year.ToString());
                    strList.Add(dt.Month.ToString());
                    strList.Add(dt.Day.ToString());
                    strList.Add(dt.Hour.ToString());
                    strList.Add(dt.Second.ToString());
                    break;
                case "HH:mm:ss":
                    strList.Add(dt.Hour.ToString());
                    strList.Add(dt.Minute.ToString());
                    strList.Add(dt.Second.ToString());
                    break;
                case "MM-dd日 HH:mm":
                    strList.Add(dt.Month.ToString());
                    strList.Add(dt.Day.ToString());
                    strList.Add(dt.Hour.ToString());
                    strList.Add(dt.Minute.ToString());
                    break;
                case "dd日 HH:mm":
                    strList.Add(dt.Day.ToString());
                    strList.Add(dt.Hour.ToString());
                    strList.Add(dt.Minute.ToString());
                    break;
                case "HH:mm":
                    strList.Add(dt.Hour.ToString());
                    strList.Add(dt.Minute.ToString());
                    break;
                default:
                    strList.Add(dt.Year.ToString());
                    strList.Add(dt.Month.ToString());
                    strList.Add(dt.Day.ToString());
                    strList.Add(dt.Hour.ToString());
                    strList.Add(dt.Minute.ToString());
                    break;
            }
            // int i = 0;
            for (int i = 0; i < strList.Count; i++) {
                if (extraWord.Length > i) {
                    ea.SetCellValue("'" + strList[i] + extraWord[i], GetCellPos(arrCellPos[i])[0], GetCellPos(arrCellPos[i])[1]);
                    if (valuehs.ContainsKey(lp.LPID + "$" + arrCellPos[i])) {
                        WF_TableFieldValue tfv = valuehs[lp.LPID + "$" + arrCellPos[i]] as WF_TableFieldValue;
                        tfv.ControlValue = strList[i] + extraWord[i];
                        tfv.FieldId = lp.LPID;
                        tfv.FieldName = lp.CellName;
                        tfv.XExcelPos = GetCellPos(arrCellPos[i])[0];
                        tfv.YExcelPos = GetCellPos(arrCellPos[i])[1];
                        tfv.ExcelSheetName = activeSheetName;
                        tfv = valuehs[lp.LPID + "$" + arrCellPos[i] + "时间"] as WF_TableFieldValue;
                        if (tfv != null) {
                            tfv.ControlValue = dt.ToString();
                            tfv.FieldId = lp.LPID;
                            tfv.FieldName = lp.CellName + "完整时间";
                            tfv.XExcelPos = -1;
                            tfv.YExcelPos = -1;
                            tfv.ExcelSheetName = activeSheetName;
                        }
                    } else {
                        WF_TableFieldValue tfv = new WF_TableFieldValue();
                        tfv.ControlValue = strList[i] + extraWord[i];
                        tfv.FieldId = lp.LPID;
                        tfv.FieldName = lp.CellName;
                        tfv.XExcelPos = GetCellPos(arrCellPos[i])[0];
                        tfv.YExcelPos = GetCellPos(arrCellPos[i])[1];
                        tfv.ExcelSheetName = activeSheetName;
                        valuehs.Add(lp.LPID + "$" + arrCellPos[i], tfv);

                        tfv = new WF_TableFieldValue();
                        tfv.FieldId = lp.LPID;
                        tfv.ControlValue = dt.ToString();
                        tfv.FieldName = lp.CellName + "完整时间";
                        tfv.XExcelPos = -1;
                        tfv.YExcelPos = -1;
                        tfv.ExcelSheetName = activeSheetName;
                        valuehs.Add(lp.LPID + "$" + arrCellPos[i] + "完整时间", tfv);
                    }
                } else {
                    ea.SetCellValue("'" + strList[i], GetCellPos(arrCellPos[i])[0], GetCellPos(arrCellPos[i])[1]);
                    if (valuehs.ContainsKey(lp.LPID + "$" + arrCellPos[i])) {
                        WF_TableFieldValue tfv = valuehs[lp.LPID + "$" + arrCellPos[i]] as WF_TableFieldValue;
                        tfv.ControlValue = strList[i];
                        tfv.FieldId = lp.LPID;
                        tfv.FieldName = lp.CellName;
                        tfv.XExcelPos = GetCellPos(arrCellPos[i])[0];
                        tfv.YExcelPos = GetCellPos(arrCellPos[i])[1];
                        tfv.ExcelSheetName = activeSheetName;

                        tfv = valuehs[lp.LPID + "$" + arrCellPos[0] + "时间"] as WF_TableFieldValue;
                        if (tfv != null) {
                            tfv.ControlValue = dt.ToString();
                            tfv.FieldId = lp.LPID;
                            tfv.FieldName = lp.CellName + "完整时间";
                            tfv.XExcelPos = -1;
                            tfv.YExcelPos = -1;
                            tfv.ExcelSheetName = activeSheetName;
                        }

                    } else {
                        WF_TableFieldValue tfv = new WF_TableFieldValue();
                        tfv.ControlValue = strList[i];
                        tfv.FieldId = lp.LPID;
                        tfv.FieldName = lp.CellName;
                        tfv.XExcelPos = GetCellPos(arrCellPos[i])[0];
                        tfv.YExcelPos = GetCellPos(arrCellPos[i])[1];
                        tfv.ExcelSheetName = activeSheetName;
                        valuehs.Add(lp.LPID + "$" + arrCellPos[i], tfv);

                        tfv = new WF_TableFieldValue();
                        tfv.FieldId = lp.LPID;
                        tfv.ControlValue = dt.ToString();
                        tfv.FieldName = lp.CellName + "完整时间";
                        tfv.XExcelPos = -1;
                        tfv.YExcelPos = -1;
                        tfv.ExcelSheetName = activeSheetName;
                        valuehs.Add(lp.LPID + "$" + arrCellPos[0] + "完整时间", tfv);
                    }
                }

            }
            //foreach (string str in strList)
            //{
            //    ea.SetCellValue(str, GetCellPos(arrCellPos[i])[0], GetCellPos(arrCellPos[i])[1]);
            //    i++;
            //}
        }
コード例 #26
0
 public void ExportExcelSubmit(ref LP_Temple parentTemple,  string orgid, bool isShow)
 {
     DSOFramerControl dsoFramerWordControl1 = new DSOFramerControl();
     string fname = Application.StartupPath + "\\00记录模板\\备品备件计划.xls";
     dsoFramerWordControl1.FileOpen(fname);
    
     if (parentTemple == null)
     {
         parentTemple = new LP_Temple();
         parentTemple.Status = "文档生成";
     }
     parentTemple.DocContent = dsoFramerWordControl1.FileDataGzip;
     dsoFramerWordControl1.FileSave();
     dsoFramerWordControl1.FileClose();
     dsoFramerWordControl1.FileDataGzip = parentTemple.DocContent;
     ExcelAccess ex = new ExcelAccess();
     Microsoft.Office.Interop.Excel.Workbook wb = dsoFramerWordControl1.AxFramerControl.ActiveDocument as Microsoft.Office.Interop.Excel.Workbook;
     ex.MyWorkBook = wb;
     ex.MyExcel = wb.Application;
     string filter = " where jhnf = '" + (DateTime.Now.Year + 1) + "'";
     if (orgid != "") filter += " and OrgCode='" + orgid + "'";
     if (isWorkflowCall)
     {
         filter = filter + " and (id not in (select ModleRecordID from WF_ModleRecordWorkTaskIns where WorkFlowId='"
             + WorkFlowData.Rows[0]["WorkFlowId"].ToString() + "') "
                 + " or id in  (select ModleRecordID from WF_ModleRecordWorkTaskIns where "
             + "    RecordID='" + currRecord.ID + "')) "
             ;
     }
     IList<PJ_bpbjjhb> datalist = Client.ClientHelper.PlatformSqlMap.GetListByWhere<PJ_bpbjjhb>(
          filter
           );
     ExportExcel(ex, datalist);
     if (parentTemple == null)
     {
         parentTemple = new LP_Temple();
         parentTemple.Status = "文档生成";
     }
     dsoFramerWordControl1.FileSave();
     parentTemple.DocContent = dsoFramerWordControl1.FileDataGzip;
     dsoFramerWordControl1.FileClose();
 }
コード例 #27
0
ファイル: frm20Template.cs プロジェクト: s7loves/mypowerscgl
        public void FillMutilRowsT(ExcelAccess ea, LP_Temple lp, string str, int cellcount, string arrCellPos, string coltemp) {
            StringHelper help = new StringHelper();
            //str = help.GetPlitString(str, cellcount);
            string[] arrRst = str.Split(new string[] { "\r\n" }, StringSplitOptions.None);
            if (lp.ExtraWord == "横向") {
                for (int i = 0; i < arrRst.Length; i++) {
                    ea.SetCellValue("'" + arrRst[i], GetCellPos(arrCellPos)[0], GetCellPos(arrCellPos)[1] + i);
                    if (valuehs.ContainsKey(lp.LPID + "$" + Convert.ToString(GetCellPos(arrCellPos)[0] + i) + "|" + GetCellPos(arrCellPos)[1])) {
                        WF_TableFieldValue tfv = valuehs[lp.LPID + "$" + Convert.ToString(GetCellPos(arrCellPos)[0] + i) + "|" + GetCellPos(arrCellPos)[1]] as WF_TableFieldValue;
                        tfv.ControlValue = arrRst[i];
                        tfv.FieldId = lp.LPID;
                        tfv.FieldName = lp.CellName + "-" + coltemp;
                        tfv.XExcelPos = GetCellPos(arrCellPos)[0];
                        tfv.YExcelPos = GetCellPos(arrCellPos)[1] + i;
                        tfv.ExcelSheetName = activeSheetName;

                    } else {
                        WF_TableFieldValue tfv = new WF_TableFieldValue();
                        tfv.ControlValue = arrRst[i];
                        tfv.FieldId = lp.LPID;
                        tfv.FieldName = lp.CellName + "-" + coltemp;
                        tfv.XExcelPos = GetCellPos(arrCellPos)[0];
                        tfv.YExcelPos = GetCellPos(arrCellPos)[1] + i;
                        tfv.ExcelSheetName = activeSheetName;
                        valuehs.Add(lp.LPID + "$" + Convert.ToString(GetCellPos(arrCellPos)[0] + i) + "|" + GetCellPos(arrCellPos)[1], tfv);
                    }
                }
            } else {
                for (int i = 0; i < arrRst.Length; i++) {

                    ea.SetCellValue("'" + arrRst[i], GetCellPos(arrCellPos)[0] + i, GetCellPos(arrCellPos)[1]);
                    if (valuehs.ContainsKey(lp.LPID + "$" + Convert.ToString(GetCellPos(arrCellPos)[0] + i) + "|" + GetCellPos(arrCellPos)[1])) {
                        WF_TableFieldValue tfv = valuehs[lp.LPID + "$" + Convert.ToString(GetCellPos(arrCellPos)[0] + i) + "|" + GetCellPos(arrCellPos)[1]] as WF_TableFieldValue;
                        tfv.ControlValue = arrRst[i];
                        tfv.FieldId = lp.LPID;
                        tfv.FieldName = lp.CellName + "-" + coltemp;
                        tfv.XExcelPos = GetCellPos(arrCellPos)[0] + i;
                        tfv.YExcelPos = GetCellPos(arrCellPos)[1];
                        tfv.ExcelSheetName = activeSheetName;

                    } else {
                        WF_TableFieldValue tfv = new WF_TableFieldValue();
                        tfv.ControlValue = arrRst[i];
                        tfv.FieldId = lp.LPID;
                        tfv.FieldName = lp.CellName + "-" + coltemp;
                        tfv.XExcelPos = GetCellPos(arrCellPos)[0] + i;
                        tfv.YExcelPos = GetCellPos(arrCellPos)[1];
                        tfv.ExcelSheetName = activeSheetName;
                        valuehs.Add(lp.LPID + "$" + Convert.ToString(GetCellPos(arrCellPos)[0] + i) + "|" + GetCellPos(arrCellPos)[1], tfv);
                    }
                }
            }
        }
コード例 #28
0
        public void ExportExcelSubmit(ref LP_Temple parentTemple,  string orgid, bool isShow)
        {
            DSOFramerControl dsoFramerWordControl1 = new DSOFramerControl();
            string fname = Application.StartupPath + "\\00记录模板\\线路设备责任区划分明白表.xls";
            dsoFramerWordControl1.FileOpen(fname);
            
        
            if (parentTemple == null)
            {
                parentTemple = new LP_Temple();
                parentTemple.Status = "文档生成";
            }
            parentTemple.DocContent = dsoFramerWordControl1.FileDataGzip;
            dsoFramerWordControl1.FileSave();
            dsoFramerWordControl1.FileClose();
            dsoFramerWordControl1.FileDataGzip = parentTemple.DocContent;
            ExcelAccess ex = new ExcelAccess();
            Microsoft.Office.Interop.Excel.Workbook wb = dsoFramerWordControl1.AxFramerControl.ActiveDocument as Microsoft.Office.Interop.Excel.Workbook;
            ex.MyWorkBook = wb;
            ex.MyExcel = wb.Application;
           string filter = "";
            int i = 0;


            string sdtrorg = " ";
            if (orgid != "")
            {

                sdtrorg += "  and OrgCode='" + orgid + "'";
            }
            IList mclist = ClientHelper.PlatformSqlMap.GetList("SelectOneStr", "select distinct zrr  from PJ_xlsbzrqhfmbb where  1=1 " + sdtrorg);
            List<WF_ModleRecordWorkTaskIns> mrwtlist = new List<WF_ModleRecordWorkTaskIns>();
            foreach (string mc in mclist)
            {
                filter = " where 1=1 and zrr='" + mc + "' ";
                if (orgid != "") filter = " and OrgCode='" + orgid + "'";
                if (isWorkflowCall)
                {
                    filter = filter + " and (id not in (select ModleRecordID from WF_ModleRecordWorkTaskIns where  WorkFlowInsId='"
                        + WorkFlowData.Rows[0]["WorkFlowInsId"].ToString() + "') "
                            + " or id in  (select ModleRecordID from WF_ModleRecordWorkTaskIns where "
                        + "    RecordID='" + currRecord.ID + "')) "
                        ;
                }

                IList<PJ_xlsbzrqhfmbb> datalist = Client.ClientHelper.PlatformSqlMap.GetListByWhere<PJ_xlsbzrqhfmbb>(
                     filter
                     );
                ExportExcel(ex, datalist,mc);
            }
            ex.DeleteSheet(1);
            if (parentTemple == null)
            {
                parentTemple = new LP_Temple();
                parentTemple.Status = "文档生成";
            }
            dsoFramerWordControl1.FileSave();
            parentTemple.DocContent = dsoFramerWordControl1.FileDataGzip;
            dsoFramerWordControl1.FileSave();
            dsoFramerWordControl1.FileClose();
        }
コード例 #29
0
ファイル: UCPJ_AQYXJLM.cs プロジェクト: s7loves/mypowerscgl
        /// <summary>
        /// 初始化数据
        /// </summary>
        public void InitData() {
            Temple = MainHelper.PlatformSqlMap.GetOne<LP_Temple>(" where ( ParentID not in (select LPID from LP_Temple where 1=1 and  CtrlSize!='目录') and  CtrlSize!='目录' ) and  CellName = '安全运行记录板'");
            string slqwhere = " ";
            if (Temple == null)
            {
                MsgBox.ShowWarningMessageBox("没有找到表单安全运行记录板!");
                return;
            }
            IList recordlist = Client.ClientHelper.PlatformSqlMap.GetList("SelectOneStr", " select distinct RecordId from WF_TableFieldValue where  UserControlId='" + Temple.LPID + "' and   WorkflowId='" + modleGuid + "' and WorkFlowInsId='" + parentObj.OrgName + "' ");
            
            IList<LP_Temple> templeList = MainHelper.PlatformSqlMap.GetList<LP_Temple>("SelectLP_TempleList",
               "where ParentID ='" + Temple.LPID + "' order by SortID");
            dt.Rows.Clear();

            for (int i = 0; i < recordlist.Count; )
            { 
                slqwhere = " where RecordId='"+recordlist[i]
                    + "' and  UserControlId='" + Temple.LPID 
                    + "' and   WorkflowId='"  + modleGuid
                    + "' and   fieldname='" + "问题" 
                    + "' and WorkFlowInsId='" + parentObj.OrgName + "' ";
                WF_TableFieldValue value = MainHelper.PlatformSqlMap.GetOne<WF_TableFieldValue>(slqwhere);
                DataRow dr = dt.NewRow();
                dr["RecordId"] = recordlist[i];

                if(value!=null)
                {
                    dr["Question"] = value.ControlValue;
                }
                  slqwhere = " where RecordId='"+recordlist[i]
                    + "' and  UserControlId='" + Temple.LPID 
                    + "' and   WorkflowId='"  + modleGuid
                    + "' and   fieldname='" + "答案" 
                    + "' and WorkFlowInsId='" + parentObj.OrgName + "' ";
                value = MainHelper.PlatformSqlMap.GetOne<WF_TableFieldValue>(slqwhere);
               
                if(value!=null)
                {
                    dr["Answer"] = value.ControlValue;
                } 
                slqwhere = " where RecordId='" + recordlist[i]
                  + "' and  UserControlId='" + Temple.LPID
                  + "' and   WorkflowId='" + modleGuid
                  + "' and   fieldname='" + "人身安全生产天数"
                  + "' and WorkFlowInsId='" + parentObj.OrgName + "' ";
                value = MainHelper.PlatformSqlMap.GetOne<WF_TableFieldValue>(slqwhere);

                if (value != null)
                {
                    dr["Rsaqts"] = value.ControlValue;
                }
               

                slqwhere = " where RecordId='" + recordlist[i]
                  + "' and  UserControlId='" + Temple.LPID
                  + "' and   WorkflowId='" + modleGuid
                  + "' and   fieldname='" + "设备安全生产天数"
                  + "' and WorkFlowInsId='" + parentObj.OrgName + "' ";
                value = MainHelper.PlatformSqlMap.GetOne<WF_TableFieldValue>(slqwhere);

                if (value != null)
                {
                    dr["Sbaqts"] = value.ControlValue;
                }
                dt.Rows.Add(dr);
                i++;
            }
            //treeViewOperator.RefreshData(" where OrgCode='" + parentID + "' order by linetype,linecode");
            //treeViewOperator.RefreshData(slqwhere);
            gridControl1.DataSource = dt;
        }
コード例 #30
0
ファイル: frmTemplate.cs プロジェクト: s7loves/mypowerscgl
        private void LPFrm_Load(object sender, EventArgs e)
        {
            if (tempCtrlList==null)
            {
                tempCtrlList = new List<Control>();
            }
            this.Text = "低压线路完好率及台区网络图";
            //InitializeComponent();
            if (valuehs == null)
                valuehs = new Hashtable();
            Excel.Workbook wb;
            Excel.Worksheet sheet;
            ExcelAccess ea = new ExcelAccess();
            parentTemple = MainHelper.PlatformSqlMap.GetOne<LP_Temple>(" where ( ParentID not in (select LPID from LP_Temple where 1=1 and  CtrlSize!='目录') and  CtrlSize!='目录' ) and  CellName like '%低压线路完好率及台区网络图%'");
            currRecord = rowData;

            if (currRecord.BigData == null || currRecord.BigData.Length == 0)
            {

                this.dsoFramerWordControl1.FileDataGzip = parentTemple.DocContent;
            }
            else
            {

                this.dsoFramerWordControl1.FileDataGzip = currRecord.BigData;
            }
                InitIndex();
                InitContorl();
                InitData();
                if (status == "edit")
                {
                    IList<WF_TableFieldValue> tfvli = MainHelper.PlatformSqlMap.GetList<WF_TableFieldValue>("SelectWF_TableFieldValueList",
                     " where RecordId='" + currRecord.ID + "' and UserControlId='" + parentTemple.LPID + "' and   WorkflowId='" + currRecord.tqCode + "' and WorkFlowInsId='" + currRecord.tqName + "' ");
                   
                    Excel.Worksheet xx;
                    wb = dsoFramerWordControl1.AxFramerControl.ActiveDocument as Excel.Workbook;
                    ea.MyWorkBook = wb;
                    ea.MyExcel = wb.Application;
                    string activeSheetName = "";
                    xx = wb.Application.Sheets[1] as Excel.Worksheet;
                    int i = 0;
                    
                    for (i = 0; i < tfvli.Count; i++)
                    {
                      
                        Control ctl= FindCtrl(tfvli[i].FieldId);
                        if (ctl != null)
                        {
                            ctl.Text = tfvli[i].ControlValue;
                        }
                       

                    }
                    dsoFramerWordControl1.FileSave();
                }

              
        }