////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);
}
/// <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;
}
/// <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;
}
/// <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);
}