void btn_Submit_Click(object sender, EventArgs e) {
//Excel.Workbook wb;
//Excel.Worksheet sheet;
dsoFramerWordControl1.FileSave();
//currRecord.BigData = this.dsoFramerWordControl1.FileDataGzip;
//wb = dsoFramerWordControl1.AxFramerControl.ActiveDocument as Excel.Workbook;
//if (activeSheetName != "")
//{
// sheet = wb.Application.Sheets[activeSheetName] as Excel.Worksheet;
//}
//else
//{
// sheet = wb.Application.Sheets[1] as Excel.Worksheet;
//}
//activeSheetIndex = sheet.Index;
//for (int i = 1; i <= wb.Application.Sheets.Count; i++)
//{
// if (i != activeSheetIndex)
// {
// Excel.Worksheet tmpSheet = (Excel.Worksheet)wb.Application.Sheets.get_Item(i);
// try
// {
// if (tmpSheet != null) tmpSheet.Visible = Excel.XlSheetVisibility.xlSheetVisible ;
// }
// catch { }
// }
//}
//unLockExcel(wb,sheet);
//for (int i = 1; sheet.Protection.AllowEditRanges.Count > 0; )
//{
// Excel.AllowEditRange editRange = sheet.Protection.AllowEditRanges.get_Item(i);
// editRange.Delete();
//}
//LockExcel(wb, sheet);
byte[] bt = new byte[0];
string strmes = "";
WF_WorkTaskCommands wt;
WF_TableFieldValue wfv = null;
LP_Temple lp = MainHelper.PlatformSqlMap.GetOne<LP_Temple>("where ParentID='" + parentTemple.LPID + "' and CellName like '%说明%'");
Control ctl = FindCtrl(lp.LPID);
if (ctl != null) {
currRecord.Remark = ctl.Text;
}
//rowData = null;
ArrayList akeys = new ArrayList(valuehs.Keys);
List<object> list = new List<object>();
for (int i = 0; i < akeys.Count; i++) {
wfv = valuehs[akeys[i]] as 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;
Thread.Sleep(new TimeSpan(100000));//0.1毫秒
list.Add(wfv);
for (int j = 0; j < templeList.Count; j++) {
if (templeList[j].LPID == wfv.FieldId) {
templeList.RemoveAt(j);
break;
}
}
}
Control ct = null;
for (int i = 0; i < templeList.Count; i++) {
wfv = new WF_TableFieldValue();
wfv.ExcelSheetName = templeList[i].KindTable;
if (templeList[i].CellPos != "") {
wfv.XExcelPos = GetCellPos(templeList[i].CellPos)[0];
wfv.YExcelPos = GetCellPos(templeList[i].CellPos)[1];
} else {
wfv.XExcelPos = -1;
wfv.YExcelPos = -1;
}
wfv.FieldId = templeList[i].LPID;
wfv.FieldName = templeList[i].CellName;
ct = FindCtrl(templeList[i].LPID);
if (ct != null)
wfv.ControlValue = ct.Text;
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;
Thread.Sleep(new TimeSpan(100000));//0.1毫秒
list.Add(wfv);
}
MainHelper.PlatformSqlMap.DeleteByWhere<WF_TableFieldValue>(" where RecordId ='" + currRecord.ID + "' and WorkTaskInsId='20低压设备完好率及台区网络图' ");
lp = MainHelper.PlatformSqlMap.GetOne<LP_Temple>(" where ParentID='" + parentTemple.LPID + "' and SortID=1");
//if (lp != null)
//{
// if (wfv == null)
// {
// wfv = new WF_TableFieldValue();
// wfv.ID = wfv.CreateID();
// wfv.RecordId = currRecord.ID;
// wfv.WorkFlowId = WorkFlowData.Rows[0]["WorkFlowId"].ToString();
// wfv.WorkFlowInsId = WorkFlowData.Rows[0]["WorkFlowInsId"].ToString();
// wfv.WorkTaskId = WorkFlowData.Rows[0]["WorkTaskId"].ToString();
// wfv.WorkTaskInsId = WorkFlowData.Rows[0]["WorkTaskInsId"].ToString();
// 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.ExcelSheetName = activeSheetName;
// }
// 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 (wfv == null)
// {
// wfv = new WF_TableFieldValue();
// wfv.ID = wfv.CreateID();
// wfv.RecordId = currRecord.ID;
// wfv.WorkFlowId = WorkFlowData.Rows[0]["WorkFlowId"].ToString();
// wfv.WorkFlowInsId = WorkFlowData.Rows[0]["WorkFlowInsId"].ToString();
// wfv.WorkTaskId = WorkFlowData.Rows[0]["WorkTaskId"].ToString();
// wfv.WorkTaskInsId = WorkFlowData.Rows[0]["WorkTaskInsId"].ToString();
// 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.ExcelSheetName = activeSheetName;
// wfv.Bigdata = currRecord.BigData;
// MainHelper.PlatformSqlMap.Create<WF_TableFieldValue>(wfv);
// }
// else
// {
// wfv.Bigdata = currRecord.BigData;
// MainHelper.PlatformSqlMap.Update<WF_TableFieldValue>(wfv);
// }
//}
dsoFramerWordControl1.FileSave();
currRecord.BigData = dsoFramerWordControl1.FileDataGzip;
if (currRecord.ParentID == "") {
currRecord.ParentID = currRecord.tqCode.Substring(0, 3);
}
if (currRecord.OrgName == "") {
mOrg org = MainHelper.PlatformSqlMap.GetOne<mOrg>("where orgcode='" + currRecord.ParentID + "'");
if (org != null) {
currRecord.OrgName = org.OrgName;
currRecord.OrgCode = org.OrgCode;
}
}
switch (status) {
case "add":
if (list.Count > 0) {
foreach (WF_TableFieldValue wfv2 in list) {
if (wfv2.FieldId == lp.LPID) {
wfv2.Bigdata = currRecord.BigData;
break;
}
}
Client.ClientHelper.PlatformSqlMap.ExecuteTransationUpdate(list, null, null);
}
if (currRecord.BigData == null) {
currRecord.BigData = new byte[0];
}
Client.ClientHelper.PlatformSqlMap.Create<PJ_20>(currRecord);
break;
case "edit":
if (list.Count > 0) {
foreach (WF_TableFieldValue wfv2 in list) {
WF_TableFieldValue wtfvtemp = Client.ClientHelper.PlatformSqlMap.GetOne<WF_TableFieldValue>(" where UserControlId='" + parentTemple.LPID + "'"
+ " and WorkflowId='" + wfv2.WorkFlowId + "'"
+ " and RecordId='" + wfv2.RecordId + "'"
+ " and UserControlId='" + wfv2.UserControlId + "'"
+ " and WorkFlowInsId='" + wfv2.WorkFlowInsId + "'"
+ " and FieldId='" + wfv2.FieldId + "'"
+ " and XExcelPos='" + wfv2.XExcelPos + "'"
+ " and YExcelPos='" + wfv2.YExcelPos + "'"
+ " and WorkTaskInsId='20低压设备完好率及台区网络图'");
if (wfv2.FieldId == lp.LPID) {
wfv2.Bigdata = currRecord.BigData;
}
if (wtfvtemp != null)
wfv2.ID = wtfvtemp.ID;
else {
MainHelper.PlatformSqlMap.Create<WF_TableFieldValue>(wfv2);
}
}
Client.ClientHelper.PlatformSqlMap.ExecuteTransationUpdate(null, list, null);
}
if (currRecord.BigData == null) {
currRecord.BigData = new byte[0];
}
Client.ClientHelper.PlatformSqlMap.Update<PJ_20>(currRecord);
break;
}
PS_tq tq = Client.ClientHelper.PlatformSqlMap.GetOne<PS_tq>(" where tqName='" + currRecord.tqName + "'");
int idw = 1;
string valEX = @"[0-9]+(\.)?[0-9]+";//只允许整数或小数的正则表达式
templeList = MainHelper.PlatformSqlMap.GetList<LP_Temple>("SelectLP_TempleList",
"where ParentID ='" + parentTemple.LPID + "' order by SortID");
foreach (LP_Temple lp2 in templeList) {
if ((lp2.CellName.IndexOf("补偿电容") > -1 || lp2.CellName.IndexOf("电动机") > -1 || lp2.CellName.Trim().IndexOf("机井") > -1
|| lp2.CellName.IndexOf("农副业") > -1 || lp2.CellName.IndexOf("照明户数") > -1
|| lp2.CellName.IndexOf("单相表数") > -1 || lp2.CellName.IndexOf("三相表数") > -1) == false) {
continue;
}
IList<WF_TableFieldValue> tfvli = MainHelper.PlatformSqlMap.GetList<WF_TableFieldValue>("SelectWF_TableFieldValueList",
" where UserControlId='" + parentTemple.LPID + "' and WorkTaskInsId='20低压设备完好率及台区网络图'"
+ " and FieldId='" + lp2.LPID + "' and ( WorkflowId='" + tq.tqCode + "') "
+ " order by YExcelPos");
object obj = null;
double sum = 0;
string value = "";
foreach (WF_TableFieldValue tfv in tfvli) {
WF_TableFieldValue tfvtemp = MainHelper.PlatformSqlMap.GetOne<WF_TableFieldValue>(
" where UserControlId='" + parentTemple.LPID + "'"
+ " and WorkflowId='" + tfv.WorkFlowId + "'"
+ " and RecordId='" + tfv.RecordId + "'"
+ " and FieldName='类型'"
+ " and WorkTaskInsId='20低压设备完好率及台区网络图'"
+ " order by YExcelPos");
if (tfvtemp != null && tfvtemp.ControlValue == "新增")
idw = 1;
else
if (tfvtemp != null && tfvtemp.ControlValue == "减少")
idw = -1;
else
idw = 1;
if (tfv.FieldName.IndexOf("时间") == -1 && lp.IsVisible == 0) {
valEX = "^[0-9]+(\\.)?([0-9]+)?$";
if (tfv.ControlValue == "" || Regex.Match(tfv.ControlValue, valEX).Value != "") {
if (tfv.ControlValue == "")
sum += 0;
else
sum += idw * Convert.ToDouble(tfv.ControlValue);
value = sum.ToString();
} else {
valEX = "^[0-9]+(\\.)?([0-9]+)?/[0-9]+(\\.)?([0-9]+)?";
if (Regex.Match(tfv.ControlValue, valEX).Value != "") {
string[] str1 = tfv.ControlValue.Split('/');
if (value == "") {
value = (idw * Convert.ToDouble(str1[0])).ToString() + "/" + (idw * Convert.ToDouble(str1[1])).ToString();
} else {
string[] str2 = value.Split('/');
sum = idw * Convert.ToDouble(str1[0]) + Convert.ToDouble(str2[0]);
value = sum.ToString();
if (str2.Length > 1)
sum = idw * Convert.ToDouble(str1[1]) + Convert.ToDouble(str2[1]);
else
sum = idw * Convert.ToDouble(str1[1]);
value = value + "/" + sum.ToString();
}
} else {
value = tfv.ControlValue;
}
}
} else {
value = tfv.ControlValue;
}
}
if (lp2.CellName.IndexOf("补偿电容") > -1) {
tq.bcdr = value.ToString();
}
if (lp2.CellName.IndexOf("电动机") > -1) {
tq.ddj = value.ToString();
}
if (lp2.CellName.Trim().IndexOf("机井") > -1) {
tq.jj = value.ToString();
}
if (lp2.CellName.IndexOf("农副业") > -1) {
tq.nfy = value.ToString();
}
if (lp2.CellName.IndexOf("照明户数") > -1) {
tq.zmfs = value.ToString();
}
if (lp2.CellName.IndexOf("单相表数") > -1) {
tq.dxbs = value.ToString();
}
if (lp2.CellName.IndexOf("三相表数") > -1) {
tq.sxbs = value.ToString();
}
}
Client.ClientHelper.PlatformSqlMap.Update<PS_tq>(tq);
dsoFramerWordControl1.FileClose();
this.DialogResult = DialogResult.OK;
}
private void GetFileList(DSOFramerControl ds1, string strCurDir)
{
DirectoryInfo dir;
///针对当前目录建立目录引用对象
DirectoryInfo dirInfo = new DirectoryInfo(strCurDir);
foreach (FileSystemInfo fsi in dirInfo.GetFileSystemInfos())
{
if (fsi is FileInfo)
{
if (fsi.Extension.IndexOf(".xls") < 0) continue;
string filename = fsi.FullName;
ds1.FileOpen(filename);
IList<LP_Temple> templeList = new List<LP_Temple>();
LP_Temple parentTemple = MainHelper.PlatformSqlMap.GetOne<LP_Temple>("where ParentID not in (select LPID from LP_Temple where 1=1 and CtrlSize!='目录') and CellName like '%安规电子档案%'");
if (parentTemple != null) templeList = MainHelper.PlatformSqlMap.GetList<LP_Temple>("SelectLP_TempleList",
"where ParentID ='" + parentTemple.LPID + "' order by SortID");
Excel.Worksheet xx = null;
Excel.Workbook wb = ds1.AxFramerControl.ActiveDocument as Excel.Workbook;
Excel.Worksheet sheet = wb.Application.Sheets[1] as Excel.Worksheet;
PJ_ryda currRecord = new PJ_ryda();
currRecord.CreateDate = DateTime.Now;
currRecord.BigData = ds1.FileDataGzip;
Excel.Range range;
WF_TableFieldValue wfv;
int i = 0;
foreach (LP_Temple lp in templeList)
{
string[] arrCellPos = lp.CellPos.Split('|');
arrCellPos = StringHelper.ReplaceEmpty(arrCellPos).Split('|');
if (lp.CtrlType.Contains("uc_gridcontrol"))
{
if (lp.CellName.IndexOf("培训情况") > -1)
{
for (i = 0; i < 6; i++)
{
range = sheet.get_Range(sheet.Cells[11 + i, 1], sheet.Cells[11 + i, 1]);//坐标
if (range.Value2 != null && range.Value2.ToString() != "")
{
wfv = new WF_TableFieldValue();
wfv.ID = wfv.CreateID();
wfv.RecordId = currRecord.ID;
wfv.WorkFlowId = currRecord.ID;
wfv.WorkFlowInsId = currRecord.wdmc;
wfv.WorkTaskId = "安规电子档案";
wfv.WorkTaskInsId = "安规电子档案";
wfv.UserControlId = parentTemple.LPID;
wfv.XExcelPos = GetCellPos(arrCellPos[0])[0];
wfv.YExcelPos = GetCellPos(arrCellPos[0])[1];
wfv.FieldId = lp.LPID;
wfv.FieldName = lp.CellName + "-" + "培训时间1";
wfv.ExcelSheetName = lp.KindTable;
if (range.Value2 != null)
wfv.ControlValue = range.Value2.ToString();
if (wfv.ControlValue != "" && wfv.FieldName.IndexOf("时间") > 0)
{
wfv.ControlValue = range.Value2.ToString().Replace(".", "-");
DateTime dt = Convert.ToDateTime(wfv.ControlValue);
wfv.ControlValue = dt.ToString("yyyy年MM月dd日");
}
MainHelper.PlatformSqlMap.Create<WF_TableFieldValue>(wfv);
Thread.Sleep(new TimeSpan(100000));//0.1毫秒
range = sheet.get_Range(sheet.Cells[11 + i, 2], sheet.Cells[11 + i, 2]);//坐标
wfv = new WF_TableFieldValue();
wfv.ID = wfv.CreateID();
wfv.RecordId = currRecord.ID;
wfv.WorkFlowId = currRecord.ID;
wfv.WorkFlowInsId = currRecord.wdmc;
wfv.WorkTaskId = "安规电子档案";
wfv.WorkTaskInsId = "安规电子档案";
wfv.UserControlId = parentTemple.LPID;
wfv.XExcelPos = GetCellPos(arrCellPos[1])[0];
wfv.YExcelPos = GetCellPos(arrCellPos[1])[1];
wfv.FieldId = lp.LPID;
wfv.FieldName = lp.CellName + "-" + "培训类别1";
wfv.ExcelSheetName = lp.KindTable;
if (range.Value2 != null)
wfv.ControlValue = range.Value2.ToString();
MainHelper.PlatformSqlMap.Create<WF_TableFieldValue>(wfv);
}
Thread.Sleep(new TimeSpan(100000));//0.1毫秒
range = sheet.get_Range(sheet.Cells[11 + i, 3], sheet.Cells[11 + i, 3]);//坐标
if (range.Value2 != null && range.Value2.ToString() != "")
{
wfv = new WF_TableFieldValue();
wfv.ID = wfv.CreateID();
wfv.RecordId = currRecord.ID;
wfv.WorkFlowId = currRecord.ID;
wfv.WorkFlowInsId = currRecord.wdmc;
wfv.WorkTaskId = "安规电子档案";
wfv.WorkTaskInsId = "安规电子档案";
wfv.UserControlId = parentTemple.LPID;
wfv.XExcelPos = GetCellPos(arrCellPos[2])[0];
wfv.YExcelPos = GetCellPos(arrCellPos[2])[1];
wfv.FieldId = lp.LPID;
wfv.FieldName = lp.CellName + "-" + "培训时间2";
wfv.ExcelSheetName = lp.KindTable;
if (range.Value2 != null)
wfv.ControlValue = range.Value2.ToString();
if (wfv.ControlValue != "" && wfv.FieldName.IndexOf("时间") > 0)
{
wfv.ControlValue = range.Value2.ToString().Replace(".", "-");
DateTime dt = Convert.ToDateTime(wfv.ControlValue);
wfv.ControlValue = dt.ToString("yyyy年MM月dd日");
}
MainHelper.PlatformSqlMap.Create<WF_TableFieldValue>(wfv);
Thread.Sleep(new TimeSpan(100000));//0.1毫秒
range = sheet.get_Range(sheet.Cells[11 + i, 4], sheet.Cells[11 + i, 4]);//坐标
wfv = new WF_TableFieldValue();
wfv.ID = wfv.CreateID();
wfv.RecordId = currRecord.ID;
wfv.WorkFlowId = currRecord.ID;
wfv.WorkFlowInsId = currRecord.wdmc;
wfv.WorkTaskId = "安规电子档案";
wfv.WorkTaskInsId = "安规电子档案";
wfv.UserControlId = parentTemple.LPID;
wfv.XExcelPos = GetCellPos(arrCellPos[3])[0];
wfv.YExcelPos = GetCellPos(arrCellPos[3])[1];
wfv.FieldId = lp.LPID;
wfv.FieldName = lp.CellName + "-" + "培训类别2";
wfv.ExcelSheetName = lp.KindTable;
if (range.Value2 != null)
wfv.ControlValue = range.Value2.ToString();
MainHelper.PlatformSqlMap.Create<WF_TableFieldValue>(wfv);
}
}
}
else if (lp.CellName.IndexOf("考试情况") > -1)
{
for (i = 0; i < 12; i++)
{
range = sheet.get_Range(sheet.Cells[19 + i, 1], sheet.Cells[19 + i, 1]);//坐标
if (range.Value2 != null && range.Value2.ToString() != "")
{
wfv = new WF_TableFieldValue();
wfv.ID = wfv.CreateID();
wfv.RecordId = currRecord.ID;
wfv.WorkFlowId = currRecord.ID;
wfv.WorkFlowInsId = currRecord.wdmc;
wfv.WorkTaskId = "安规电子档案";
wfv.WorkTaskInsId = "安规电子档案";
wfv.UserControlId = parentTemple.LPID;
wfv.XExcelPos = GetCellPos(arrCellPos[0])[0];
wfv.YExcelPos = GetCellPos(arrCellPos[0])[1];
wfv.FieldId = lp.LPID;
wfv.FieldName = lp.CellName + "-" + "考试时间";
wfv.ExcelSheetName = lp.KindTable;
if (range.Value2 != null)
wfv.ControlValue = range.Value2.ToString();
if (wfv.ControlValue != "" && wfv.FieldName.IndexOf("时间") > 0)
{
wfv.ControlValue = range.Value2.ToString().Replace(".", "-");
DateTime dt = Convert.ToDateTime(wfv.ControlValue);
wfv.ControlValue = dt.ToString("yyyy年MM月dd日");
}
MainHelper.PlatformSqlMap.Create<WF_TableFieldValue>(wfv);
Thread.Sleep(new TimeSpan(100000));//0.1毫秒
range = sheet.get_Range(sheet.Cells[19 + i, 2], sheet.Cells[19 + i, 2]);//坐标
wfv = new WF_TableFieldValue();
wfv.ID = wfv.CreateID();
wfv.RecordId = currRecord.ID;
wfv.WorkFlowId = currRecord.ID;
wfv.WorkFlowInsId = currRecord.wdmc;
wfv.WorkTaskId = "安规电子档案";
wfv.WorkTaskInsId = "安规电子档案";
wfv.UserControlId = parentTemple.LPID;
wfv.XExcelPos = GetCellPos(arrCellPos[1])[0];
wfv.YExcelPos = GetCellPos(arrCellPos[1])[1];
wfv.FieldId = lp.LPID;
wfv.FieldName = lp.CellName + "-" + "考试类别";
wfv.ExcelSheetName = lp.KindTable;
if (range.Value2 != null)
wfv.ControlValue = range.Value2.ToString();
MainHelper.PlatformSqlMap.Create<WF_TableFieldValue>(wfv);
Thread.Sleep(new TimeSpan(100000));//0.1毫秒
range = sheet.get_Range(sheet.Cells[19 + i, 3], sheet.Cells[19 + i, 3]);//坐标
wfv = new WF_TableFieldValue();
wfv.ID = wfv.CreateID();
wfv.RecordId = currRecord.ID;
wfv.WorkFlowId = currRecord.ID;
wfv.WorkFlowInsId = currRecord.wdmc;
wfv.WorkTaskId = "安规电子档案";
wfv.WorkTaskInsId = "安规电子档案";
wfv.UserControlId = parentTemple.LPID;
wfv.XExcelPos = GetCellPos(arrCellPos[2])[0];
wfv.YExcelPos = GetCellPos(arrCellPos[2])[1];
wfv.FieldId = lp.LPID;
wfv.FieldName = lp.CellName + "-" + "考试成绩";
wfv.ExcelSheetName = lp.KindTable;
if (range.Value2 != null)
wfv.ControlValue = range.Value2.ToString();
MainHelper.PlatformSqlMap.Create<WF_TableFieldValue>(wfv);
Thread.Sleep(new TimeSpan(100000));//0.1毫秒
range = sheet.get_Range(sheet.Cells[19 + i, 4], sheet.Cells[19 + i, 4]);//坐标
wfv = new WF_TableFieldValue();
wfv.ID = wfv.CreateID();
wfv.RecordId = currRecord.ID;
wfv.WorkFlowId = currRecord.ID;
wfv.WorkFlowInsId = currRecord.wdmc;
wfv.WorkTaskId = "安规电子档案";
wfv.WorkTaskInsId = "安规电子档案";
wfv.UserControlId = parentTemple.LPID;
wfv.XExcelPos = GetCellPos(arrCellPos[3])[0];
wfv.YExcelPos = GetCellPos(arrCellPos[3])[1];
wfv.FieldId = lp.LPID;
wfv.FieldName = lp.CellName + "-" + "考试评价";
wfv.ExcelSheetName = lp.KindTable;
if (range.Value2 != null)
wfv.ControlValue = range.Value2.ToString();
MainHelper.PlatformSqlMap.Create<WF_TableFieldValue>(wfv);
Thread.Sleep(new TimeSpan(100000));//0.1毫秒
range = sheet.get_Range(sheet.Cells[19 + i, 5], sheet.Cells[19 + i, 5]);//坐标
wfv = new WF_TableFieldValue();
wfv.ID = wfv.CreateID();
wfv.RecordId = currRecord.ID;
wfv.WorkFlowId = currRecord.ID;
wfv.WorkFlowInsId = currRecord.wdmc;
wfv.WorkTaskId = "安规电子档案";
wfv.WorkTaskInsId = "安规电子档案";
wfv.UserControlId = parentTemple.LPID;
wfv.XExcelPos = GetCellPos(arrCellPos[4])[0];
wfv.YExcelPos = GetCellPos(arrCellPos[4])[1];
wfv.FieldId = lp.LPID;
wfv.FieldName = lp.CellName + "-" + "年检情况";
wfv.ExcelSheetName = lp.KindTable;
if (range.Value2 != null)
wfv.ControlValue = range.Value2.ToString();
MainHelper.PlatformSqlMap.Create<WF_TableFieldValue>(wfv);
}
}
}
}
else
{
range = sheet.get_Range(sheet.Cells[GetCellPos(arrCellPos[0])[0], GetCellPos(arrCellPos[0])[1]], sheet.Cells[GetCellPos(arrCellPos[0])[0], GetCellPos(arrCellPos[0])[1]]);//坐标
wfv = new WF_TableFieldValue();
wfv.ID = wfv.CreateID();
wfv.RecordId = currRecord.ID;
wfv.WorkFlowId = currRecord.ID;
wfv.WorkFlowInsId = currRecord.wdmc;
wfv.WorkTaskId = "安规电子档案";
wfv.WorkTaskInsId = "安规电子档案";
wfv.UserControlId = parentTemple.LPID;
wfv.XExcelPos = GetCellPos(arrCellPos[0])[0];
wfv.YExcelPos = GetCellPos(arrCellPos[0])[1];
wfv.FieldId = lp.LPID;
wfv.FieldName = lp.CellName;
wfv.ExcelSheetName = lp.KindTable;
if (range.Value2 != null)
wfv.ControlValue = range.Value2.ToString();
if (wfv.ControlValue != "" && lp.CellName == "出生年月日")
{
wfv.ControlValue = range.Value2.ToString().Replace(".", "-");
DateTime dt = Convert.ToDateTime(wfv.ControlValue);
wfv.ControlValue = dt.ToString("yyyy年MM月dd日");
}
if (wfv.ControlValue != "" && lp.CellName == "参加工作时间")
{
try
{
wfv.ControlValue = range.Value2.ToString().Replace(".", "-");
DateTime dt = Convert.ToDateTime(wfv.ControlValue);
wfv.ControlValue = dt.ToString("yyyy年MM月dd日");
}
catch
{
DateTime dt = new DateTime(Convert.ToInt32(wfv.ControlValue));
wfv.ControlValue = dt.ToString("yyyy年MM月dd日");
}
}
if (lp.CellName == "姓名")
{
currRecord.wdmc = wfv.ControlValue;
}
else if (lp.CellName == "职务")
{
currRecord.wdlx = wfv.ControlValue;
}
else if (lp.CellName == "所在单位")
{
currRecord.OrgName = wfv.ControlValue.Replace(MainHelper.UserCompany, "");
mOrg org = MainHelper.PlatformSqlMap.GetOne<mOrg>("where OrgName='" + currRecord.OrgName + "'");
if (org != null)
{
currRecord.OrgCode = org.OrgCode;
}
}
wfv.WorkFlowInsId = currRecord.wdmc;
MainHelper.PlatformSqlMap.Create<WF_TableFieldValue>(wfv);
Thread.Sleep(new TimeSpan(100000));//0.1毫秒
}
}
currRecord.CreateMan = MainHelper.User.UserName;
MainHelper.PlatformSqlMap.Create<PJ_ryda>(currRecord);
ds1.FileSave();
ds1.FileClose();
}
else
{
dir = (DirectoryInfo)fsi;
//获取文件夹路径
GetFileList(ds1, strCurDir + "\\" + dir.Name);
}
}
}
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();
}
}
void btn_Save_Click(object sender, EventArgs e)
{
dsoFramerWordControl1.FileSave();
try
{
currRecord.LastChangeTime = DateTime.Now.ToString();
currRecord.DocContent = dsoFramerWordControl1.FileDataGzip;
if (currRecord.ImageAttachment == null) currRecord.ImageAttachment = new byte[0];
if (currRecord.SignImg == null) currRecord.SignImg = new byte[0];
Client.ClientHelper.PlatformSqlMap.Update("UpdateLP_Record", currRecord);
ArrayList akeys = new ArrayList(valuehs.Keys);
List<object> list = new List<object>();
DateTime dt = DateTime.Now;
Random rd = new Random();
WF_TableFieldValue wfv = null;
int irpos = 5001;
decimal dtemp = Convert.ToDecimal(dt.ToString("yyyyMMddHHmmssffffff"));
for (int i = 0; i < akeys.Count; i++)
{
wfv = valuehs[akeys[i]] as WF_TableFieldValue;
if (wfv.XExcelPos != -1 && wfv.YExcelPos != -1)
wfv.ID = Convert.ToString((dtemp + wfv.YExcelPos + wfv.XExcelPos * 10000));
else
{
wfv.ID = Convert.ToString((dtemp + irpos + irpos * 10000));
irpos++;
}
wfv.RecordId = currRecord.ID;
wfv.WorkFlowId = WorkFlowData.Rows[0]["WorkFlowId"].ToString();
wfv.WorkFlowInsId = WorkFlowData.Rows[0]["WorkFlowInsId"].ToString();
wfv.WorkTaskId = WorkFlowData.Rows[0]["WorkTaskId"].ToString();
wfv.WorkTaskInsId = WorkFlowData.Rows[0]["WorkTaskInsId"].ToString();
wfv.UserControlId = parentTemple.LPID;
//MainHelper.PlatformSqlMap.Create<WF_TableFieldValue>(wfv);
//Thread.Sleep(new TimeSpan(100000));//0.1毫秒
list.Add(wfv);
MainHelper.PlatformSqlMap.DeleteByWhere<WF_TableFieldValue>(" where FieldId ='" + wfv.FieldId + "' and WorkFlowInsId='" + WorkFlowData.Rows[0]["WorkFlowInsId"].ToString() + "' and WorkTaskId='" + WorkFlowData.Rows[0]["WorkTaskId"].ToString() + "'");
}
//foreach (WF_TableFieldValue wfv in list)
//{
// Console.Write(wfv.ID + "\r\n");
//}
foreach (WF_TableFieldValue wfv2 in list)
{
WF_TableFieldValue wtfvtemp = Client.ClientHelper.PlatformSqlMap.GetOne<WF_TableFieldValue>(" where UserControlId='" + parentTemple.LPID + "'"
+ " and WorkflowId='" + wfv2.WorkFlowId + "'"
+ " and RecordId='" + wfv2.RecordId + "'"
+ " and UserControlId='" + wfv2.UserControlId + "'"
+ " and WorkFlowInsId='" + wfv2.WorkFlowInsId + "'"
+ " and fieldname='" + wfv2.FieldName + "'"
+ " and FieldId='" + wfv2.FieldId + "'"
+ " and XExcelPos='" + wfv2.XExcelPos + "'"
+ " and YExcelPos='" + wfv2.YExcelPos + "'"
+ " and WorkTaskId='" + wfv2.WorkTaskId + "'"
);
if (wtfvtemp != null)
wfv2.ID = wtfvtemp.ID;
else
{
Client.ClientHelper.PlatformSqlMap.Create<WF_TableFieldValue>(wfv2);
}
}
Client.ClientHelper.PlatformSqlMap.ExecuteTransationUpdate(null, list, null);
LP_Temple lp = MainHelper.PlatformSqlMap.GetOne<LP_Temple>(" where ParentID='" + parentTemple.LPID + "' and SortID=1");
if (lp != null)
{
if (wfv == null)
{
wfv = new WF_TableFieldValue();
wfv.ID = wfv.CreateID();
wfv.RecordId = currRecord.ID;
wfv.WorkFlowId = WorkFlowData.Rows[0]["WorkFlowId"].ToString();
wfv.WorkFlowInsId = WorkFlowData.Rows[0]["WorkFlowInsId"].ToString();
wfv.WorkTaskId = WorkFlowData.Rows[0]["WorkTaskId"].ToString();
wfv.WorkTaskInsId = WorkFlowData.Rows[0]["WorkTaskInsId"].ToString();
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.ExcelSheetName = activeSheetName;
}
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"
);
dsoFramerWordControl1.FileSave();
currRecord.DocContent = dsoFramerWordControl1.FileDataGzip;
if (currRecord.ImageAttachment == null) currRecord.ImageAttachment = new byte[0];
if (currRecord.SignImg == null) currRecord.SignImg = new byte[0];
if (wfv == null)
{
wfv = new WF_TableFieldValue();
wfv.ID = wfv.CreateID();
wfv.RecordId = currRecord.ID;
wfv.WorkFlowId = WorkFlowData.Rows[0]["WorkFlowId"].ToString();
wfv.WorkFlowInsId = WorkFlowData.Rows[0]["WorkFlowInsId"].ToString();
wfv.WorkTaskId = WorkFlowData.Rows[0]["WorkTaskId"].ToString();
wfv.WorkTaskInsId = WorkFlowData.Rows[0]["WorkTaskInsId"].ToString();
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.ExcelSheetName = activeSheetName;
wfv.Bigdata = currRecord.DocContent;
MainHelper.PlatformSqlMap.Create<WF_TableFieldValue>(wfv);
}
else
{
wfv.Bigdata = currRecord.DocContent;
MainHelper.PlatformSqlMap.Update<WF_TableFieldValue>(wfv);
}
}
MsgBox.ShowTipMessageBox("保存成功!");
//this.DialogResult = DialogResult.OK;
}
catch
{
MsgBox.ShowTipMessageBox("出错,保存失败!");
}
}
private void LPFrm_Load(object sender, EventArgs e)
{
loadbasedata();
System.Windows.Forms.Control.CheckForIllegalCrossThreadCalls = false;
if (tempCtrlList == null)
{
tempCtrlList = new List<Control>();
}
//InitializeComponent();
if (valuehs == null)
valuehs = new Hashtable();
InitIndex();
if (kind == null) return;
if (GetWorkFlowNmae(kind).IndexOf("电力线路") > -1)
{
bhht.Clear();
bhht.Add("宝山供电所", "01");
bhht.Add("长发供电所", "02");
bhht.Add("绥胜供电所", "03");
bhht.Add("红旗供电所", "04");
bhht.Add("永安供电所", "05");
bhht.Add("连岗供电所", "06");
bhht.Add("太平供电所", "07");
bhht.Add("新华供电所", "08");
bhht.Add("北郊供电所", "09");
bhht.Add("东郊供电所", "10");
bhht.Add("东富供电所", "11");
bhht.Add("兴福供电所", "12");
bhht.Add("利民供电所", "13");
bhht.Add("东津供电所", "14");
bhht.Add("津河供电所", "15");
bhht.Add("龙太供电所", "16");
bhht.Add("秦家供电所", "17");
bhht.Add("双河供电所", "18");
bhht.Add("五营供电所", "19");
bhht.Add("三河供电所", "20");
bhht.Add("四方台供电所", "21");
bhht.Add("张维供电所", "22");
bhht.Add("民吉供电所", "23");
bhht.Add("三井供电所", "24");
bhht.Add("联合供电所", "25");
bhht.Add("新生供电所", "26");
bhht.Add("张维变电所", "27");
bhht.Add("秦家变电所", "28");
bhht.Add("四方台变电所", "29");
bhht.Add("三河变电所", "30");
bhht.Add("长发变电所", "31");
bhht.Add("五营变电所", "32");
bhht.Add("新华变电所", "33");
bhht.Add("太平变电所", "34");
bhht.Add("红旗变电所", "35");
bhht.Add("连岗变电所", "36");
bhht.Add("津河变电所", "37");
bhht.Add("送变电工区", "38");
}
//InitContorl();
WF_TableFieldValue wfv = null;
ExcelAccess ea = new ExcelAccess();
LP_Temple lp = MainHelper.PlatformSqlMap.GetOne<LP_Temple>(" where ParentID='" + parentTemple.LPID + "' and SortID=1");
if (lp != null)
{
if (wfv == null)
{
wfv = new WF_TableFieldValue();
wfv.ID = wfv.CreateID();
wfv.RecordId = currRecord.ID;
wfv.WorkFlowId = WorkFlowData.Rows[0]["WorkFlowId"].ToString();
wfv.WorkFlowInsId = WorkFlowData.Rows[0]["WorkFlowInsId"].ToString();
wfv.WorkTaskId = WorkFlowData.Rows[0]["WorkTaskId"].ToString();
wfv.WorkTaskInsId = WorkFlowData.Rows[0]["WorkTaskInsId"].ToString();
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 (status == "add" && parentTemple.DocContent != null && parentTemple.DocContent.Length > 0)
{
if (wfv != null && wfv.Bigdata != null && wfv.Bigdata.Length > 0)
{
this.dsoFramerWordControl1.FileDataGzip = wfv.Bigdata;
}
else
if (GetWorkFlowNmae(kind).IndexOf("电力线路") > -1 && currRecord.DocContent != null && currRecord.DocContent.Length > 0)
this.dsoFramerWordControl1.FileDataGzip = currRecord.DocContent;
else
this.dsoFramerWordControl1.FileDataGzip = parentTemple.DocContent;
InitContorl();
}
else if (status == "edit")
{
if (currRecord.DocContent == null)
{
currRecord.DocContent = new byte[0];
}
if (currRecord.ID.IndexOf("N") == -1)
{
this.dsoFramerWordControl1.FileDataGzip = currRecord.DocContent;
}
else
{
if (wfv != null && wfv.Bigdata != null && wfv.Bigdata.Length > 0)
{
this.dsoFramerWordControl1.FileDataGzip = wfv.Bigdata;
}
else
if (GetWorkFlowNmae(kind).IndexOf("电力线路") > -1 && currRecord.DocContent != null && currRecord.DocContent.Length > 0)
this.dsoFramerWordControl1.FileDataGzip = currRecord.DocContent;
else
this.dsoFramerWordControl1.FileDataGzip = parentTemple.DocContent;
}
InitContorl();
//LoadContent();
}
if ((parentTemple != null && parentTemple.DocContent != null) || (currRecord != null && currRecord.DocContent != null && currRecord.DocContent.Length > 0))
{
wb = dsoFramerWordControl1.AxFramerControl.ActiveDocument as Excel.Workbook;
//sheet = wb.Application.Sheets[activeSheetName] as Excel.Worksheet;
//activeSheetIndex = sheet.Index;
try
{
for (int i = 1; i <= wb.Application.Sheets.Count; i++)
{
sheet = wb.Application.Sheets[i] as Excel.Worksheet;
Workbook_SheetDeactivate(sheet);
//保护工作表
LockExcel(wb, sheet);
//if (i != activeSheetIndex)
//{
// Excel.Worksheet tmpSheet = (Excel.Worksheet)wb.Application.Sheets.get_Item(i);
// try
// {
// if (tmpSheet != null) tmpSheet.Visible = Excel.XlSheetVisibility.xlSheetHidden;
// }
// catch { }
}
}
catch { }
}
IList<WF_TableFieldValue> tfvli = MainHelper.PlatformSqlMap.GetList<WF_TableFieldValue>("SelectWF_TableFieldValueList",
" where RecordId='" + currRecord.ID + "' and UserControlId='" + parentTemple.LPID + "' and WorkflowId='" + WorkFlowData.Rows[0]["WorkflowId"] + "' and WorkFlowInsId='" + WorkFlowData.Rows[0]["WorkFlowInsId"] + "' order by YExcelPos,XExcelPos");
Excel.Worksheet xx;
wb = dsoFramerWordControl1.AxFramerControl.ActiveDocument as Excel.Workbook;
ea.MyWorkBook = wb;
ea.MyExcel = wb.Application;
string activeSheetName = "";
try
{
xx = wb.Application.Sheets[1] as Excel.Worksheet;
}
catch { }
for (int i = 0; i < tfvli.Count; i++)
{
Control ctl = FindCtrl(tfvli[i].FieldId);
if (ctl != null)
{
lp = ctl.Tag as LP_Temple;
if (lp.CtrlType.Contains("DevExpress.XtraEditors.DateEdit") == false)
{
if (lp.CellName != "编号")
{
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 WorkflowId='" + WorkFlowData.Rows[0]["WorkflowId"] + "' and WorkFlowInsId='" + WorkFlowData.Rows[0]["WorkFlowInsId"] + "' 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();
//保护工作表
// LockExcel(wb,sheet);
//}
}
void btn_Submit_Click(object sender, EventArgs e)
{
Excel.Workbook wb;
//Excel.Worksheet sheet;
wb = dsoFramerWordControl1.AxFramerControl.ActiveDocument as Excel.Workbook;
if (activeSheetName != "")
{
sheet = wb.Application.Sheets[activeSheetName] as Excel.Worksheet;
}
else
{
sheet = wb.Application.Sheets[1] as Excel.Worksheet;
}
//activeSheetIndex = sheet.Index;
if (filecontrol != null)
{
if (filecontrol.Isupfile)
{
MsgBox.ShowTipMessageBox("请稍后，正在上传文件");
return;
}
if (filecontrol.Isdownfile)
{
if (MsgBox.ShowAskMessageBox("正在下载文件，确认提交?") != DialogResult.OK)
{
return;
}
}
}
for (int i = 1; i <= wb.Application.Sheets.Count; i++)
{
if (i != activeSheetIndex)
{
Excel.Worksheet tmpSheet = (Excel.Worksheet)wb.Application.Sheets.get_Item(i);
try
{
if (tmpSheet != null) tmpSheet.Visible = Excel.XlSheetVisibility.xlSheetVisible;
}
catch { }
}
}
unLockExcel(wb, sheet);
for (int i = 1; sheet.Protection.AllowEditRanges.Count > 0; )
{
Excel.AllowEditRange editRange = sheet.Protection.AllowEditRanges.get_Item(i);
editRange.Delete();
}
LockExcel(wb, sheet);
byte[] bt = new byte[0];
string strmes = "";
WF_WorkTaskCommands wt;
if (strNumber != "") currRecord.Number = strNumber;
ArrayList akeys = new ArrayList(valuehs.Keys);
List<object> list = new List<object>();
DateTime dt = DateTime.Now;
Random rd = new Random();
int irpos = 5001;
WF_TableFieldValue wfv = null;
decimal dtemp = Convert.ToDecimal(dt.ToString("yyyyMMddHHmmssffffff"));
for (int i = 0; i < akeys.Count; i++)
{
wfv = valuehs[akeys[i]] as WF_TableFieldValue;
if (wfv.XExcelPos != -1 && wfv.YExcelPos != -1)
wfv.ID = Convert.ToString((dtemp + wfv.YExcelPos + wfv.XExcelPos * 10000));
else
{
wfv.ID = Convert.ToString((dtemp + irpos + irpos * 10000));
irpos++;
}
wfv.RecordId = currRecord.ID;
wfv.WorkFlowId = WorkFlowData.Rows[0]["WorkFlowId"].ToString();
wfv.WorkFlowInsId = WorkFlowData.Rows[0]["WorkFlowInsId"].ToString();
wfv.WorkTaskId = WorkFlowData.Rows[0]["WorkTaskId"].ToString();
wfv.WorkTaskInsId = WorkFlowData.Rows[0]["WorkTaskInsId"].ToString();
wfv.UserControlId = parentTemple.LPID;
//MainHelper.PlatformSqlMap.Create<WF_TableFieldValue>(wfv);
//Thread.Sleep(new TimeSpan(100000));//0.1毫秒
wfv.ID = wfv.CreateID() + new Random().Next(10, 99);
list.Add(wfv);
MainHelper.PlatformSqlMap.DeleteByWhere<WF_TableFieldValue>(" where FieldId ='" + wfv.FieldId + "' and WorkFlowInsId='" + WorkFlowData.Rows[0]["WorkFlowInsId"].ToString() + "' and WorkTaskId='" + WorkFlowData.Rows[0]["WorkTaskId"].ToString() + "'");
}
//foreach (WF_TableFieldValue wfv in list)
//{
// Console.Write(wfv.ID+"\r\n");
//}
if (RecordWorkTask.CheckOnRiZhi(WorkFlowData))
{
RecordWorkTask.CreatRiZhi(WorkFlowData, dsoFramerWordControl1, currRecord.ID, new object[] { currRecord });
}
//RecordWorkTask.CreateJL(WorkFlowData, dsoFramerWordControl1, currRecord.ID, new object[] { currRecord });
if (strxiestatus == "add")
{
if (list.Count > 0)
{
Client.ClientHelper.PlatformSqlMap.ExecuteTransationUpdate(list, null, null);
}
}
else
{
if (list.Count > 0)
{
foreach (WF_TableFieldValue wfv2 in list)
{
WF_TableFieldValue wtfvtemp = Client.ClientHelper.PlatformSqlMap.GetOne<WF_TableFieldValue>(" where UserControlId='" + parentTemple.LPID + "'"
+ " and WorkflowId='" + wfv2.WorkFlowId + "'"
+ " and RecordId='" + wfv2.RecordId + "'"
+ " and UserControlId='" + wfv2.UserControlId + "'"
+ " and WorkFlowInsId='" + wfv2.WorkFlowInsId + "'"
+ " and fieldname='" + wfv2.FieldName + "'"
+ " and FieldId='" + wfv2.FieldId + "'"
+ " and XExcelPos='" + wfv2.XExcelPos + "'"
+ " and YExcelPos='" + wfv2.YExcelPos + "'"
+ " and WorkTaskId='" + wfv2.WorkTaskId + "'"
);
if (wtfvtemp != null)
wfv2.ID = wtfvtemp.ID;
else
{
wfv2.ID = wfv2.CreateID();
Client.ClientHelper.PlatformSqlMap.Create<WF_TableFieldValue>(wfv2);
}
}
Client.ClientHelper.PlatformSqlMap.ExecuteTransationUpdate(null, list, null);
}
}
LP_Temple lp = MainHelper.PlatformSqlMap.GetOne<LP_Temple>(" where ParentID='" + parentTemple.LPID + "' and SortID=1");
if (lp != null)
{
if (wfv == null)
{
wfv = new WF_TableFieldValue();
wfv.ID = wfv.CreateID();
wfv.RecordId = currRecord.ID;
wfv.WorkFlowId = WorkFlowData.Rows[0]["WorkFlowId"].ToString();
wfv.WorkFlowInsId = WorkFlowData.Rows[0]["WorkFlowInsId"].ToString();
wfv.WorkTaskId = WorkFlowData.Rows[0]["WorkTaskId"].ToString();
wfv.WorkTaskInsId = WorkFlowData.Rows[0]["WorkTaskInsId"].ToString();
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.ExcelSheetName = activeSheetName;
}
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"
);
dsoFramerWordControl1.FileSave();
currRecord.DocContent = dsoFramerWordControl1.FileDataGzip;
if (currRecord.ImageAttachment == null) currRecord.ImageAttachment = new byte[0];
if (currRecord.SignImg == null) currRecord.SignImg = new byte[0];
if (wfv == null)
{
wfv = new WF_TableFieldValue();
wfv.ID = wfv.CreateID();
wfv.RecordId = currRecord.ID;
wfv.WorkFlowId = WorkFlowData.Rows[0]["WorkFlowId"].ToString();
wfv.WorkFlowInsId = WorkFlowData.Rows[0]["WorkFlowInsId"].ToString();
wfv.WorkTaskId = WorkFlowData.Rows[0]["WorkTaskId"].ToString();
wfv.WorkTaskInsId = WorkFlowData.Rows[0]["WorkTaskInsId"].ToString();
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.ExcelSheetName = activeSheetName;
wfv.Bigdata = currRecord.DocContent;
MainHelper.PlatformSqlMap.Create<WF_TableFieldValue>(wfv);
}
else
{
wfv.Bigdata = currRecord.DocContent;
MainHelper.PlatformSqlMap.Update<WF_TableFieldValue>(wfv);
}
}
RunTaskUpdate();
RunTaskRecordUpdate();
switch (status)
{
case "add":
//LP_Record newRecord = new LP_Record();
currRecord.Kind = kind;
currRecord.Content = GetContent();
dsoFramerWordControl1.FileSave();
//dsoFramerWordControl1.FileClose();
if (ctrlNumber != null)
currRecord.Number = ctrlNumber.Text;
//currRecord.ImageAttachment = bt;
//currRecord.SignImg = bt;
currRecord.LastChangeTime = DateTime.Now.ToString();
//string[] strtemp = RecordWorkTask.RunNewGZPRecord(currRecord.ID, kind, MainHelper.User.UserID);
wt = (WF_WorkTaskCommands)MainHelper.PlatformSqlMap.GetObject("SelectWF_WorkTaskCommandsList", " where WorkFlowId='" + WorkFlowData.Rows[0]["WorkFlowId"].ToString() + "' and WorkTaskId='" + WorkFlowData.Rows[0]["WorkTaskId"].ToString() + "'");
if (wt != null)
{
strmes = RecordWorkTask.RunWorkFlow(MainHelper.User.UserID, WorkFlowData.Rows[0]["OperatorInsId"].ToString(), WorkFlowData.Rows[0]["WorkTaskInsId"].ToString(), wt.CommandName);
}
else
{
strmes = RecordWorkTask.RunWorkFlow(MainHelper.User.UserID, WorkFlowData.Rows[0]["OperatorInsId"].ToString(), WorkFlowData.Rows[0]["WorkTaskInsId"].ToString(), "提交");
}
//strmes = strtemp[0];
//currRecord.Status = strtemp[1];
if (strmes.IndexOf("未提交至任何人") > -1)
{
MsgBox.ShowTipMessageBox("未提交至任何人,创建失败,请检查流程模板和组织机构配置是否正确!");
return;
}
else
MsgBox.ShowTipMessageBox(strmes);
strmes = RecordWorkTask.GetWorkFlowTaskCaption(WorkFlowData.Rows[0]["WorkTaskInsId"].ToString());
if (strmes == "结束节点1")
{
currRecord.Status = "存档";
}
else
{
currRecord.Status = strmes;
}
if (currRecord.ImageAttachment == null) currRecord.ImageAttachment = new byte[0];
if (currRecord.SignImg == null) currRecord.SignImg = new byte[0];
if (currRecord.ImageAttachment == null) currRecord.ImageAttachment = new byte[0];
if (currRecord.SignImg == null) currRecord.SignImg = new byte[0];
MainHelper.PlatformSqlMap.Update("UpdateLP_Record", currRecord);
rowData = null;
if (hqyjcontrol != null)
{
PJ_lcspyj lcyj = new PJ_lcspyj();
lcyj.Charman = MainHelper.User.UserName;
lcyj.ID = PJ_lcspyj.Newid();
lcyj.RecordID = currRecord.ID;
lcyj.taskID = WorkFlowData.Rows[0]["WorkTaskInsId"].ToString();
lcyj.Spyj = hqyjcontrol.nowMemoEdit.Text;
lcyj.Creattime = DateTime.Now;
if (hqyjcontrol.nowMemoEdit.Text != "")
MainHelper.PlatformSqlMap.Create<PJ_lcspyj>(lcyj);
}
if (filecontrol != null)
{
for (int i = 0; i < filecontrol.FJtable.Rows.Count; i++)
{
PJ_lcfj lcfu = new PJ_lcfj();
lcfu.ID = lcfu.CreateID();
lcfu.Filename = Path.GetFileName(filecontrol.FJtable.Rows[i]["FilePath"].ToString());
lcfu.FileRelativePath = filecontrol.FJtable.Rows[i]["SaveFileName"].ToString();
lcfu.FileSize = Convert.ToInt64(filecontrol.FJtable.Rows[i]["FileSize"]);
lcfu.RecordID = currRecord.ID;
lcfu.Creattime = DateTime.Now;
Thread.Sleep((new TimeSpan(100000)));//0.1毫秒
if (filecontrol.FJtable.Rows[i]["Kind"].ToString() != "已上传")
MainHelper.PlatformSqlMap.Create<PJ_lcfj>(lcfu);
}
}
//currRecord = newRecord;
break;
case "edit":
currRecord.LastChangeTime = DateTime.Now.ToString();
// dsoFramerWordControl1.FileSave();
//currRecord.DocContent = this.dsoFramerWordControl1.FileDataGzip;
//byte[] bt = new byte[0];
//currRecord.ImageAttachment = bt;
//currRecord.SignImg = bt;
currRecord.Content = GetContent();
dsoFramerWordControl1.FileSave();
//dsoFramerWordControl1.FileClose();
wt = (WF_WorkTaskCommands)MainHelper.PlatformSqlMap.GetObject("SelectWF_WorkTaskCommandsList", " where WorkFlowId='" + WorkFlowData.Rows[0]["WorkFlowId"].ToString() + "' and WorkTaskId='" + WorkFlowData.Rows[0]["WorkTaskId"].ToString() + "'");
if (wt != null)
{
strmes = RecordWorkTask.RunWorkFlow(MainHelper.User.UserID, WorkFlowData.Rows[0]["OperatorInsId"].ToString(), WorkFlowData.Rows[0]["WorkTaskInsId"].ToString(), wt.CommandName);
}
else
{
strmes = RecordWorkTask.RunWorkFlow(MainHelper.User.UserID, WorkFlowData.Rows[0]["OperatorInsId"].ToString(), WorkFlowData.Rows[0]["WorkTaskInsId"].ToString(), "提交");
}
string towho = strmes;
strmes = RecordWorkTask.GetWorkFlowTaskCaption(WorkFlowData.Rows[0]["WorkTaskInsId"].ToString());
if (strmes.IndexOf("结束节点") > -1)
{
CurrRecord.Status = "存档";
}
else
{
CurrRecord.Status = strmes;
}
if (towho.IndexOf("未提交至任何人") > -1)
{
MsgBox.ShowTipMessageBox("未提交至任何人,创建失败,请检查流程模板和组织机构配置是否正确!");
return;
}
else
MsgBox.ShowTipMessageBox(towho);
if (currRecord.ImageAttachment == null) currRecord.ImageAttachment = new byte[0];
if (currRecord.SignImg == null) currRecord.SignImg = new byte[0];
if (currRecord.ImageAttachment == null) currRecord.ImageAttachment = new byte[0];
if (currRecord.SignImg == null) currRecord.SignImg = new byte[0];
MainHelper.PlatformSqlMap.Update("UpdateLP_Record", currRecord);
if (hqyjcontrol != null)
{
PJ_lcspyj lcyj = new PJ_lcspyj();
lcyj.Charman = MainHelper.User.UserName;
lcyj.ID = PJ_lcspyj.Newid();
lcyj.RecordID = currRecord.ID;
lcyj.taskID = WorkFlowData.Rows[0]["WorkTaskInsId"].ToString();
lcyj.Spyj = hqyjcontrol.nowMemoEdit.Text;
lcyj.Creattime = DateTime.Now;
if (hqyjcontrol.nowMemoEdit.Text != "")
MainHelper.PlatformSqlMap.Create<PJ_lcspyj>(lcyj);
}
rowData = null;
break;
}
this.DialogResult = DialogResult.OK;
}
void btn_Submit_Click(object sender, EventArgs e)
{
Excel.Workbook wb;
Excel.Worksheet sheet;
dsoFramerWordControl1.FileSave();
currRecord.BigData = this.dsoFramerWordControl1.FileDataGzip;
wb = dsoFramerWordControl1.AxFramerControl.ActiveDocument as Excel.Workbook;
if (activeSheetName != "")
{
sheet = wb.Application.Sheets[activeSheetName] as Excel.Worksheet;
}
else
{
sheet = wb.Application.Sheets[1] as Excel.Worksheet;
}
activeSheetIndex = sheet.Index;
for (int i = 1; i <= wb.Application.Sheets.Count; i++)
{
if (i != activeSheetIndex)
{
Excel.Worksheet tmpSheet = (Excel.Worksheet)wb.Application.Sheets.get_Item(i);
try
{
if (tmpSheet != null) tmpSheet.Visible = Excel.XlSheetVisibility.xlSheetVisible ;
}
catch { }
}
}
unLockExcel(wb,sheet);
for (int i = 1; sheet.Protection.AllowEditRanges.Count > 0; )
{
Excel.AllowEditRange editRange = sheet.Protection.AllowEditRanges.get_Item(i);
editRange.Delete();
}
LockExcel(wb, sheet);
byte[] bt = new byte[0];
string strmes = "";
WF_WorkTaskCommands wt;
LP_Temple lp = MainHelper.PlatformSqlMap.GetOne<LP_Temple>("where ParentID='" + parentTemple.LPID + "' and CellName like '%姓名%'");
Control ctl = FindCtrl(lp.LPID);
if (ctl != null)
{
currRecord.wdmc = ctl.Text;
}
lp = MainHelper.PlatformSqlMap.GetOne<LP_Temple>("where ParentID='" + parentTemple.LPID + "' and CellName like '%职务%'");
ctl = FindCtrl(lp.LPID);
if (ctl != null)
{
currRecord.wdlx = ctl.Text;
}
//rowData = null;
ArrayList akeys = new ArrayList(valuehs.Keys);
List<object> list = new List<object>();
for (int i = 0; i < akeys.Count; i++)
{
WF_TableFieldValue wfv = valuehs[akeys[i]] as WF_TableFieldValue;
wfv.ID = wfv.CreateID();
wfv.RecordId = currRecord.ID;
wfv.WorkFlowId = currRecord.ID ;
wfv.WorkFlowInsId = currRecord.wdmc ;
wfv.WorkTaskId = "安规电子档案";
wfv.WorkTaskInsId = "安规电子档案";
wfv.UserControlId = parentTemple.LPID;
Thread.Sleep(new TimeSpan(100000));//0.1毫秒
list.Add(wfv);
if (wfv.FieldName == "所在单位")
{
rowData.OrgName = wfv.ControlValue.Replace(MainHelper.UserCompany, "");
mOrg org = MainHelper.PlatformSqlMap.GetOne<mOrg>("where OrgName='" + rowData.OrgName + "'");
if (org != null)
{
rowData.OrgCode = org.OrgCode;
}
}
for (int j = 0; j < templeList.Count; j++)
{
if (templeList[j].LPID == wfv.FieldId)
{
templeList.RemoveAt(j);
break;
}
}
}
Control ct=null;
for (int i = 0; i < templeList.Count; i++)
{
WF_TableFieldValue wfv = new WF_TableFieldValue();
wfv.ExcelSheetName = templeList[i].KindTable;
if (templeList[i].CellPos != "")
{
wfv.XExcelPos = GetCellPos(templeList[i].CellPos)[0];
wfv.YExcelPos = GetCellPos(templeList[i].CellPos)[1];
}
else
{
wfv.XExcelPos = -1;
wfv.YExcelPos = -1;
}
wfv.FieldId = templeList[i].LPID;
wfv.FieldName = templeList[i].CellName;
ct = FindCtrl( templeList[i].LPID);
if(ct!=null)
wfv.ControlValue=ct.Text;
wfv.ID = wfv.CreateID();
wfv.RecordId = currRecord.ID;
wfv.WorkFlowId = currRecord.ID;
wfv.WorkFlowInsId = currRecord.wdmc;
wfv.WorkTaskId = "安规电子档案";
wfv.WorkTaskInsId = "安规电子档案";
wfv.UserControlId = parentTemple.LPID;
wfv.UserControlId = parentTemple.LPID;
Thread.Sleep(new TimeSpan(100000));//0.1毫秒
list.Add(wfv);
}
switch (status)
{
case "add":
if (list.Count > 0)
{
Client.ClientHelper.PlatformSqlMap.ExecuteTransationUpdate(list, null, null);
}
if (currRecord.BigData == null)
{
currRecord.BigData = new byte[0];
}
Client.ClientHelper.PlatformSqlMap.Create<PJ_ryda >(currRecord);
break;
case "edit":
if (list.Count > 0)
{
foreach (WF_TableFieldValue wfv in list)
{
WF_TableFieldValue wtfvtemp= Client.ClientHelper.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='" + wfv.FieldName + "'"
+ " and FieldId='" + wfv.FieldId + "'"
+ " and XExcelPos='" + wfv.XExcelPos + "'"
+ " and YExcelPos='" + wfv.YExcelPos + "'"
+ " and WorkTaskInsId='安规电子档案'");
if (wtfvtemp != null)
wfv.ID = wtfvtemp.ID;
else
{
Client.ClientHelper.PlatformSqlMap.Create<WF_TableFieldValue>(wfv);
}
}
Client.ClientHelper.PlatformSqlMap.ExecuteTransationUpdate(null, list, null);
}
if (currRecord.BigData == null)
{
currRecord.BigData = new byte[0];
}
Client.ClientHelper.PlatformSqlMap.Update<PJ_ryda>(currRecord);
break;
}
dsoFramerWordControl1.FileSave();
//dsoFramerWordControl1.FileClose();
rowData = currRecord;
this.DialogResult = DialogResult.OK;
}
private void LPFrm_Load(object sender, EventArgs e) {
if (tempCtrlList == null) {
tempCtrlList = new List<Control>();
}
//InitializeComponent();
if (valuehs == null)
valuehs = new Hashtable();
//InitIndex();
//InitContorl();
Excel.Workbook wb;
Excel.Worksheet sheet;
ExcelAccess ea = new ExcelAccess();
//Regex r1 = new Regex(@"(?<=" + CurrRecord.Status + ":)([^,]+)((?=,)?)");
//if (r1.Match(parentTemple.KindTable).Value != "")
//{
// activeSheetName = r1.Match(parentTemple.KindTable).Value;
//}
//int istart = parentTemple.KindTable.IndexOf(CurrRecord.Status + ":") + CurrRecord.Status.Length + 1;
//int iend = parentTemple.KindTable.IndexOf(",", istart);
//if (iend > -1)
// activeSheetName = parentTemple.KindTable.Substring(istart, iend);
//else
// activeSheetName = parentTemple.KindTable.Substring(istart);
WF_TableFieldValue wfv = null;
if (parentTemple != null) {
LP_Temple lp = MainHelper.PlatformSqlMap.GetOne<LP_Temple>(" where ParentID='" + parentTemple.LPID + "' and SortID=1");
if (lp != null) {
wfv = new WF_TableFieldValue();
wfv.ID = wfv.CreateID();
wfv.RecordId = currRecord.ID;
wfv.WorkFlowId = WorkFlowData.Rows[0]["WorkFlowId"].ToString();
wfv.WorkFlowInsId = WorkFlowData.Rows[0]["WorkFlowInsId"].ToString();
wfv.WorkTaskId = WorkFlowData.Rows[0]["WorkTaskId"].ToString();
wfv.WorkTaskInsId = WorkFlowData.Rows[0]["WorkTaskInsId"].ToString();
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 (wfv != null && wfv.Bigdata != null && wfv.Bigdata.Length > 0) {
this.dsoFramerWordControl1.FileDataGzip = wfv.Bigdata;
} else {
if (currRecord.DocContent == null) {
currRecord.DocContent = new byte[0];
}
//InitContorl();
if (currRecord.ID.IndexOf("N") == -1) {
if (GetWorkFlowNmae(kind).IndexOf("电力线路") > -1 && currRecord.DocContent != null && currRecord.DocContent.Length > 0) this.dsoFramerWordControl1.FileDataGzip = currRecord.DocContent;
else
this.dsoFramerWordControl1.FileDataGzip = currRecord.DocContent;
} else {
if (currRecord.DocContent.Length > 0) this.dsoFramerWordControl1.FileDataGzip = currRecord.DocContent;
else if (parentTemple != null) this.dsoFramerWordControl1.FileDataGzip = parentTemple.DocContent;
}
}
//if (GetWorkFlowNmae(kind).IndexOf("电力线路") > -1)
//{
// this.dsoFramerWordControl1.FileDataGzip = currRecord.DocContent;
//}
//LoadContent();
//if ((parentTemple != null && parentTemple.DocContent != null) || (currRecord!=null&&currRecord.DocContent != null && currRecord.DocContent.Length > 0))
//{
// wb = dsoFramerWordControl1.AxFramerControl.ActiveDocument as Excel.Workbook;
// //sheet = wb.Application.Sheets[activeSheetName] as Excel.Worksheet;
// //activeSheetIndex = sheet.Index;
// for (int i = 1; i <= wb.Application.Sheets.Count; i++)
// {
// sheet = wb.Application.Sheets[i] as Excel.Worksheet;
// //保护工作表
// LockExcel(wb, sheet);
// //if (i != activeSheetIndex)
// //{
// // Excel.Worksheet tmpSheet = (Excel.Worksheet)wb.Application.Sheets.get_Item(i);
// // try
// // {
// // if (tmpSheet != null) tmpSheet.Visible = Excel.XlSheetVisibility.xlSheetHidden;
// // }
// // catch { }
// }
// }
//保护工作表
// LockExcel(wb,sheet);
//}
}