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