示例#1
0
        ////e插入数据
        //public bool UpdateExT(RequesEX[] ext, ref string errmsg)
        //{
        //    bool result = true;
        //    string createcode = "";
        //    BLLSequence mybll = new BLLSequence();
        //    result = mybll.GetExT(ref createcode, ref errmsg);
        //    if (result)
        //    {
        //        DALUserManage mydal = new DALUserManage();
        //        result = mydal.UpdateExT( ext,createcode, ref errmsg);
        //    }
        //    return result;
        //}


        //e插入数据表头
        public bool UpdateEx(Reques1[][] extt, ref string errmsg)
        {
            bool result = true;

            for (int i = 0; i < extt.Length; i++)
            {
                for (int j = 0; j < extt[i].Length; j++)
                {
                    string pagecode = extt[i][j].pagecode;
                    string hname    = extt[i][j].Hname;
                    string breadth  = extt[i][j].breadth;
                    int    nowrow   = extt[i][j].nowrow;
                    int    nowline  = extt[i][j].nowline;
                    string takerow  = extt[i][j].takerow;
                    string takeline = extt[i][j].takeline;
                    string usercode = extt[i][j].usercode;

                    string      Hcode = "";
                    BLLSequence mybll = new BLLSequence();
                    result = mybll.GetEx(ref Hcode, ref errmsg);
                    if (result)
                    {
                        DALUserManage mydal = new DALUserManage();
                        result = mydal.UpdateEx(Hcode, pagecode, hname, breadth, nowrow, nowline, takerow, takeline, usercode, ref errmsg);
                    }
                }
            }
            return(result);
        }
示例#2
0
 /// <summary>
 /// 筛选车牌
 /// </summary>
 /// <param name="pagecode">角色代码</param>
 /// <param name="rolepage">授权页面集合</param>
 /// <param name="usercode">操作用户代码</param>
 /// <param name="errmsg">出错时返回的错误提示信息</param>
 /// <returns>是否成功执行</returns>
 public bool Application(string applycode, string platenumber, string remark, string susercode, ref string errmsg)
 {
     string playcode = "";
     bool result = true;
     BLLSequence myseq = new BLLSequence();
     result = myseq.Application(ref playcode, ref errmsg);
     if (result)
     {
         DALProposer mydal = new DALProposer();
         result = mydal.Application(applycode, playcode, platenumber, remark, susercode, ref errmsg);
     }
     return result;
 }
示例#3
0
 /// <summary>
 /// 提交派车用申请
 /// </summary>
 /// <param name="pagecode">角色代码</param>
 /// <param name="rolepage">授权页面集合</param>
 /// <param name="usercode">操作用户代码</param>
 /// <param name="errmsg">出错时返回的错误提示信息</param>
 /// <returns>是否成功执行</returns>
 public bool SendCar(string applyname, string accent, string department, string proposernomber, string endsite, string purpose, string servicetime, string usercode, ref string errmsg)
 {
     string applycode = "";
     bool result = true;
     BLLSequence myseq = new BLLSequence();
     result = myseq.ApplyD(ref applycode, ref errmsg);
     if (result)
     {
         DALProposer mydal = new DALProposer();
         result = mydal.SendCar(applycode, applyname, department, accent, proposernomber, endsite, purpose, servicetime, usercode, ref errmsg);
     }
     return result;
 }
