/// <summary> /// 获取删除时插入日志表sql /// </summary> /// <param name="modelInfo"></param> /// <param name="userId"></param> /// <returns></returns> protected override string GetInsertDeleteHistory(XModelBase modelInfo, string userId) { XStandFilesInfo info = modelInfo as XStandFilesInfo; string sql = "Insert Into " + this.HistoryTableName + "(RID,MainId,FileName,FileNo,FileDesc,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime,IsMaxVersion,NextCheckDate,IsNeedCheck,OperateUserId,Operate,OperateTime,NewID) SELECT RID,MainId,FileName,FileNo,FileDesc,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime,IsMaxVersion,NextCheckDate,IsNeedCheck,'" + userId + "','删除',getdate(),newid() FROM " + this.TableName + " WHERE " + this.PrimaryKey + "='" + info.RID + "'"; return(sql); }
/// <summary> /// 获取插入sql /// </summary> /// <param name="modelInfo"></param> /// <returns></returns> public override string GetInsertSql(XModelBase modelInfo) { XStandFilesInfo info = modelInfo as XStandFilesInfo; string sql = "Insert Into " + this.TableName + "(RID,MainId,FileName,FileNo,FileDesc,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime,IsMaxVersion,NextCheckDate,IsNeedCheck)Values('{0}','{1}','{2}','{3}','{4}','{5}','{6}',{7},'{8}',{9},'{10}','{11}','{12}')"; sql = String.Format(sql, info.RID, info.MainId, info.FileName, info.FileNo, info.FileDesc, info.Remark, info.InputUserId, this.GetServerTimeFuncion(), info.UpdateUserId, this.GetServerTimeFuncion(), info.IsMaxVersion == true?"1":"0", info.NextCheckDate, info.IsNeedCheck == true?"1":"0"); return(sql); }
void cmdPreviewFile_Click(object sender, Janus.Windows.UI.CommandBars.CommandEventArgs e) { if (this.grdData.CurrentRow != null && this.grdData.CurrentRow.RowType == Janus.Windows.GridEX.RowType.Record) { XStandFilesInfo model = this.grdFiles.CurrentRow.DataRow as XStandFilesInfo; string mainId = model.RID; XFilePreviewTool.Preview(mainId); } }
/// <summary> /// 自定义修改校验 /// </summary> /// <param name="modelInfo"></param> /// <returns></returns> protected override string GetValidateUpdateCustom(XModelBase modelInfo) { string validateInfo = string.Empty; XStandFilesInfo standfiles = modelInfo as XStandFilesInfo; if (standfiles == 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; XStandFilesInfo info = modelInfo as XStandFilesInfo; sql = "Update " + this.TableName + " Set MainId='{0}',FileName='{1}',FileNo='{2}',FileDesc='{3}',Remark='{4}',UpdateUserId='{5}',UpdateTime={6},IsMaxVersion='{7}',NextCheckDate='{8}',IsNeedCheck='{9}' Where RID='{10}'"; sql = string.Format(sql, info.MainId, info.FileName, info.FileNo, info.FileDesc, info.Remark, info.UpdateUserId, this.GetServerTimeFuncion(), info.IsMaxVersion == true?"1":"0", info.NextCheckDate, info.IsNeedCheck == true?"1":"0", info.RID); return(sql); }
protected override string GetValueMember(XModelBase selectedModel) { XStandFilesInfo info = selectedModel as XStandFilesInfo; if (info != null) { return(info.RID); } else { return(string.Empty); } }
protected override string GetDisplayMember(Model.XModelBase selectedModel) { XStandFilesInfo info = selectedModel as XStandFilesInfo; if (info != null) { return(info.FileName); } else { return(string.Empty); } }
public override void FillDetailMainId(string key, XModelBase detailInfo, XModelBase mainInfo) { switch (key) { case "grdFiles": //文件集 XStandFilesInfo standFileInfo = detailInfo as XStandFilesInfo; standFileInfo.MainId = mainInfo.ID; break; case "grdEquipments": //标准设备 XStandEquipmentInfo equipmentInfo = detailInfo as XStandEquipmentInfo; equipmentInfo.MainId = mainInfo.ID; break; } }
protected override void SavedAfterOperate() { string filePath = this.txtFilePath.Text.Trim(); if (filePath != string.Empty) { if (File.Exists(filePath)) { XStandFilesInfo fileInfo = this.m_CurrentModel as XStandFilesInfo; if (!this.m_FileAttachBusiness.InsertFile(Guid.NewGuid().ToString(), fileInfo.RID, filePath, XCommon.LoginUsersInfo.RID)) { XMessageBox.ShowError("上传附件失败,请点击修改重新上传附件!"); } } } }
/// <summary> /// 将数据行转换为实体 /// </summary> /// <param name="modelRow">数据行记录</param> /// <returns>实体信息</returns> protected override void DataRow2ModelBase(XModelBase modelInfo, DataRow modelRow) { XStandFilesInfo info = modelInfo as XStandFilesInfo; 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.FileNo = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "FileNo")); //文件编号 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")); //修改时间 info.IsMaxVersion = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "IsMaxVersion")) == "True"; // info.NextCheckDate = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "NextCheckDate")); // info.IsNeedCheck = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "IsNeedCheck")) == "True"; // }
protected override string GetDetailDeleteSql(string key, XModelBase detailInfo) { string sqlDelteDetail = string.Empty; switch (key) { case "grdFiles": XStandFilesInfo fileInfo = detailInfo as XStandFilesInfo; sqlDelteDetail += "DELETE FROM StandFiles WHERE MainId='" + fileInfo.MainId + "';"; sqlDelteDetail += "DELETE FROM FileAttachment WHERE FileId='" + fileInfo.ID + "';"; break; case "grdEquipments": XStandEquipmentInfo equipmentInfo = detailInfo as XStandEquipmentInfo; sqlDelteDetail += "DELETE FROM StandEquipment WHERE MainId='" + equipmentInfo.MainId + "';"; break; } return(sqlDelteDetail); }
/// <summary> /// 文件下载 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void cmdDownloadFile_Click(object sender, Janus.Windows.UI.CommandBars.CommandEventArgs e) { if (this.grdData.CurrentRow != null && this.grdData.CurrentRow.RowType == Janus.Windows.GridEX.RowType.Record) { XStandFilesInfo model = this.grdFiles.CurrentRow.DataRow as XStandFilesInfo; 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("下载完成!"); this.DownloadAfter(fileName, model); } else { XMessageBox.ShowError("下载失败!"); } } } else { XMessageBox.ShowError("请选择要下载附件的记录!"); } }