/// <summary>
/// 获取修改时插入历史表的sql
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
protected override string GetInsertUpdateHistorySql(XModelBase modelInfo)
{
XTaskFilesInfo info = modelInfo as XTaskFilesInfo;
string sql = "Insert Into " + this.HistoryTableName + "(RID,MainId,FileName,FileDesc,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime,OperateUserId,Operate,OperateTime,NewID) SELECT RID,MainId,FileName,FileDesc,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime,'" + info.UpdateUserId + "','修改',getdate(),newid() FROM " + this.TableName + " WHERE " + this.PrimaryKey + "='" + info.RID + "'";
return(sql);
}
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();
}
}
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("请选择要下载附件的记录！");
}
}
/// <summary>
/// 获取插入sql
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
public override string GetInsertSql(XModelBase modelInfo)
{
XTaskFilesInfo info = modelInfo as XTaskFilesInfo;
string sql = "Insert Into " + this.TableName + "(RID,MainId,FileName,FileDesc,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime)Values('{0}','{1}','{2}','{3}','{4}','{5}',{6},'{7}',{8})";
sql = String.Format(sql, info.RID, info.MainId, info.FileName, info.FileDesc, info.Remark, info.InputUserId, this.GetServerTimeFuncion(), info.UpdateUserId, this.GetServerTimeFuncion());
return(sql);
}
/// <summary>
/// 自定义修改校验
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
protected override string GetValidateUpdateCustom(XModelBase modelInfo)
{
string validateInfo = string.Empty;
XTaskFilesInfo taskfiles = modelInfo as XTaskFilesInfo;
if (taskfiles == null)
{
return(this.GetNotRightType());
}
return(string.Empty);
}
/// <summary>
/// 获取更新Sql
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
public override string GetUpdateSql(XModelBase modelInfo)
{
string sql = String.Empty;
XTaskFilesInfo info = modelInfo as XTaskFilesInfo;
sql = "Update " + this.TableName + " Set MainId='{0}',FileName='{1}',FileDesc='{2}',Remark='{3}',UpdateUserId='{4}',UpdateTime={5} Where RID='{6}'";
sql = string.Format(sql, info.MainId, info.FileName, info.FileDesc, info.Remark, info.UpdateUserId, this.GetServerTimeFuncion(), info.RID);
return(sql);
}
void cmdPreview_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;
XFilePreviewTool.Preview(mainId);
}
}
/// <summary>
/// 将数据行转换为实体
/// </summary>
/// <param name="modelRow">数据行记录</param>
/// <returns>实体信息</returns>
protected override void DataRow2ModelBase(XModelBase modelInfo, DataRow modelRow)
{
XTaskFilesInfo info = modelInfo as XTaskFilesInfo;
info.ID = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "RID")); //主键
info.RID = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "RID")); //主键
info.MainId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "MainId")); //任务ID
info.FileName = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "FileName")); //文档名称
info.FileDesc = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "FileDesc")); //文档描述
info.Remark = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "Remark")); //备注信息
info.InputUserId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "InputUserId")); //录入人
info.InputTime = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "InputTime")); //录入时间
info.UpdateUserId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "UpdateUserId")); //修改人
info.UpdateTime = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "UpdateTime")); //修改时间
}
private void DeleteFiles()
{
if (this.grdFiles.GetCheckedRows().Length == 0)
{
XMessageBox.ShowError("请选择要删除的记录！");
return;
}
IList <XModelBase> deletedModels = new List <XModelBase>();
foreach (Janus.Windows.GridEX.GridEXRow gridExRow in this.grdFiles.GetCheckedRows())
{
XModelBase model = gridExRow.DataRow as XModelBase;
XTaskFilesInfo taskFilesInfo = model as XTaskFilesInfo;
if (taskFilesInfo.InputUserId != XCommon.LoginUsersInfo.RID)
{
XMessageBox.ShowError("不能删除非本人提交的任务文档！");
return;
}
deletedModels.Add(model);
}
if (this.m_TaskFilesBusiness.Delete(deletedModels, XCommon.LoginUsersInfo.RID))
{
XMessageBox.ShowRemindMessage("删除成功！");
IList <XModelBase> modelLists = this.grdFiles.DataSource as IList <XModelBase>;
foreach (XModelBase model in deletedModels)
{
Janus.Windows.GridEX.GridEXRow row = this.grdFiles.GetRow(model);
row.Delete();
modelLists.Remove(model);
}
}
else
{
XMessageBox.ShowError("删除失败！");
}
}
protected override string GetDeleteAfterSql(IList <XModelBase> modelInfos)
{
string deleteIds = this.GetModelIds(modelInfos);
string sql = "DELETE FROM FileAttachment WHERE FileId IN (" + deleteIds + ");";
//更新任务状态，如果当前任务下没有除本次任务外的其他任务，则将状态更新为开始
sql += " DECLARE @TaskFilesCount INT ";
foreach (XModelBase model in modelInfos)
{
XTaskFilesInfo taskFileInfo = model as XTaskFilesInfo;
sql += "SELECT @TaskFilesCount=COUNT(*) FROM TaskFiles WHERE MainId='" + taskFileInfo.MainId +
"' AND RID<>'" + taskFileInfo.RID + "' ";
sql += "IF @TaskFilesCount=0 ";
sql += "BEGIN ";
sql += "UPDATE Task SET TaskStatus='开始' WHERE RID='" + taskFileInfo.MainId + "' ";
sql += "END ";
}
return(sql);
}