示例#4
0
        /// <summary>
        /// 添加微信端页面信息
        /// </summary>

        /// <returns>是否成功执行</returns>
        public bool addPage(string pagename, string usercode, 审核用户[] ad, ref string errmsg)
        {
            bool        result   = true;
            string      pagecode = "";
            BLLSequence myseq    = new BLLSequence();

            result = myseq.addPage(ref pagecode, ref errmsg);
            if (result)
            {
                DALUserManage mydal = new DALUserManage();
                result = mydal.addPage(pagecode, pagename, usercode, ad, ref errmsg);
            }
            return(result);
        }
        /// <summary>
        /// 更新添加表头
        /// </summary>
        /// <param name="pagecode"></param>
        /// <param name="hcode"></param>
        /// <param name="hname"></param>
        /// <param name="breadth"></param>
        /// <param name="nowrow"></param>
        /// <param name="nowline"></param>
        /// <param name="takerow"></param>
        /// <param name="takeline"></param>
        /// <param name="errmsg"></param>
        /// <returns></returns>
        public bool updataAddExcleHeader(string pagecode, TableHeaders[][] tableHeaders, ref string errmsg)
        {
            bool result = true;

            List <Excel信息> list      = new List <Excel信息>();
            List <Excel信息> new_list  = new List <Excel信息>();
            List <Excel信息> merge     = new List <Excel信息>();
            List <Excel信息> effective = new List <Excel信息>();

            for (int i = 0; i < tableHeaders.Length; i++)
            {
                for (int j = 0; j < tableHeaders[i].Length; j++)
                {
                    Excel信息 info = new Excel信息();
                    info.第几行        = i;
                    info.第几列        = j;
                    info.称          = tableHeaders[i][j].hname;
                    info.占几行        = Convert.ToInt32(tableHeaders[i][j].takerow);
                    info.占几列        = Convert.ToInt32(tableHeaders[i][j].takeline);
                    info.selecttype = tableHeaders[i][j].selecttype;
                    info.optiontype = tableHeaders[i][j].optiontype;
                    list.Add(info);
                }
            }

            //临时性的方法
            for (int i = 0; i < list.Count; i++)
            {
                for (int j = 0; j < list[i].占几行; j++)
                {
                    for (int k = 0; k < list[i].占几列; k++)
                    {
                        Excel信息 newinfo = new Excel信息();
                        if (list[i].第几行 == 0)
                        {
                            int    当前行    = j;
                            int    当前列    = k + list[i].第几列;
                            string 称      = list[i].称;
                            bool   是否比较完成 = false;
                            while (!是否比较完成)
                            {
                                for (int q = 0; q < new_list.Count; q++)
                                {
                                    if (new_list[q].第几行 == 当前行 && 当前列 == new_list[q].第几列)
                                    {
                                        当前列 += 1;
                                        break;
                                    }
                                    if (q == new_list.Count - 1)
                                    {
                                        是否比较完成 = true;
                                    }
                                }

                                if (new_list.Count == 0)
                                {
                                    是否比较完成 = true;
                                }
                            }
                            newinfo.第几行 = 当前行;
                            if (当前行 > 0)
                            {
                                for (int kk = 0; kk < new_list.Count; kk++)
                                {
                                    if (new_list[kk].称 == 称)
                                    {
                                        newinfo.第几列 = new_list[kk].第几列;
                                    }
                                }
                            }
                            else
                            {
                                newinfo.第几列 = 当前列;
                            }
                            newinfo.占几行        = 1;
                            newinfo.占几列        = 1;
                            newinfo.称          = 称;
                            newinfo.optiontype = list[i].optiontype;
                            newinfo.selecttype = list[i].selecttype;
                            new_list.Add(newinfo);
                        }
                        else
                        {
                            int    目前总行数  = 0;
                            int    目前第几行  = list[i].第几行; //1
                            int    目前比较列  = list[i].第几列; //0
                            string 称      = list[i].称;
                            bool   是否比较完成 = false;
                            while (!是否比较完成)
                            {
                                for (int a = 0; a < 目前第几行 - 1; a++)
                                {
                                    if (list[a].第几行 == a && list[a].第几列 == 目前比较列)
                                    {
                                        目前总行数 += list[a].占几行;
                                    }
                                }

                                for (int n = 0; n < new_list.Count; n++)
                                {
                                    if (目前第几行 == new_list[n].第几行 && 目前比较列 == new_list[n].第几列)
                                    {
                                        目前比较列 += 1;
                                    }
                                }
                                if (目前总行数 > 目前第几行)
                                {
                                    目前比较列 += 1;
                                    目前总行数  = 0;
                                }
                                else
                                {
                                    是否比较完成 = true;
                                }
                            }
                            newinfo.第几行        = 目前第几行;
                            newinfo.第几列        = 目前比较列;
                            newinfo.称          = 称;
                            newinfo.占几行        = 1;
                            newinfo.占几行        = 1;
                            newinfo.optiontype = list[i].optiontype;
                            newinfo.selecttype = list[i].selecttype;
                            new_list.Add(newinfo);
                        }
                    }
                }
            }


            List <Excel信息> 排序后 = new List <Excel信息>();

            排序后 = new_list.OrderByDescending(a => a.第几行).ThenBy(a => a.第几列).ToList();

            List <Excel信息> 效表头 = new List <Excel信息>();
            int            一列  = 0;

            for (int n = 0; n < 排序后.Count; n++)
            {
                if (一列 == 排序后[n].第几列)
                {
                    一列 += 1;
                    效表头.Add(排序后[n]);
                }
            }

            if (效表头.Count > 0)
            {
                Excel信息 newinfo = new Excel信息();
                newinfo.称          = 效表头[0].称;
                newinfo.占几列        = 1;
                newinfo.optiontype = 效表头[0].optiontype;
                newinfo.selecttype = 效表头[0].selecttype;
                effective.Add(newinfo);

                for (int n = 1; n < 效表头.Count; n++)
                {
                    Excel信息 newinfo1 = new Excel信息();
                    bool    是否只更新    = false;
                    for (int h = 0; h < effective.Count; h++)
                    {
                        if (效表头[n].称 == effective[h].称)
                        {
                            effective[h].占几列 += 1;
                            是否只更新             = true;
                        }
                    }
                    if (!是否只更新)
                    {
                        newinfo1.称          = 效表头[n].称;
                        newinfo1.占几列        = 1;
                        newinfo1.optiontype = 效表头[0].optiontype;
                        newinfo1.selecttype = 效表头[0].selecttype;
                        effective.Add(newinfo1);
                    }
                }
            }



            for (int i = 0; i < tableHeaders.Length; i++)
            {
                for (int j = 0; j < tableHeaders[i].Length; j++)
                {
                    string hcode = "";
                    if (string.IsNullOrEmpty(tableHeaders[i][j].hcode))
                    {
                        BLLSequence myseq = new BLLSequence();
                        result = myseq.GetExcelCode(ref hcode, ref errmsg);
                    }


                    if (result)
                    {
                        DALUniversalExcel mydal = new DALUniversalExcel();
                        result = mydal.updataAddExcleHeader(pagecode, hcode, tableHeaders[i][j].hcode, tableHeaders[i][j].hname, tableHeaders[i][j].breadth, tableHeaders[i][j].nowrow, tableHeaders[i][j].nowline, tableHeaders[i][j].takerow, tableHeaders[i][j].takeline, tableHeaders[i][j].selecttype, tableHeaders[i][j].optiontype, ref errmsg);
                        if (!result)
                        {
                            result = false;
                            break;
                        }
                    }

                    for (int h = 0; h < effective.Count; h++)
                    {
                        if (tableHeaders[i][j].hname == effective[h].称)
                        {
                            DALUniversalExcel mydal = new DALUniversalExcel();
                            result = mydal.updataAddEffectiveExcleHeader(pagecode, hcode, tableHeaders[i][j].hcode, effective[h].称, effective[h].占几列, effective[h].selecttype, effective[h].optiontype, ref errmsg);
                        }
                    }
                }
            }

            return(result);
        }
        /// <summary>
        /// 添加表头
        /// </summary>
        /// <param name="pagecode"></param>
        /// <param name="hcode"></param>
        /// <param name="hname"></param>
        /// <param name="breadth"></param>
        /// <param name="nowrow"></param>
        /// <param name="nowline"></param>
        /// <param name="takerow"></param>
        /// <param name="takeline"></param>
        /// <param name="errmsg"></param>
        /// <returns></returns>
        public bool AddExcleHeader(string pagecode, TableHeaders[][] tableHeaders, ref string errmsg)
        {
            bool result = true;

            List <Excel信息> list      = new List <Excel信息>();
            List <Excel信息> new_list  = new List <Excel信息>();
            List <Excel信息> merge     = new List <Excel信息>();
            List <Excel信息> effective = new List <Excel信息>();

            for (int i = 0; i < tableHeaders.Length; i++)
            {
                for (int j = 0; j < tableHeaders[i].Length; j++)
                {
                    Excel信息 info = new Excel信息();
                    info.第几行        = i;
                    info.第几列        = j;
                    info.称          = tableHeaders[i][j].hname;
                    info.占几行        = Convert.ToInt32(tableHeaders[i][j].takerow);
                    info.占几列        = Convert.ToInt32(tableHeaders[i][j].takeline);
                    info.selecttype = tableHeaders[i][j].selecttype;
                    info.optiontype = tableHeaders[i][j].optiontype;
                    list.Add(info);
                }
            }

            //临时性的方法
            for (int i = 0; i < list.Count; i++)
            {
                for (int j = 0; j < list[i].占几行; j++)
                {
                    for (int k = 0; k < list[i].占几列; k++)
                    {
                        Excel信息 newinfo = new Excel信息();
                        if (list[i].第几行 == 0)
                        {
                            int    当前行    = j;
                            int    当前列    = k + list[i].第几列;
                            string 称      = list[i].称;
                            bool   是否比较完成 = false;
                            while (!是否比较完成)
                            {
                                for (int q = 0; q < new_list.Count; q++)
                                {
                                    if (new_list[q].第几行 == 当前行 && 当前列 == new_list[q].第几列)
                                    {
                                        当前列 += 1;
                                        break;
                                    }
                                    if (q == new_list.Count - 1)
                                    {
                                        是否比较完成 = true;
                                    }
                                }

                                if (new_list.Count == 0)
                                {
                                    是否比较完成 = true;
                                }
                            }
                            newinfo.第几行 = 当前行;
                            if (当前行 > 0)
                            {
                                for (int kk = 0; kk < new_list.Count; kk++)
                                {
                                    if (new_list[kk].称 == 称)
                                    {
                                        newinfo.第几列 = new_list[kk].第几列;
                                    }
                                }
                            }
                            else
                            {
                                newinfo.第几列 = 当前列;
                            }
                            newinfo.占几行        = 1;
                            newinfo.占几列        = 1;
                            newinfo.称          = 称;
                            newinfo.optiontype = list[i].optiontype;
                            newinfo.selecttype = list[i].selecttype;
                            new_list.Add(newinfo);
                        }
                        else
                        {
                            int    目前总行数  = 0;
                            int    目前第几行  = list[i].第几行; //1
                            int    目前比较列  = list[i].第几列; //0
                            string 称      = list[i].称;
                            bool   是否比较完成 = false;
                            while (!是否比较完成)
                            {
                                for (int a = 0; a < 目前第几行 - 1; a++)
                                {
                                    if (list[a].第几行 == a && list[a].第几列 == 目前比较列)
                                    {
                                        目前总行数 += list[a].占几行;
                                    }
                                }

                                for (int n = 0; n < new_list.Count; n++)
                                {
                                    if (目前第几行 == new_list[n].第几行 && 目前比较列 == new_list[n].第几列)
                                    {
                                        目前比较列 += 1;
                                    }
                                }
                                if (目前总行数 > 目前第几行)
                                {
                                    目前比较列 += 1;
                                    目前总行数  = 0;
                                }
                                else
                                {
                                    是否比较完成 = true;
                                }
                            }
                            newinfo.第几行        = 目前第几行;
                            newinfo.第几列        = 目前比较列;
                            newinfo.称          = 称;
                            newinfo.占几行        = 1;
                            newinfo.占几行        = 1;
                            newinfo.optiontype = list[i].optiontype;
                            newinfo.selecttype = list[i].selecttype;
                            new_list.Add(newinfo);
                        }
                    }
                }
            }


            List <Excel信息> 排序后 = new List <Excel信息>();

            排序后 = new_list.OrderByDescending(a => a.第几行).ThenBy(a => a.第几列).ToList();

            List <Excel信息> 效表头 = new List <Excel信息>();
            int            一列  = 0;

            for (int n = 0; n < 排序后.Count; n++)
            {
                if (一列 == 排序后[n].第几列)
                {
                    一列 += 1;
                    效表头.Add(排序后[n]);
                }
            }

            if (效表头.Count > 0)
            {
                Excel信息 newinfo = new Excel信息();
                newinfo.称          = 效表头[0].称;
                newinfo.占几列        = 1;
                newinfo.optiontype = 效表头[0].optiontype;
                newinfo.selecttype = 效表头[0].selecttype;
                effective.Add(newinfo);

                for (int n = 1; n < 效表头.Count; n++)
                {
                    Excel信息 newinfo1 = new Excel信息();
                    bool    是否只更新    = false;
                    for (int h = 0; h < effective.Count; h++)
                    {
                        if (效表头[n].称 == effective[h].称)
                        {
                            effective[h].占几列 += 1;
                            是否只更新             = true;
                        }
                    }
                    if (!是否只更新)
                    {
                        newinfo1.称          = 效表头[n].称;
                        newinfo1.占几列        = 1;
                        newinfo1.optiontype = 效表头[0].optiontype;
                        newinfo1.selecttype = 效表头[0].selecttype;
                        effective.Add(newinfo1);
                    }
                }
            }



            for (int i = 0; i < tableHeaders.Length; i++)
            {
                for (int j = 0; j < tableHeaders[i].Length; j++)
                {
                    string      hcode = "";
                    BLLSequence myseq = new BLLSequence();
                    result = myseq.GetExcelCode(ref hcode, ref errmsg);
                    if (result)
                    {
                        DALUniversalExcel mydal = new DALUniversalExcel();
                        result = mydal.AddExcleHeader(pagecode, hcode, tableHeaders[i][j].hname, tableHeaders[i][j].breadth, tableHeaders[i][j].nowrow, tableHeaders[i][j].nowline, tableHeaders[i][j].takerow, tableHeaders[i][j].takeline, tableHeaders[i][j].selecttype, tableHeaders[i][j].optiontype, ref errmsg);
                        if (!result)
                        {
                            result = false;
                            break;
                        }
                    }

                    for (int h = 0; h < effective.Count; h++)
                    {
                        if (tableHeaders[i][j].hname == effective[h].称)
                        {
                            DALUniversalExcel mydal = new DALUniversalExcel();
                            result = mydal.AddEffectiveExcleHeader(pagecode, hcode, effective[h].称, effective[h].占几列, effective[h].selecttype, effective[h].optiontype, ref errmsg);
                        }
                    }
                }
            }



            //for (int n = 0; n < 排序后.Count; n++)
            //{

            //    bool 是否只更新 = false;
            //    for (int h = 0; h < merge.Count; h++)
            //    {
            //        if (排序后[n].第几列 == merge[h].第几列)
            //        {
            //            if (排序后[n].第几行 > merge[h].第几行)
            //            {
            //                merge[h].第几行 = 排序后[n].第几行;
            //                merge[h].名称 = 排序后[n].名称;

            //                是否只更新 = true;
            //            }

            //        }
            //    }
            //    if (!是否只更新)
            //    {
            //        Excel信息 newinfo = new Excel信息();
            //        newinfo.第几行 = 排序后[n].第几行;
            //        newinfo.第几列 = 排序后[n].第几列;
            //        newinfo.名称 = 排序后[n].名称;
            //        newinfo.占几列 = 排序后[n].占几列;
            //        merge.Add(newinfo);
            //    }
            //}


            //for (int n = 0; n < new_list.Count; n++)
            //{
            //    Excel信息 newinfo = new Excel信息();
            //    bool 是否只更新 = false;
            //    for (int h = 0; h < merge.Count; h++)
            //    {
            //        if (new_list[n].第几列 == merge[h].第几列)
            //        {
            //            if (new_list[n].第几行 > merge[h].第几行)
            //            {
            //                merge[h].第几行 = new_list[n].第几行;
            //                merge[h].名称 = new_list[n].名称;

            //                是否只更新 = true;
            //            }

            //        }
            //    }
            //    if (!是否只更新)
            //    {
            //        newinfo.第几行 = new_list[n].第几行;
            //        newinfo.第几列 = new_list[n].第几列;
            //        newinfo.名称 = new_list[n].名称;
            //        newinfo.占几列 = new_list[n].占几列;

            //    }
            //}



            //List<临时的类> testList = new List<临时的类>();
            //List<临时的类> testList1 = new List<临时的类>();
            //List<临时的类> testList2 = new List<临时的类>();
            //List<临时的类> testList3 = new List<临时的类>();
            //for (int i = 0; i < tableHeaders.Length; i++)
            //{
            //    for (int j = 0; j < tableHeaders[i].Length; j++)
            //    {
            //        for (int a = 0; a < ParseInteger.ParseInt(tableHeaders[i][j].takerow); a++)
            //        { //a=0 1
            //            for (int b = 0; b < ParseInteger.ParseInt(tableHeaders[i][j].takerow); b++)//b=1 1
            //            {
            //                int 行 = i + a; // 0 1
            //                int 列 = j + b; // 0 1

            //                for (int k = 0; k < testList.Count; k++)
            //                {
            //                    if (testList[k].nowline == 行 && testList[k].nowline == 列)
            //                    {
            //                        列 = 列 + 1;
            //                        临时的类 data = new 临时的类();
            //                        data.hname = tableHeaders[i][j].hname;
            //                        data.nowrow = 行;
            //                        data.nowline = 列;
            //                        data.takerow = tableHeaders[i][j].takerow;
            //                        data.takeline = tableHeaders[i][j].takeline;
            //                        testList.Add(data);
            //                    }
            //                }
            //            }
            //        }
            //    }
            //}

            //for (int y = 0; y < testList.Count; y++)
            //{
            //    bool updata = true;
            //    for (int n = 0; n < testList1.Count; n++)
            //    {
            //        if (testList1[n].nowline == testList[y].nowline)
            //        {
            //            if (testList1[n].nowrow < testList[y].nowrow)
            //            {
            //                testList1[n].nowrow = testList[y].nowrow;
            //                testList1[n].nowline = testList[y].nowline;
            //                testList1[n].hname = testList[y].hname;
            //                updata = false;
            //            }
            //        }

            //        if (updata)
            //        {
            //            testList1.Add(testList[y]);
            //        }
            //    }
            //}

            //for (int y = 0; y < testList1.Count; y++)
            //{
            //    bool updata = true;
            //    for (int n = 0; n < testList2.Count; n++)
            //    {
            //        if (testList1[n].nowline == testList1[y].nowline)
            //        {
            //            if (testList2[n].hname == testList1[y].hname)
            //            {
            //                testList2[n].nowline += 1;
            //                updata = false;
            //            }
            //        }

            //        if (updata)
            //        {
            //            testList2.Add(testList1[y]);
            //        }
            //    }
            //}

            return(result);
        }