/// <summary> /// 填充实体信息 /// </summary> protected override void FillModelInfo() { XVTaskFilesInfo info = this.m_CurrentModel as XVTaskFilesInfo; if (this.m_EditStatus == XEditStatus.AddNew || this.m_EditStatus == XEditStatus.AddContinue) { info.RID = this.GetNewId(); info.ID = info.RID; info.MainId = XHelper.GetString(txtChildTaskName.Tag); } info.FileName = this.txtFileName.Text; info.FileDesc = this.txtFileDesc.Text; info.Remark = this.txtRemark.Text; info.FileFullName = this.txtFilePath.Text.Trim(); info.UpdateUserName = XCommon.LoginUsersInfo.RealName; info.InputUserName = XCommon.LoginUsersInfo.RealName; info.TaskName = this.txtChildTaskName.Text; info.TaskNo = this.txtChildTaskNo.Text; info.StartDate = XHelper.GetFormatedDate(this.dtChildTaskStartDate.Value); info.PreEndDate = XHelper.GetFormatedDate(this.dtChildTaskPreEnd.Value); info.ParentTaskName = this.txtMainId.Text; info.ParentTaskNo = this.txtTaskNo.Text; info.ParentStartDate = XHelper.GetFormatedDate(this.dtStartDate.Value); info.ParentPreEndDate = XHelper.GetFormatedDate(this.dtPreEndDate.Value); base.FillModelInfo(); }
private DbCommand GetFileCommand(XVTaskFilesInfo taskFileInfo) { string fileDesc = string.Empty; string fileName = taskFileInfo.FileFullName; FileInfo fi = new FileInfo(fileName); double fileSize = 0; fileSize = Math.Round(XHelper.GetDouble(fi.Length) / XHelper.GetDouble(1024), 2); byte[] bData = XHelper.GetFileBytes(fileName); string fileId = taskFileInfo.RID; string sql = "DELETE FROM FileAttachment WHERE FileId='" + fileId + "';"; sql += "INSERT INTO FileAttachment (RID,FileId,AtchName,AtchDesc,AtchType," + "AtchSize,AtchPath,AtchShotGifPath,AtchImag,InputUserId,InputTime)values" + "(@RId,@FileId,@AtchName,@AtchDesc,@AtchType,@AtchSize,@AtchPath,@AtchShotGifPath," + "@AtchImag,@UserId,getdate())"; DbConnection conn = this.m_DataAccess.Connection; DbCommand cmd = this.m_DataAccess.GetDbCommand(); cmd.CommandText = sql; DbParameter parameterId = this.m_DataAccess.GetParameter("@RId", Guid.NewGuid().ToString()); cmd.Parameters.Add(parameterId); DbParameter parameterMainId = this.m_DataAccess.GetParameter("@FileId", fileId); cmd.Parameters.Add(parameterMainId); DbParameter parameterFileName = this.m_DataAccess.GetParameter("@AtchName", fi.Name); cmd.Parameters.Add(parameterFileName); DbParameter parameterAtchDesc = this.m_DataAccess.GetParameter("@AtchDesc", fileDesc); cmd.Parameters.Add(parameterAtchDesc); DbParameter parameterAtchType = this.m_DataAccess.GetParameter("@AtchType", fi.Extension); cmd.Parameters.Add(parameterAtchType); DbParameter parameterAtchSize = this.m_DataAccess.GetParameter("@AtchSize", fileSize); cmd.Parameters.Add(parameterAtchSize); DbParameter parameterAtchPath = this.m_DataAccess.GetParameter("@AtchPath", fi.FullName); cmd.Parameters.Add(parameterAtchPath); DbParameter parameterAtchShotGifPath = this.m_DataAccess.GetParameter("@AtchShotGifPath", ""); cmd.Parameters.Add(parameterAtchShotGifPath); DbParameter parameterFile = this.m_DataAccess.GetParameter("@AtchImag", bData); cmd.Parameters.Add(parameterFile); DbParameter parameterUser = this.m_DataAccess.GetParameter("@UserId", taskFileInfo.UpdateUserId); cmd.Parameters.Add(parameterUser); return(cmd); }
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); }
protected override void FillRowViewInfos(XModelBase model, System.Data.DataRow modelRow) { XVTaskFilesInfo info = model as XVTaskFilesInfo; info.InputUserName = XHelper.GetString(modelRow["InputUserName"]); info.UpdateUserName = XHelper.GetString(modelRow["UpdateUserName"]); info.TaskName = XHelper.GetString(modelRow["TaskName"]); info.TaskNo = XHelper.GetString(modelRow["TaskNo"]); info.StartDate = XHelper.GetString(modelRow["StartDate"]); info.PreEndDate = XHelper.GetString(modelRow["PreEndDate"]); info.ParentTaskName = XHelper.GetString(modelRow["ParentTaskName"]); info.ParentTaskNo = XHelper.GetString(modelRow["ParentTaskNo"]); info.ParentStartDate = XHelper.GetString(modelRow["ParentStartDate"]); info.ParentPreEndDate = XHelper.GetString(modelRow["ParentPreEndDate"]); }
/// <summary> /// 设置修改时的默认值 /// </summary> protected override void SetDefaultValue() { XVTaskFilesInfo info = this.m_CurrentModel as XVTaskFilesInfo; //this.txtMainId.Text = info.MainId; this.txtFileName.Text = info.FileName; this.txtFileDesc.Text = info.FileDesc; this.txtRemark.Text = info.Remark; this.txtChildTaskName.Text = info.TaskName; this.txtChildTaskName.Tag = info.RID; this.txtChildTaskNo.Text = info.TaskNo; this.dtChildTaskStartDate.Value = XHelper.GetDateTime(info.StartDate); this.dtChildTaskPreEnd.Value = XHelper.GetDateTime(info.PreEndDate); this.txtMainId.Text = info.ParentTaskName; this.txtTaskNo.Text = info.ParentTaskNo; this.dtStartDate.Value = XHelper.GetDateTime(info.ParentStartDate); this.dtPreEndDate.Value = XHelper.GetDateTime(info.ParentPreEndDate); }
private void tvTask_AfterSelect(object sender, TreeViewEventArgs e) { TreeNode selectedNode = e.Node; XVTaskInfo info = selectedNode.Tag as XVTaskInfo; if (m_LastSelctedNode != null) { m_LastSelctedNode.BackColor = Color.White; } selectedNode.BackColor = Color.LightBlue; m_LastSelctedNode = selectedNode; if (info != null) { //如果选中的是任务节点 this.tabTask.SelectedIndex = 0; this.txtTaskTypeId.Text = info.TaskType; this.txtTaskName.Text = info.TaskName; this.txtTaskNo.Text = info.TaskNo; this.txtStartPeople.Text = info.StartPeople; this.dtDispatchDate.Value = XHelper.GetDateTime(info.DispatchDate); this.txtAssignPeople.Text = info.AssignPeopleName; this.dtStartDate.Value = XHelper.GetDateTime(info.StartDate); this.dtPreEndDate.Value = XHelper.GetDateTime(info.PreEndDate); this.txtShortDesc.Text = info.ShortDesc; this.txtRequire.Text = info.Require; this.txtContent.Text = info.Content; this.txtRemark.Text = info.Remark; if (selectedNode.Parent != null) { XTaskInfo parentTaskInfo = selectedNode.Parent.Tag as XTaskInfo; this.txtParentTask.Text = parentTaskInfo.TaskName; this.txtParentTaskNo.Text = parentTaskInfo.TaskNo; this.dtParentStartDate.Value = XHelper.GetDateTime(parentTaskInfo.StartDate); this.dtParentPreEndDate.Value = XHelper.GetDateTime(parentTaskInfo.PreEndDate); } else { this.txtParentTask.Text = string.Empty; this.txtParentTaskNo.Text = string.Empty; //this.dtParentStartDate.Value = //this.dtParentPreEndDate.Value = XHelper.GetDateTime(parentTaskInfo.PreEndDate); } if (this.IsChildTaskNode(selectedNode)) { //如果选择的是子任务 this.FillFilesGrid(info.RID); } else { //如果是根级节点 this.grdFiles.DataSource = this.m_TaskFilesBusiness.GetViewListByRootTaskId(info.RID); this.grdFiles.AutoSizeColumns(); } this.FillTaskAttachGrid(info.RID); } else { this.tabTask.SelectedIndex = 1; //文件节点 XVTaskFilesInfo taskFileInfo = selectedNode.Tag as XVTaskFilesInfo; this.txtFileName.Text = taskFileInfo.FileName; this.txtFileDesc.Text = taskFileInfo.FileDesc; this.txtFileRemark.Text = taskFileInfo.Remark; } }