void cmdDownload_Click(object sender, Janus.Windows.UI.CommandBars.CommandEventArgs e)
{
if (this.tvTask.SelectedNode != null)
{
XTaskFilesInfo model = this.tvTask.SelectedNode.Tag as XTaskFilesInfo;
string mainId = model.RID;
bool isExist = this.m_FileAttachBusiness.IsFileExist(mainId);
if (!isExist)
{
XMessageBox.ShowError("未找到附件！");
return;
}
FolderBrowserDialog fbd = new FolderBrowserDialog();
if (fbd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
string fileName = this.m_FileAttachBusiness.DownloadFile(mainId, fbd.SelectedPath);
if (fileName != string.Empty)
{
XMessageBox.ShowRemindMessage("下载完成！");
}
else
{
XMessageBox.ShowError("下载失败！");
}
}
}
else
{
XMessageBox.ShowError("请选择要下载附件的记录！");
}
}
protected virtual bool ValidateDeleteCommon()
{
if (this.treeView.SelectedNode == null)
{
XMessageBox.ShowError("请选择要删除的节点！");
return(false);
}
XModelBase model = this.treeView.SelectedNode.Tag as XModelBase;
if (this.m_Business.IsEndNode(model))
{
XMessageBox.ShowError("该节点下有子节点，删除前需要先删除子节点！");
return(false);
}
if (this.m_Business.IsUsed(model.ID))
{
return(false);
}
if (XMessageBox.ShowQuestion("确定要删除选中的记录吗？") == System.Windows.Forms.DialogResult.No)
{
return(false);
}
return(true);
}
/// <summary>
/// 自定义UI校验
/// </summary>
/// <returns></returns>
protected override bool ValidateCustom()
{
IList <XModelBase> standFiles = this.grdFiles.DataSource as IList <XModelBase>;
int maxVersionCount = 0;
if (standFiles.Count > 0)
{
foreach (XStandFilesInfo standFile in standFiles)
{
if (standFile.IsMaxVersion)
{
maxVersionCount += 1;
}
}
}
if (maxVersionCount > 1)
{
XMessageBox.ShowError("只能有一个文件集是最新版本！");
return(false);
}
return(true);
}
private void btnExport_Click(object sender, EventArgs e)
{
try
{
SaveFileDialog sfd = new SaveFileDialog();
sfd.Filter = "Excel文件(*.xls)|*.xls";
if (sfd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
this.grdExporter.SheetName = this.Text;
//this.grdData.RootTable.Columns["select"].Visible = false;
System.IO.Stream stream = new System.IO.FileStream(sfd.FileName, System.IO.FileMode.CreateNew);
this.grdExporter.Export(stream);
stream.Close();
//this.grdData.RootTable.Columns["select"].Visible = true;
XMessageBox.ShowRemindMessage("导出完成!");
}
}
catch (Exception ex)
{
XErrorLogTool.WriteLog(ex.ToString());
XMessageBox.ShowError("导出失败!");
}
finally
{
//this.grdData.RootTable.Columns["select"].Visible = true;
}
}
/// <summary>
/// 修改明细
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected virtual void btnEditDetail_Click(object sender, EventArgs e)
{
XButton btnEdit = sender as XButton;
XGridEx gridEx = this.FindDetailGridEx(btnEdit.Parent as Janus.Windows.UI.Tab.UITabPage);
XModelBase currentModel = this.GetCurrentModel(gridEx);
if (currentModel == null)
{
XMessageBox.ShowError("请选择要修改的记录！");
return;
}
frmEditBase frm = this.GetEditDetailForm(sender, currentModel);
if (frm != null)
{
if (frm.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
gridEx.Refresh();
}
}
else
{
XMessageBox.ShowError("未实现修改窗体方法！");
}
}
/// <summary>
/// 自定义UI校验
/// </summary>
/// <returns></returns>
protected override bool ValidateCustom()
{
bool isValidateExist = false;
string equipmentNo = this.txtEquipmentNo.Text.Trim();
if (this.m_EditStatus == XEditStatus.AddNew)
{
isValidateExist = true;
}
else if (this.m_OldEquipmentNo != equipmentNo)
{
isValidateExist = true;
}
if (isValidateExist)
{
if (this.m_EquipmentCheckBusiness.IsEquipmentNoExist(equipmentNo))
{
XMessageBox.ShowError("设备编号已存在！");
return(false);
}
}
return(true);
}
/// <summary>
/// 执行Sql语句
/// </summary>
/// <param name="sql"></param>
/// <returns>执行失败则返回0或者-1</returns>
public virtual int ExecuteNonQueryByTrans(string sql)
{
DbTransaction trans = null;
try
{
if (this.m_Connection.State == ConnectionState.Closed)
{
this.m_Connection.Open();
}
trans = this.m_Connection.BeginTransaction();
DbCommand command = this.GetDbCommand();
command.Transaction = trans;
command.CommandText = sql;
command.Connection = this.m_Connection;
int result = command.ExecuteNonQuery();
trans.Commit();
return(result);
}
catch (Exception ex)
{
XMessageBox.ShowError(ex.ToString());
XErrorLogTool.WriteLog(ex.ToString());
trans.Rollback();
return(-1);
}
finally
{
if (this.m_Connection.State == ConnectionState.Open)
{
this.m_Connection.Close();
}
}
}
protected virtual bool ValidateTreeDeleteCommon()
{
if (this.treeView.SelectedNode == null)
{
XMessageBox.ShowError("请选择要删除的节点！");
return(false);
}
if (this.treeView.SelectedNode.Tag == null)
{
return(false);
}
XModelBase model = this.treeView.SelectedNode.Tag as XModelBase;
if (!this.m_TreeBusiness.IsEndModel(model))
{
XMessageBox.ShowError("该文件夹下有子文件夹，不能删除！");
return(false);
}
if (XMessageBox.ShowQuestion("确定要删除选中的节点吗？") == System.Windows.Forms.DialogResult.No)
{
return(false);
}
return(true);
}
private void EditFiles()
{
if (this.grdFiles.CurrentRow == null ||
this.grdFiles.CurrentRow.RowType != Janus.Windows.GridEX.RowType.Record)
{
XMessageBox.ShowError("请选择要编辑的记录！");
return;
}
XModelBase currentModel = this.grdFiles.CurrentRow.DataRow as XModelBase;
XTaskFilesInfo taskFileInfo = currentModel as XTaskFilesInfo;
if (taskFileInfo.InputUserId != XCommon.LoginUsersInfo.RID)
{
XMessageBox.ShowError("不能修改非本人提交的任务文档！");
return;
}
frmTaskFilesEdit frm = new frmTaskFilesEdit(currentModel);
if (frm.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
this.grdFiles.Refresh();
}
}
/// <summary>
/// 获得执行结果第一行第一列的值
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public virtual object ExecuteScalar(string sql)
{
try
{
if (this.m_Connection.State == ConnectionState.Closed)
{
this.m_Connection.Open();
}
DbCommand command = this.GetDbCommand();
command.Connection = this.m_Connection;
command.CommandText = sql;
return(command.ExecuteScalar());
}
catch (Exception ex)
{
XMessageBox.ShowError(ex.Message);
XErrorLogTool.WriteLog(ex.ToString());
return(null);
}
finally
{
if (this.m_Connection != null && this.m_Connection.State == ConnectionState.Closed)
{
this.m_Connection.Close();
}
}
}
private void AddFiles()
{
TreeNode selectedNode = this.tvTask.SelectedNode;
if (!this.IsChildTaskNode(selectedNode))
{
XMessageBox.ShowError("请选择要提交文档的子任务！");
return;
}
IList <XModelBase> gridList = this.grdFiles.DataSource as IList <XModelBase>;
XTaskInfo taskInfo = selectedNode.Tag as XTaskInfo;
if (taskInfo.AssignPeople != XCommon.LoginUsersInfo.RID)
{
XMessageBox.ShowError("当前登录人不是任务负责人，不能提交文档！");
return;
}
frmTaskFilesEdit frm = new frmTaskFilesEdit(gridList, selectedNode);
if (frm.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
this.grdFiles.DataSource = null;
this.grdFiles.DataSource = frm.ModelList;
this.grdFiles.Refresh();
}
}
/// <summary>
/// 菜单单击事件
/// </summary>
/// <param name="menuInfo"></param>
/// <param name="e"></param>
protected virtual void menuFolderTool_MenuClickEvent(XMenuInfo menuInfo, EventArgs e)
{
try
{
frmBase frm = Assembly.Load(menuInfo.NameSpace).CreateInstance(menuInfo.FullAssembleName) as frmBase;
if (frm == null)
{
XMessageBox.ShowError("该功能未实现或者实现的接口不正确！");
return;
}
if (menuInfo.IsDialogModel)
{
frm.StartPosition = FormStartPosition.CenterParent;
frm.ShowDialog();
}
else
{
this.ShowTabbedMdi(frm);
}
}
catch (Exception ex)
{
XMessageBox.ShowError(ex.Message);
XErrorLogTool.WriteLog(ex.ToString());
}
}
void cmdFinishTask_Click(object sender, Janus.Windows.UI.CommandBars.CommandEventArgs e)
{
TreeNode selectedNode = this.tvTask.SelectedNode;
if (selectedNode == null)
{
XMessageBox.ShowError("请选择要结束的任务！");
return;
}
XTaskInfo taskInfo = selectedNode.Tag as XTaskInfo;
if (taskInfo == null)
{
XMessageBox.ShowError("请选择要结束的任务！");
return;
}
if (XMessageBox.ShowQuestion("确定要结束选中的任务吗？") == System.Windows.Forms.DialogResult.No)
{
return;
}
if (this.m_TaskBusiness.UpdateTaskStatus("结束", taskInfo.ID))
{
XMessageBox.ShowRemindMessage("结束任务成功！");
}
else
{
XMessageBox.ShowError("结束任务失败！");
}
}
/// <summary>
/// 校验删除记录
/// </summary>
/// <returns></returns>
protected virtual bool ValidateDelete()
{
int selectedCount = 0;
this.m_SelectedModels.Clear();
foreach (GridEXRow gridRow in this.grdDetail.GetRows())
{
if (gridRow.IsChecked)
{
selectedCount += 1;
XModelBase currentModel = gridRow.DataRow as XModelBase;
this.m_SelectedModels.Add(currentModel);
}
}
if (selectedCount == 0)
{
XMessageBox.ShowError("请选择要删除的记录！");
return(false);
}
if (XMessageBox.ShowQuestion("确定要删除选中的记录吗？") == System.Windows.Forms.DialogResult.No)
{
return(false);
}
return(true);
}
/// <summary>
/// 自定义UI校验
/// </summary>
/// <returns></returns>
protected override bool ValidateCustom()
{
bool isValidateExist = false;
string userId = this.txtUserId.ValueMember;
if (userId != string.Empty)
{
if (this.m_EditStatus == XEditStatus.AddNew)
{
isValidateExist = true;
}
else if (this.m_EditStatus == XEditStatus.Edit)
{
if (this.m_OldUserId != this.txtUserId.ValueMember)
{
isValidateExist = true;
}
}
if (isValidateExist)
{
XStaffInfoBusiness business = this.m_Business as XStaffInfoBusiness;
if (business.IsUserIdHaveStaff(userId))
{
XMessageBox.ShowError("该关联用户已经关联其他人员信息！");
return(false);
}
}
}
return(true);
}
protected override bool ValidataForm()
{
if (this.txtPassword.Text.Trim() != this.txtRepass.Text.Trim())
{
XMessageBox.ShowError("两次输入的密码不一致！");
return(false);
}
return(true);
}
protected virtual bool ValidateAddCommon()
{
if (this.grdData.CurrentRow == null || this.grdData.CurrentRow.RowType != Janus.Windows.GridEX.RowType.Record)
{
XMessageBox.ShowError("请选择要添加明细的主表记录！");
return(false);
}
return(true);
}
/// <summary>
/// 修改前校验
/// </summary>
/// <returns></returns>
protected virtual bool ValidateBeforeEdit()
{
if (this.treeView.SelectedNode == null)
{
XMessageBox.ShowError("请选择要修改的节点！");
return(false);
}
return(true);
}
public bool InsertCustom(XModelBase model)
{
DbConnection sqlConn = this.m_DataAccess.Connection;
DbTransaction trans = null;
try
{
if (sqlConn.State == ConnectionState.Closed)
{
sqlConn.Open();
}
trans = sqlConn.BeginTransaction();
string sql = this.GetInsertSql(model) + ";";
XVTaskFilesInfo taskFilesInfo = model as XVTaskFilesInfo;
//更新任务状态为结束
sql += "UPDATE Task SET TaskStatus='结束' WHERE RID='" + taskFilesInfo.MainId + "';";
if (taskFilesInfo.FileFullName != string.Empty)
{
//上传附件
DbCommand fileCommand = this.GetFileCommand(taskFilesInfo);
fileCommand.Connection = sqlConn;
fileCommand.Transaction = trans;
DbDataReader reader = fileCommand.ExecuteReader();
reader.Close();
}
DbCommand cmd = this.m_DataAccess.GetDbCommand();
cmd.Connection = sqlConn;
cmd.CommandText = sql;
cmd.Transaction = trans;
bool isSuccess = cmd.ExecuteNonQuery() > 0;
trans.Commit();
return(isSuccess);
}
catch (Exception ex)
{
XMessageBox.ShowError(ex.Message);
XErrorLogTool.WriteLog(ex.ToString());
trans.Rollback();
}
finally
{
if (sqlConn.State == ConnectionState.Open)
{
sqlConn.Close();
}
}
return(false);
}
/// <summary>
/// 自定义UI校验
/// </summary>
/// <returns></returns>
protected override bool ValidateCustom()
{
if (this.m_EditStatus == XEditStatus.AddNew)
{
if (this.txtPassWord.Text.Trim() != this.txtRepass.Text.Trim())
{
XMessageBox.ShowError("两次密码输入的不一致!");
return(false);
}
}
bool isValidateExist = false;
if (this.m_EditStatus == XEditStatus.AddNew)
{
isValidateExist = true;
}
else if (this.m_EditStatus == XEditStatus.Edit)
{
if (this.m_OldUserName != this.txtUserName.Text.Trim())
{
isValidateExist = true;
}
}
if (isValidateExist)
{
if (this.m_Business.IsExist(this.txtUserName.Text.Trim()))
{
XMessageBox.ShowError("用户名已存在！");
return(false);
}
}
bool isValidateRealNameExist = false;
if (this.m_EditStatus == XEditStatus.AddNew)
{
isValidateRealNameExist = true;
}
else if (this.m_EditStatus == XEditStatus.Edit)
{
if (this.m_OldRealName != this.txtRealName.Text.Trim())
{
isValidateRealNameExist = true;
}
}
if (isValidateRealNameExist && this.m_UsersBusiness.IsRealNameExist(this.txtRealName.Text.Trim()))
{
XMessageBox.ShowError("真实姓名已存在！");
return(false);
}
return(true);
}
protected override bool ValidateEditCustom()
{
if (this.m_Business.IsCheck(this.m_CurrentModel))
{
XMessageBox.ShowError("要修改的记录已审核，不能修改！");
return(false);
}
return(true);
}
protected virtual bool ValidateImportCommon()
{
if (this.grdData.RowCount == 0)
{
XMessageBox.ShowError("没有要导入的记录！");
return(false);
}
return(true);
}
public static bool Preview(string fileId)
{
string where = " and FileId='" + fileId + "'";
IList <XModelBase> fileAttachInfos = m_FileAttachBusiness.QueryByWhere(where);
if (fileAttachInfos.Count == 0)
{
XMessageBox.ShowError("未找到附件，无法预览！");
return(false);
}
XFileAttachmentInfo fileInfo = fileAttachInfos[0] as XFileAttachmentInfo;
string[] imageTypes = new string[] { ".png", ".jpg", ".jpeg" };
string[] officeTypes = new string[] { ".doc", ".docx", ".xls", ".xlsx" };
if (!imageTypes.Contains(fileInfo.AtchType) &&
!officeTypes.Contains(fileInfo.AtchType))
{
XMessageBox.ShowError("不支持预览格式为[" + fileInfo.AtchType + "]的文件！");
return(false);
}
string path = XCommon.TempPath;
string fileName = Guid.NewGuid().ToString();
fileName = m_FileAttachBusiness.DownLoadFile(fileId, path, fileName);
if (imageTypes.Contains(fileInfo.AtchType))
{
//如果是图片
frmImagePreview frm = new frmImagePreview(fileName);
frm.ShowDialog();
}
else
{
frmOfficeFilePreview frm = new frmOfficeFilePreview(fileName);
frm.ShowDialog();
}
if (File.Exists(fileName))
{
try
{
File.Delete(fileName);
}
catch (Exception ex)
{
XErrorLogTool.WriteLog(ex.ToString());
}
}
return(true);
}
private void btnLogin_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
XUsersBusiness usersBusiness = new XUsersBusiness();
//if (usersBusiness.GetServerTime() >= new DateTime(2014, 2, 28))
//{
// XMessageBox.ShowError("出现异常，无法登录！");
// return;
//}
if (this.ValidateLogin())
{
this.m_UserInfo = this.GetLoginUsersInfo();
if (this.m_UserInfo == null)
{
XMessageBox.ShowError("用户名或者密码错误！");
return;
}
if (this.m_UserInfo.IsUsed == false)
{
XMessageBox.ShowError("该用户不可用！");
return;
}
XCommon.LoginUsersInfo = this.m_UserInfo.Clone() as XUsersInfo;
if (this.m_UserInfo != null)
{
this.DialogResult = System.Windows.Forms.DialogResult.OK;
try
{
this.LoginLog();
}
catch (Exception ex)
{
XErrorLogTool.WriteLog(ex.ToString());
}
}
this.RememberLoginUser();
}
}
catch (Exception ex)
{
XMessageBox.ShowError(ex.Message);
XErrorLogTool.WriteLog(ex.ToString());
}
finally
{
this.Cursor = Cursors.Default;
}
}
private void Preview()
{
try
{
this.fcWord.Open(m_FileName);
}
catch (Exception ex)
{
XMessageBox.ShowError(ex.Message);
XErrorLogTool.WriteLog(ex.ToString());
}
}
/// <summary>
/// 公共校验
/// </summary>
/// <returns></returns>
protected virtual bool ValidateCommon()
{
if (this.m_EditStatus == XEditStatus.AddNew && this.chkRootNode.Checked == false)
{
if (this.treeView.SelectedNode == null)
{
XMessageBox.ShowError("请选择父节点！");
return(false);
}
}
return(true);
}
protected virtual bool ValidateEditDetailCommon()
{
if (this.grdDetail.CurrentRow == null || this.grdDetail.CurrentRow.RowType != Janus.Windows.GridEX.RowType.Record)
{
XMessageBox.ShowError("请选择要修改的明细记录！");
return(false);
}
m_CurrentDetailModel = this.grdDetail.CurrentRow.DataRow as XModelBase;
return(true);
}
/// <summary>
/// 自定义UI校验
/// </summary>
/// <returns></returns>
protected override bool ValidateCustom()
{
if (this.m_EditStatus == XEditStatus.AddNew)
{
if (this.txtFilePath.Text.Trim() == string.Empty)
{
XMessageBox.ShowError("文档路径不能为空！");
return(false);
}
}
return(true);
}
protected virtual bool ValidateEditDetail()
{
if (this.grdDetail.CurrentRow != null && this.grdDetail.CurrentRow.RowType == Janus.Windows.GridEX.RowType.Record)
{
this.m_CurrentDetailModel = this.grdDetail.CurrentRow.DataRow as XModelBase;
}
if (this.m_CurrentDetailModel == null)
{
XMessageBox.ShowError("请选择要修改的记录！");
return(false);
}
return(true);
}
private void Preview()
{
try
{
Image image = Image.FromFile(this.m_FileName);
this.picFile.BackgroundImage = image;
}
catch (Exception ex)
{
XMessageBox.ShowError(ex.Message);
XErrorLogTool.WriteLog(ex.ToString());
}
}
