private void barReChange_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) {
if (gridView1.FocusedRowHandle < 0) return;
DataRow dr = gridView1.GetDataRow(gridView1.FocusedRowHandle);
LP_Record currRecord = new LP_Record();
foreach (DataColumn dc in gridtable.Columns) {
if (dc.ColumnName != "Image") {
if (dc.DataType.FullName.IndexOf("Byte[]") < 0)
currRecord.GetType().GetProperty(dc.ColumnName).SetValue(currRecord, dr[dc.ColumnName], null);
else if (dc.DataType.FullName.IndexOf("Byte[]") > -1 && DBNull.Value != dr[dc.ColumnName] && dr[dc.ColumnName].ToString() != "")
currRecord.GetType().GetProperty(dc.ColumnName).SetValue(currRecord, dr[dc.ColumnName], null);
}
}
DataTable dt = RecordWorkTask.GetRecordWorkFlowData2(dr["ID"].ToString());
if (dt.Rows.Count > 0) {
frmWFChange fw = new frmWFChange();
fw.Text = dt.Rows[0]["FlowInsCaption"].ToString() + "流程跳转";
fw.groupBox1.Text = dt.Rows[0]["FlowInsCaption"].ToString();
fw.WorkFlowId = dt.Rows[0]["WorkFlowId"].ToString();
if (fw.ShowDialog() != DialogResult.OK)
return;
//请求确认
if (MsgBox.ShowAskMessageBox("确认更改 【" + dr["Number"].ToString() + "】状态为" + fw.WorkTaskCaption + "?") != DialogResult.OK) {
return;
}
string strmes = RecordWorkTask.RunGZPWorkFlowChange(MainHelper.User.UserID, currRecord, dt.Rows[0]["OperatorInsId"].ToString(), dt.Rows[0]["WorkTaskInsId"].ToString(), fw.WorkTaskCaption);
if (strmes.IndexOf("未提交至任何人") > -1) {
MsgBox.ShowTipMessageBox("未提交至任何人,创建失败,请检查流程模板和组织机构配置是否正确!");
return;
} else {
InitData(strSQL);
MsgBox.ShowTipMessageBox(strmes);
}
} else {
MsgBox.ShowTipMessageBox("无当前用户可以操作此记录的流程信息,延期失败!");
}
}
private void barSus_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) {
if (gridView1.FocusedRowHandle < 0) return;
DataRow dr = gridView1.GetDataRow(gridView1.FocusedRowHandle);
//请求确认
if (MsgBox.ShowAskMessageBox("是否确认 【" + dr["Number"].ToString() + "】 延期?") != DialogResult.OK) {
return;
}
LP_Record currRecord = new LP_Record();
foreach (DataColumn dc in gridtable.Columns) {
if (dc.ColumnName != "Image") {
if (dc.DataType.FullName.IndexOf("Byte[]") < 0)
currRecord.GetType().GetProperty(dc.ColumnName).SetValue(currRecord, dr[dc.ColumnName], null);
else if (dc.DataType.FullName.IndexOf("Byte[]") > -1 && DBNull.Value != dr[dc.ColumnName] && dr[dc.ColumnName].ToString() != "")
currRecord.GetType().GetProperty(dc.ColumnName).SetValue(currRecord, dr[dc.ColumnName], null);
}
}
if (currRecord.Status != "确认") {
MsgBox.ShowTipMessageBox("当前节点不能延期，延期失败!");
return;
}
DataTable dt = RecordWorkTask.GetRecordWorkFlowData(dr["ID"].ToString(), MainHelper.User.UserID);
if (dt.Rows.Count > 0) {
string strmes = RecordWorkTask.RunGZPWorkFlowChange(MainHelper.User.UserID, currRecord, dt.Rows[0]["OperatorInsId"].ToString(), dt.Rows[0]["WorkTaskInsId"].ToString(), "延期");
if (strmes.IndexOf("未提交至任何人") > -1) {
MsgBox.ShowTipMessageBox("未提交至任何人,创建失败,请检查流程模板和组织机构配置是否正确!");
return;
} else {
InitData(strSQL);
MsgBox.ShowTipMessageBox(strmes);
}
} else {
MsgBox.ShowTipMessageBox("无当前用户可以操作此记录的流程信息,延期失败!");
}
}
private void barReExport_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) {
if (gridView1.FocusedRowHandle < 0) return;
DataRow dr = gridView1.GetDataRow(gridView1.FocusedRowHandle);
LP_Record currRecord = new LP_Record();
int i = 0;
//string exploreKind = "";
foreach (DataColumn dc in gridtable.Columns) {
if (dc.ColumnName != "Image") {
if (dc.DataType.FullName.IndexOf("Byte[]") < 0)
currRecord.GetType().GetProperty(dc.ColumnName).SetValue(currRecord, dr[dc.ColumnName], null);
else if (dc.DataType.FullName.IndexOf("Byte[]") > -1 && DBNull.Value != dr[dc.ColumnName] && dr[dc.ColumnName].ToString() != "")
currRecord.GetType().GetProperty(dc.ColumnName).SetValue(currRecord, dr[dc.ColumnName], null);
}
}
DataTable dt = RecordWorkTask.GetRecordWorkFlowData(dr["ID"].ToString(), MainHelper.User.UserID);
IList<WFP_RecordWorkTaskIns> wf = MainHelper.PlatformSqlMap.GetList<WFP_RecordWorkTaskIns>("SelectWFP_RecordWorkTaskInsList", "where RecordID='" + currRecord.ID + "'");
if (currRecord.Status != "存档") {
if (dt.Rows.Count > 0) {
if (!RecordWorkTask.HaveWorkFlowAllExploreRole(dt.Rows[0]["WorkTaskId"].ToString(), dt.Rows[0]["WorkFlowId"].ToString())) {
if (!RecordWorkTask.HaveRunRecordRole(currRecord.ID, MainHelper.User.UserID)) {
MsgBox.ShowWarningMessageBox("没有运行权限，导出失败!");
return;
}
if (!RecordWorkTask.HaveWorkFlowExploreRole(dt.Rows[0]["WorkTaskId"].ToString(), dt.Rows[0]["WorkFlowId"].ToString())) {
MsgBox.ShowWarningMessageBox("没有导出权限，导出失败!");
return;
}
}
} else {
MsgBox.ShowTipMessageBox("无当前用户可以操作此记录的流程信息,导出失败!");
return;
}
}//流程没结束
else if (!RecordWorkTask.HaveFlowEndExploreRole(currRecord.Kind)) {
MsgBox.ShowTipMessageBox("流程结束后不允许导出,导出失败!");
return;
}//流程结束
if (currRecord.ID.IndexOf("N") == -1 || parentObj.FlowCaption.IndexOf("定期分析") > -1 || parentObj.FlowCaption.IndexOf("专题分析") > -1) {
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
string fname = "";
saveFileDialog1.Filter = "Microsoft Excel (*.xls)|*.xls";
if (saveFileDialog1.ShowDialog() == DialogResult.OK) {
fname = saveFileDialog1.FileName;
try {
DSOFramerControl ds1 = new DSOFramerControl();
ds1.FileDataGzip = currRecord.DocContent;
ds1.FileSave(fname, true);
ds1.FileClose();
if (MsgBox.ShowAskMessageBox("导出成功，是否打开该文档？") != DialogResult.OK)
return;
System.Diagnostics.Process.Start(fname);
} catch (Exception ex) {
Console.WriteLine(ex.Message);
MsgBox.ShowWarningMessageBox("无法保存" + fname + "。请用其他文件名保存文件，或将文件存至其他位置。");
}
}
return;
}//是旧记录
Hashtable templehs = RecordWorkTask.GetExploerLP_TempleList(dt, currRecord);
if (templehs.Count > 1) {
DataTable templedt = new DataTable();
templedt.Columns.Add("Checked", typeof(bool));
templedt.Columns.Add("Index", typeof(string));
templedt.Columns.Add("Name", typeof(string));
ArrayList akeys = new ArrayList(templehs.Keys);
for (i = 0; i < akeys.Count; i++) {
object obj = akeys[i];
DataRow templedr = templedt.NewRow();
if (obj is LP_Temple) {
WF_WorkTask wt = MainHelper.PlatformSqlMap.GetOneByKey<WF_WorkTask>(templehs[akeys[i]]);
if (wt != null) {
templedr["Name"] = wt.TaskCaption + "-申报表单";
templedr["Checked"] = 1;
templedr["Index"] = i;
templedt.Rows.Add(templedr);
}
} else if (obj is string) {
LP_Temple taskTemple = MainHelper.PlatformSqlMap.GetOneByKey<LP_Temple>(templehs[akeys[i]]);
if (taskTemple != null) {
templedr["Name"] = taskTemple.CellName;
templedr["Checked"] = 1;
templedr["Index"] = i;
templedt.Rows.Add(templedr);
}
}
}
frmExploreSelect frmes = new frmExploreSelect();
frmes.SourceDt = templedt;
if (frmes.ShowDialog() == DialogResult.OK && frmes.CheckIndehs.Count > 0) {
string fname = "";
FolderBrowserDialog fbd = new FolderBrowserDialog();
if (fbd.ShowDialog() == DialogResult.OK) {
fname = fbd.SelectedPath + "\\";
ArrayList checkkeys = new ArrayList(frmes.CheckIndehs.Keys);
for (i = 0; i < checkkeys.Count; i++) {
object obj = akeys[Convert.ToInt32(checkkeys[i])];
DSOFramerControl ds1 = new DSOFramerControl();
try {
if (obj is LP_Temple) {
ds1.FileDataGzip = ((LP_Temple)obj).DocContent;
//ds1.FileOpen(ds1.FileName);
ds1.FileSave(CheckFileName(fname + frmes.CheckIndehs[checkkeys[i]]), true);
ds1.FileClose();
} else if (obj is string) {
LP_Temple taskTemple = MainHelper.PlatformSqlMap.GetOneByKey<LP_Temple>(templehs[akeys[i]]);
if (taskTemple != null) {
RecordWorkTask.iniTableRecordData(ref taskTemple, currRecord, wf[0].WorkFlowId, wf[0].WorkFlowInsId, true);
ds1.FileDataGzip = taskTemple.DocContent;
//ds1.FileOpen(ds1.FileName);
ds1.FileSave(CheckFileName(fname + taskTemple.CellName), true);
ds1.FileClose();
}
}
} catch (Exception ex) {
Console.WriteLine(ex.Message);
MsgBox.ShowWarningMessageBox("无法保存" + frmes.CheckIndehs[checkkeys[i]] + "。请用其他文件名保存文件，或将文件存至其他位置。");
}
}//循环所有选择的表单
if (MsgBox.ShowAskMessageBox("导出成功，是否所在文件夹？") != DialogResult.OK)
return;
System.Diagnostics.Process.Start(fname);
}
}
}//表单不止一个
else {
ArrayList akeys = new ArrayList(templehs.Keys);
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
string fname = "";
saveFileDialog1.Filter = "Microsoft Excel (*.xls)|*.xls";
if (saveFileDialog1.ShowDialog() == DialogResult.OK) {
fname = saveFileDialog1.FileName;
try {
DSOFramerControl ds1 = new DSOFramerControl();
if (akeys[0] is LP_Temple) {
ds1.FileDataGzip = ((LP_Temple)akeys[0]).DocContent;
ds1.FileSave(fname, true);
ds1.FileClose();
} else if (akeys[0] is string) {
LP_Temple taskTemple = MainHelper.PlatformSqlMap.GetOneByKey<LP_Temple>(akeys[0]);
if (taskTemple != null) {
WF_WorkTaskControls wtc = MainHelper.PlatformSqlMap.GetOne<WF_WorkTaskControls>(" where WorkflowId='" + wf[0].WorkFlowId
+ "' and WorktaskId='" + wf[0].WorkTaskId + "'");
if (wtc != null) {
}
RecordWorkTask.iniTableRecordData(ref taskTemple, currRecord, wf[0].WorkFlowId, wf[0].WorkFlowInsId, true);
ds1.FileDataGzip = taskTemple.DocContent;
ds1.FileSave(fname, true);
ds1.FileClose();
}
}
if (MsgBox.ShowAskMessageBox("导出成功，是否打开该文档？") != DialogResult.OK)
return;
System.Diagnostics.Process.Start(fname);
} catch (Exception ex) {
Console.WriteLine(ex.Message);
MsgBox.ShowWarningMessageBox("无法保存" + fname + "。请用其他文件名保存文件，或将文件存至其他位置。");
return;
}
}
}
}
private void btEditfrm_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) {
if (gridView1.FocusedRowHandle < 0) {
return;
}
DataRow dr = gridView1.GetDataRow(gridView1.FocusedRowHandle);
LP_Record currRecord = new LP_Record();
foreach (DataColumn dc in gridtable.Columns) {
if (dc.ColumnName != "Image") {
if (dc.DataType.FullName.IndexOf("Byte[]") < 0)
currRecord.GetType().GetProperty(dc.ColumnName).SetValue(currRecord, dr[dc.ColumnName], null);
else if (dc.DataType.FullName.IndexOf("Byte[]") > -1 && DBNull.Value != dr[dc.ColumnName] && dr[dc.ColumnName].ToString() != "")
currRecord.GetType().GetProperty(dc.ColumnName).SetValue(currRecord, dr[dc.ColumnName], null);
}
}
DataTable dt = RecordWorkTask.GetRecordWorkFlowData(currRecord.ID, MainHelper.User.UserID);
if (!RecordWorkTask.HaveRunRecordRole(currRecord.ID, MainHelper.User.UserID)) return;
object obj = RecordWorkTask.GetWorkTaskModle(dt);
if (obj == null) {
return;
}
if (obj is frmLP) {
frmLP frm = new frmLP();
frm.Status = "edit";
frm.CurrRecord = currRecord;
frm.ParentTemple = RecordWorkTask.GetWorkTaskTemple(dt, currRecord);
if (frm.ParentTemple == null) {
MsgBox.ShowWarningMessageBox("出错，未找到该节点关联的表单，请检查模板设置!");
//return;
}
frm.Kind = strKind;
frm.RecordWorkFlowData = dt;
if (frm.ShowDialog() == DialogResult.OK) {
InitData(strSQL);
}
} else {
if (obj.GetType().GetProperty("IsWorkflowCall") != null)
obj.GetType().GetProperty("IsWorkflowCall").SetValue(obj, true, null);
else {
MsgBox.ShowWarningMessageBox("模块不支持，请咨询开发人员!");
return;
}
if (obj.GetType().GetProperty("CurrRecord") != null)
obj.GetType().GetProperty("CurrRecord").SetValue(obj, currRecord, null);
else {
MsgBox.ShowWarningMessageBox("模块不支持，请咨询开发人员!");
return;
}
if (obj.GetType().GetProperty("RecordWorkFlowData") != null)
obj.GetType().GetProperty("RecordWorkFlowData").SetValue(obj, dt, null);
else {
MsgBox.ShowWarningMessageBox("模块不支持，请咨询开发人员!");
return;
}
if (obj.GetType().GetProperty("ParentTemple") != null)
obj.GetType().GetProperty("ParentTemple").SetValue(obj, RecordWorkTask.GetWorkTaskTemple(dt, currRecord), null);
else {
MsgBox.ShowWarningMessageBox("模块不支持，请咨询开发人员!");
return;
}
if (obj is UserControl) {
FormBase dlg = new FormBase();
dlg.Text = ((UserControl)obj).Name;
dlg.MdiParent = MainHelper.MainForm;
dlg.Controls.Add((UserControl)obj);
((UserControl)obj).Dock = DockStyle.Fill;
dlg.Show();
} else
if (obj is Form) {
if (obj is frmyxfxWorkFlowEdit) {
IList<WF_ModleRecordWorkTaskIns> li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + currRecord.ID + "'"
+ " and WorkFlowId='" + dt.Rows[0]["WorkFlowId"].ToString() + "'"
+ " and WorkFlowInsId='" + dt.Rows[0]["WorkFlowInsId"].ToString() + "' order by CreatTime desc");
PJ_03yxfx yxfx = new PJ_03yxfx();
if (li.Count > 0) {
yxfx = MainHelper.PlatformSqlMap.GetOneByKey<PJ_03yxfx>(li[0].ModleRecordID);
} else {
yxfx = new PJ_03yxfx();
yxfx.OrgCode = MainHelper.UserOrg.OrgCode;
yxfx.OrgName = MainHelper.UserOrg.OrgName;
if (parentObj.FlowCaption.IndexOf("定期分析") > 0)
yxfx.type = "定期分析";
else
if (parentObj.FlowCaption.IndexOf("专题分析") > 0)
yxfx.type = "专题分析";
((frmyxfxWorkFlowEdit)obj).RecordStatus = 0;
yxfx.rq = DateTime.Now;
((frmyxfxWorkFlowEdit)obj).RowData = yxfx;
}
switch (dt.Rows[0]["TaskInsCaption"].ToString()) {
case "填写":
((frmyxfxWorkFlowEdit)obj).RecordStatus = 0;
break;
case "领导检查":
((frmyxfxWorkFlowEdit)obj).RecordStatus = 1;
break;
case "检查人检查":
((frmyxfxWorkFlowEdit)obj).RecordStatus = 2;
break;
}
yxfx.rq = DateTime.Now;
((frmyxfxWorkFlowEdit)obj).RowData = yxfx;
} else if (obj is frmsbqxWorkFlowEdit) {
IList<WF_ModleRecordWorkTaskIns> li = MainHelper.PlatformSqlMap.GetListByWhere<WF_ModleRecordWorkTaskIns>(" where RecordID='" + currRecord.ID + "'"
+ " and WorkFlowId='" + dt.Rows[0]["WorkFlowId"].ToString() + "'"
+ " and WorkFlowInsId='" + dt.Rows[0]["WorkFlowInsId"].ToString() + "' order by CreatTime desc");
PJ_qxfl qxfl = new PJ_qxfl();
if (li.Count > 0) {
qxfl = MainHelper.PlatformSqlMap.GetOneByKey<PJ_qxfl>(li[0].ModleRecordID);
} else {
qxfl = new PJ_qxfl();
qxfl.OrgCode = MainHelper.UserOrg.OrgCode;
qxfl.OrgName = MainHelper.UserOrg.OrgName;
}
((frmsbqxWorkFlowEdit)obj).RowData = qxfl;
}
((Form)obj).ShowDialog();
}
InitData(strSQL);
}
//获得编辑按钮的状态
this.btEditfrm.Caption = currRecord.Status;
}
private void barBack_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) {
if (gridView1.FocusedRowHandle < 0) return;
DataRow dr = gridView1.GetDataRow(gridView1.FocusedRowHandle);
//请求确认
if (MsgBox.ShowAskMessageBox("是否确认退回 【" + dr["Number"].ToString() + "】?") != DialogResult.OK) {
return;
}
LP_Record currRecord = new LP_Record();
foreach (DataColumn dc in gridtable.Columns) {
if (dc.ColumnName != "Image") {
if (dc.DataType.FullName.IndexOf("Byte[]") < 0)
currRecord.GetType().GetProperty(dc.ColumnName).SetValue(currRecord, dr[dc.ColumnName], null);
else if (dc.DataType.FullName.IndexOf("Byte[]") > -1 && DBNull.Value != dr[dc.ColumnName] && dr[dc.ColumnName].ToString() != "")
currRecord.GetType().GetProperty(dc.ColumnName).SetValue(currRecord, dr[dc.ColumnName], null);
}
}
DataTable dt = RecordWorkTask.GetRecordWorkFlowData(dr["ID"].ToString(), MainHelper.User.UserID);
if (dt.Rows.Count > 0) {
if (!RecordWorkTask.HaveWorkFlowBackRole(dt.Rows[0]["WorkTaskId"].ToString(), dt.Rows[0]["WorkFlowId"].ToString())) {
MsgBox.ShowWarningMessageBox("当前节点不能退回.设置里没有允许退回，退回失败!");
return;
}
if (RecordWorkTask.CheckOnRiZhi(dt)) {
RecordWorkTask.CreatRiZhi(dt, null, currRecord.ID, new object[] { currRecord });
}
string strmes = RecordWorkTask.RunWorkFlowBack(MainHelper.User.UserID, dt.Rows[0]["OperatorInsId"].ToString(), dt.Rows[0]["WorkTaskInsId"].ToString());
if (strmes.IndexOf("未提交至任何人") > -1) {
MsgBox.ShowTipMessageBox("未提交至任何人,创建失败,请检查流程模板和组织机构配置是否正确!");
return;
} else {
currRecord.LastChangeTime = DateTime.Now.ToString();
currRecord.Status = RecordWorkTask.GetWorkFlowTaskCaption(dt.Rows[0]["WorkTaskInsId"].ToString());
if (currRecord.ImageAttachment == null) currRecord.ImageAttachment = new byte[0];
if (currRecord.SignImg == null) currRecord.SignImg = new byte[0];
MainHelper.PlatformSqlMap.Update("UpdateLP_Record", currRecord);
InitData(strSQL);
MsgBox.ShowTipMessageBox(strmes);
}
this.btEditfrm.Caption = currRecord.Status;
} else {
MsgBox.ShowTipMessageBox("无当前用户可以操作此记录的流程信息,退回失败!");
}
}
private void barView_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (gridView1.FocusedRowHandle < 0) return;
frmTemplate fm = new frmTemplate();
LP_Record currRecord = new LP_Record();
DataRow dr = gridView1.GetDataRow(gridView1.FocusedRowHandle);
DataTable dt = RecordWorkTask.GetRecordWorkFlowData2(dr["ID"].ToString());
fm.RecordWorkFlowData = dt;
foreach (DataColumn dc in gridtable.Columns)
{
if (dc.ColumnName != "Image")
{
if (dc.DataType.FullName.IndexOf("Byte[]") < 0)
currRecord.GetType().GetProperty(dc.ColumnName).SetValue(currRecord, dr[dc.ColumnName], null);
else if (dc.DataType.FullName.IndexOf("Byte[]") > -1 && DBNull.Value != dr[dc.ColumnName] && dr[dc.ColumnName].ToString() != "")
currRecord.GetType().GetProperty(dc.ColumnName).SetValue(currRecord, dr[dc.ColumnName], null);
}
}
fm.ParentTemple = ParentObj;
fm.pjobject = currRecord;
fm.ShowDialog();
InitData(parentObj.Kind);
}
private void barReExport_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (gridView1.FocusedRowHandle < 0) return;
DataRow dr = gridView1.GetDataRow(gridView1.FocusedRowHandle);
LP_Record currRecord = new LP_Record();
foreach (DataColumn dc in gridtable.Columns)
{
if (dc.ColumnName != "Image")
{
if (dc.DataType.FullName.IndexOf("Byte[]") < 0)
currRecord.GetType().GetProperty(dc.ColumnName).SetValue(currRecord, dr[dc.ColumnName], null);
else if (dc.DataType.FullName.IndexOf("Byte[]") > -1 && DBNull.Value != dr[dc.ColumnName] && dr[dc.ColumnName].ToString() != "")
currRecord.GetType().GetProperty(dc.ColumnName).SetValue(currRecord, dr[dc.ColumnName], null);
}
}
if (currRecord.ID.IndexOf("N") > -1)
{
MsgBox.ShowTipMessageBox("此记录由新模块创建，请使用新模块操作!");
return;
}
if (currRecord.Status != "存档")
{
MsgBox.ShowTipMessageBox("安监未审核,不能导出!");
return;
}
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
string fname = "";
saveFileDialog1.Filter = "Microsoft Excel (*.xls)|*.xls";
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
fname = saveFileDialog1.FileName;
try
{
DSOFramerControl ds1 = new DSOFramerControl();
ds1.FileDataGzip = currRecord.DocContent ;
//ds1.FileOpen(ds1.FileName);
ds1.FileSave(fname,true);
ds1.FileClose();
ExcelAccess ea = new ExcelAccess();
ea.Open(fname);
char pchar = '|';
Excel.Workbook wb = ds1.AxFramerControl.ActiveDocument as Excel.Workbook;
Excel.Worksheet xx = wb.Application.Sheets[1] as Excel.Worksheet;
IList<LP_Temple> templeList = MainHelper.PlatformSqlMap.GetList<LP_Temple>("SelectLP_TempleList", "where ParentID ='" + ParentObj.LPID + "' and isExplorer='1' Order by SortID");
LockExcel(ea);
unLockExcel(ea);
foreach (LP_Temple lp in templeList)
{
string[] arrCellpos = lp.CellPos.Split(pchar);
for (int i = 0; i < arrCellpos.Length && arrCellpos[i] != ""; i++)
{
ea.SetCellValue("", GetCellPos(arrCellpos[i])[0], GetCellPos(arrCellpos[i])[1]);
}
}
ea.ShowExcel();
ds1.FileClose();
ds1.Dispose ();
}
catch(Exception ex)
{
Console.WriteLine(ex.Message );
MsgBox.ShowWarningMessageBox ("无法保存" + fname + "。请用其他文件名保存文件，或将文件存至其他位置。");
return;
}
}
}
private void btEditfrm_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (gridView1.FocusedRowHandle<0)
{
return;
}
frmLP frm = new frmLP();
frm.Status = "edit";
frm.ParentTemple = ParentObj;
frm.Kind = ParentObj.Kind;
DataRow dr = gridView1.GetDataRow(gridView1.FocusedRowHandle);
LP_Record currRecord = new LP_Record();
foreach (DataColumn dc in gridtable.Columns)
{
if (dc.ColumnName != "Image")
{
if (dc.DataType.FullName.IndexOf("Byte[]") < 0)
currRecord.GetType().GetProperty(dc.ColumnName).SetValue(currRecord, dr[dc.ColumnName], null);
else if (dc.DataType.FullName.IndexOf("Byte[]") > -1 && DBNull.Value != dr[dc.ColumnName] && dr[dc.ColumnName].ToString() != "")
currRecord.GetType().GetProperty(dc.ColumnName).SetValue(currRecord, dr[dc.ColumnName], null);
}
}
frm.CurrRecord = currRecord;
if (currRecord.ID.IndexOf("N") > -1)
{
MsgBox.ShowWarningMessageBox("此记录由新模块创建，请使用新模块操作!");
return;
}
if (!RecordWorkTask.HaveRunRecordRole(currRecord.ID, MainHelper.User.UserID)) return;
DataTable dt = RecordWorkTask.GetRecordWorkFlowData(currRecord.ID, MainHelper.User.UserID);
frm.RecordWorkFlowData = dt;
if (frm.ShowDialog() == DialogResult.OK)
{
InitData(ParentObj.Kind);
}
}
private void btDeletefrm_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (MainHelper.UserOrg == null) return;
if (gridView1.FocusedRowHandle < 0) return;
DataRow dr = gridView1.GetDataRow(gridView1.FocusedRowHandle);
LP_Record currRecord = new LP_Record();
foreach (DataColumn dc in gridtable.Columns)
{
if (dc.ColumnName != "Image")
{
if (dc.DataType.FullName.IndexOf("Byte[]") < 0)
currRecord.GetType().GetProperty(dc.ColumnName).SetValue(currRecord, dr[dc.ColumnName], null);
else if (dc.DataType.FullName.IndexOf("Byte[]") > -1 && DBNull.Value != dr[dc.ColumnName] && dr[dc.ColumnName].ToString() != "")
currRecord.GetType().GetProperty(dc.ColumnName).SetValue(currRecord, dr[dc.ColumnName], null);
}
}
currRecord = MainHelper.PlatformSqlMap.GetOneByKey<LP_Record>(currRecord.ID);
if (currRecord.ImageAttachment == null) currRecord.ImageAttachment = new byte[0];
if (currRecord.SignImg == null) currRecord.SignImg = new byte[0];
if (currRecord.DocContent == null) currRecord.DocContent = new byte[0];
if (currRecord.OrgName != MainHelper.User.OrgName && MainHelper.User.OrgName != "局领导")
{
MsgBox.ShowWarningMessageBox("删除出错,不是本单位的记录，无权删除！");
return;
}
//请求确认
if (MsgBox.ShowAskMessageBox("是否确认删除 【" + dr["Number"].ToString() + "】?") != DialogResult.OK)
{
return;
}
try
{
RecordWorkTask.DeleteRecord(dr["ID"].ToString());
MainHelper.PlatformSqlMap.DeleteByWhere<LP_Record>(" where id ='" + dr["ID"].ToString() + "'");
InitData(strKind);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
private void btEditfrm_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (gridView1.FocusedRowHandle < 0)
{
return;
}
DataRow dr = gridView1.GetDataRow(gridView1.FocusedRowHandle);
LP_Record currRecord = new LP_Record();
foreach (DataColumn dc in gridtable.Columns)
{
if (dc.ColumnName != "Image")
{
if (dc.DataType.FullName.IndexOf("Byte[]") < 0)
currRecord.GetType().GetProperty(dc.ColumnName).SetValue(currRecord, dr[dc.ColumnName], null);
else if (dc.DataType.FullName.IndexOf("Byte[]") > -1 && DBNull.Value != dr[dc.ColumnName] && dr[dc.ColumnName].ToString() != "")
currRecord.GetType().GetProperty(dc.ColumnName).SetValue(currRecord, dr[dc.ColumnName], null);
}
}
currRecord = MainHelper.PlatformSqlMap.GetOneByKey<LP_Record>(currRecord.ID);
if (currRecord.ImageAttachment == null) currRecord.ImageAttachment = new byte[0];
if (currRecord.SignImg == null) currRecord.SignImg = new byte[0];
if (currRecord.DocContent == null) currRecord.DocContent = new byte[0];
workFlowFormShow(currRecord);
}
