/// <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("请选择要下载附件的记录！");
}
}
