/// <summary>
/// 获取更新Sql
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
public override string GetUpdateSql(XModelBase modelInfo)
{
string sql = String.Empty;
XPassWord4FileInfo info = modelInfo as XPassWord4FileInfo;
sql = "Update " + this.TableName + " Set PassWordTmpId='{0}',PassWord='******',DownLoadUserId='{2}',FileID='{3}',DownTime='{4}',Remark='{5}' Where RID='{6}'";
sql = string.Format(sql, info.PassWordTmpId, info.PassWord, info.DownLoadUserId, info.FileID, info.DownTime, info.Remark, info.RID);
return(sql);
}
/// <summary>
/// 自定义修改校验
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
protected override string GetValidateUpdateCustom(XModelBase modelInfo)
{
string validateInfo = string.Empty;
XCodeProjectTypeInfo codeprojecttype = modelInfo as XCodeProjectTypeInfo;
if (codeprojecttype == null)
{
return(this.GetNotRightType());
}
return(string.Empty);
}
/// <summary>
/// 自定义修改校验
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
protected override string GetValidateUpdateCustom(XModelBase modelInfo)
{
string validateInfo = string.Empty;
XUseOperateLogInfo useoperatelog = modelInfo as XUseOperateLogInfo;
if (useoperatelog == 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;
XCodeDefInfo info = modelInfo as XCodeDefInfo;
sql = "Update " + this.TableName + " Set NameEN='{0}',NameCN='{1}',RuleCode='{2}',NameBig5='{3}',Code='{4}',CodeNum={5},CodeEN='{6}',Spell='{7}',SpellHeader='{8}',ProirNum={9},DeptId='{10}',IsUsed='{11}',ParentID='{12}',UserID='{13}',Remark='{14}',UpdateUserId='{15}',UpdateTime={16} Where RID='{17}'";
sql = string.Format(sql, info.NameEN, info.NameCN, info.RuleCode, info.NameBig5, info.Code, info.CodeNum, info.CodeEN, info.Spell, info.SpellHeader, info.ProirNum, info.DeptId, info.IsUsed == true?"1":"0", info.ParentID, info.UserID, info.Remark, info.UpdateUserId, this.GetServerTimeFuncion(), info.RID);
return(sql);
}
/// <summary>
/// 自定义修改校验
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
protected override string GetValidateUpdateCustom(XModelBase modelInfo)
{
string validateInfo = string.Empty;
XMenuGroupInfo menugroup = modelInfo as XMenuGroupInfo;
if (menugroup == 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;
XTemplateCatalogInfo info = modelInfo as XTemplateCatalogInfo;
sql = "Update " + this.TableName + " Set Source='{0}',CatalogDesc='{1}',BranchID='{2}',Memo='{3}',StampTime='{4}' Where CatalogID='{5}'";
sql = string.Format(sql, info.Source, info.CatalogDesc, info.BranchID, info.Memo, info.StampTime, info.CatalogID);
return(sql);
}
/// <summary>
/// 自定义新增校验
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
protected override string GetValidateInsertCustom(XModelBase modelInfo)
{
string validateInfo = string.Empty;
XCodeStandStatusInfo codestandstatus = modelInfo as XCodeStandStatusInfo;
if (codestandstatus == 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);
}
/// <summary>
/// 获取更新Sql
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
public override string GetUpdateSql(XModelBase modelInfo)
{
string sql = String.Empty;
XEquipmentCheckInfo info = modelInfo as XEquipmentCheckInfo;
sql = "Update " + this.TableName + " Set EquipmentType='{0}',EquipmentCustId='{1}',EquipmentName='{2}',FactoryNo='{3}',Spec='{4}',Model='{5}',FactoryName='{6}',SourceTime='{7}',UseTime='{8}',SourceCustId='{9}',SourceTypeId='{10}',EquipmentStatusId='{11}',SignStatus='{12}',Quanlity={13},LinkMan='{14}',Tel='{15}',Email='{16}',CheckAccord='{17}',LastCheckDate='{18}',CheckResult='{19}',ValidDate='{20}',CertNo='{21}',EquipmentDesc='{22}',Remark='{23}',UpdateUserId='{24}',UpdateTime={25},EquipmentNo='{26}',BillNo='{27}' Where RID='{28}'";
sql = string.Format(sql, info.EquipmentType, info.EquipmentCustId, info.EquipmentName, info.FactoryNo, info.Spec, info.Model, info.FactoryName, info.SourceTime, info.UseTime, info.SourceCustId, info.SourceTypeId, info.EquipmentStatusId, info.SignStatus, info.Quanlity, info.LinkMan, info.Tel, info.Email, info.CheckAccord, info.LastCheckDate, info.CheckResult, info.ValidDate, info.CertNo, info.EquipmentDesc, info.Remark, info.UpdateUserId, this.GetServerTimeFuncion(), info.EquipmentNo, info.BillNo, info.RID);
return(sql);
}
/// <summary>
/// 获取更新Sql
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
public override string GetUpdateSql(XModelBase modelInfo)
{
string sql = String.Empty;
XEquipmentReceiveInfo info = modelInfo as XEquipmentReceiveInfo;
sql = "Update " + this.TableName + " Set EquipmentCheckId='{0}',CheckUserId='{1}',Remark='{2}',UpdateUserId='{3}',UpdateTime={4},ReceiveUserId='{5}',ReceiveDate='{6}',ReceiveDesc='{7}',CurrentStatus='{8}',FlowStatus='{9}',FlowUserId='{10}',CheckedUserId='{11}',CheckedDate='{12}',CheckedDesc='{13}',VerifyUserId='{14}',CheckedReport='{15}',VerifyedUserId='{16}',VerifyedDate='{17}',VerifyedDesc='{18}',SignUserId='{19}',SignedUserId='{20}',SignedDate='{21}',SignedDesc='{22}',DispatchUserId='{23}',IsBack='{24}',BackDate='{25}',BackReason='{26}',BackStatus='{27}',BackUserId='{28}',Quanlity={29},StandId='{30}',PdfReportFileName='{31}' Where RID='{32}'";
sql = string.Format(sql, info.EquipmentCheckId, info.CheckUserId, info.Remark, info.UpdateUserId, this.GetServerTimeFuncion(), info.ReceiveUserId, info.ReceiveDate, info.ReceiveDesc, info.CurrentStatus, info.FlowStatus, info.FlowUserId, info.CheckedUserId, info.CheckedDate, info.CheckedDesc, info.VerifyUserId, info.CheckedReport, info.VerifyedUserId, info.VerifyedDate, info.VerifyedDesc, info.SignUserId, info.SignedUserId, info.SignedDate, info.SignedDesc, info.DispatchUserId, info.IsBack == true?"1":"0", info.BackDate, info.BackReason, info.BackStatus, info.BackUserId, info.Quanlity, info.StandId, info.PdfReportFileName, info.RID);
return(sql);
}
/// <summary>
/// 自定义删除校验
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
protected override string GetValidateDeleteCustom(XModelBase modelInfo)
{
string validateInfo = string.Empty;
XUseDeptInfo usedept = modelInfo as XUseDeptInfo;
if (usedept == null)
{
return(this.GetNotRightType());
}
return(string.Empty);
}
/// <summary>
/// 自定义修改校验
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
protected override string GetValidateUpdateCustom(XModelBase modelInfo)
{
string validateInfo = string.Empty;
XStandCodeEquipmentInfo standcodeequipment = modelInfo as XStandCodeEquipmentInfo;
if (standcodeequipment == null)
{
return(this.GetNotRightType());
}
return(string.Empty);
}
/// <summary>
/// 自定义新增校验
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
protected override string GetValidateInsertCustom(XModelBase modelInfo)
{
string validateInfo = string.Empty;
XTemplateBillInfo templatebill = modelInfo as XTemplateBillInfo;
if (templatebill == null)
{
return(this.GetNotRightType());
}
return(string.Empty);
}
/// <summary>
/// 自定义新增校验
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
protected override string GetValidateInsertCustom(XModelBase modelInfo)
{
string validateInfo = string.Empty;
XMenuFolderInfo menufolder = modelInfo as XMenuFolderInfo;
if (menufolder == 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;
XUsersInfo info = modelInfo as XUsersInfo;
sql = "Update " + this.TableName + " Set UserType='{0}',UserName='******',RealName='{2}',NameNum={3},PassWord='******',UserState='{5}',IsAdmin='{6}',IsUsed='{7}',AuditTel='{8}',IsDownPower='{9}',OrderIndex={10},Remark='{11}',UpdateUserId='{12}',UpdateTime={13} Where RID='{14}'";
sql = string.Format(sql, info.UserType, info.UserName, info.RealName, info.NameNum, info.PassWord, info.UserState, info.IsAdmin == true?"1":"0", info.IsUsed == true?"1":"0", info.AuditTel, info.IsDownPower == true?"1":"0", info.OrderIndex, info.Remark, info.UpdateUserId, this.GetServerTimeFuncion(), info.RID);
return(sql);
}
/// <summary>
/// 自定义新增校验
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
protected override string GetValidateInsertCustom(XModelBase modelInfo)
{
string validateInfo = string.Empty;
XCodeEquipmentTypeInfo codeequipmenttype = modelInfo as XCodeEquipmentTypeInfo;
if (codeequipmenttype == null)
{
return(this.GetNotRightType());
}
return(string.Empty);
}
/// <summary>
/// 自定义删除校验
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
protected override string GetValidateDeleteCustom(XModelBase modelInfo)
{
string validateInfo = string.Empty;
XCodeUserStateInfo codeuserstate = modelInfo as XCodeUserStateInfo;
if (codeuserstate == 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);
}
/// <summary>
/// 获取更新Sql
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
public override string GetUpdateSql(XModelBase modelInfo)
{
string sql = String.Empty;
XRemindRolesInfo info = modelInfo as XRemindRolesInfo;
sql = "Update " + this.TableName + " Set ConfigId='{0}',RoleId='{1}' Where RID='{2}'";
sql = string.Format(sql, info.ConfigId, info.RoleId, info.RID);
return(sql);
}
/// <summary>
/// 获取更新Sql
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
public override string GetUpdateSql(XModelBase modelInfo)
{
string sql = String.Empty;
XUseDeptFolderInfo info = modelInfo as XUseDeptFolderInfo;
sql = "Update " + this.TableName + " Set DeptID='{0}',FolderID='{1}',Remark='{2}',UpdateUserId='{3}',UpdateTime={4} Where RID='{5}'";
sql = string.Format(sql, info.DeptID, info.FolderID, info.Remark, info.UpdateUserId, this.GetServerTimeFuncion(), info.RID);
return(sql);
}
/// <summary>
/// 获取更新Sql
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
public override string GetUpdateSql(XModelBase modelInfo)
{
string sql = String.Empty;
XStaffCertificateInfo info = modelInfo as XStaffCertificateInfo;
sql = "Update " + this.TableName + " Set UserId='{0}',CertName='{1}',CertNo='{2}',CertGetTime='{3}',CertItem='{4}',Remark='{5}',UpdateUserId='{6}',UpdateTime={7},RegisterDate='{8}',NextRegisterDate='{9}' Where RID='{10}'";
sql = string.Format(sql, info.UserId, info.CertName, info.CertNo, info.CertGetTime, info.CertItem, info.Remark, info.UpdateUserId, this.GetServerTimeFuncion(), info.RegisterDate, info.NextRegisterDate, info.RID);
return(sql);
}
/// <summary>
/// 获取更新Sql
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
public override string GetUpdateSql(XModelBase modelInfo)
{
string sql = String.Empty;
XStaffInfoInfo info = modelInfo as XStaffInfoInfo;
sql = "Update " + this.TableName + " Set UserName='******',UserSex='{1}',Nationality='{2}',UserAge={3},Birthday='{4}',NativePlace='{5}',StartWorkDate='{6}',ToCompWorkDate='{7}',PersonID='{8}',Specialty='{9}',HouseHoldAddr='{10}',HomeAddress='{11}',HomeTel='{12}',MobileNo='{13}',WorkTel='{14}',Education='{15}',Major='{16}',University='{17}',MeasureWorkYears={18},MeasureWorkContent='{19}',DeptId='{20}',Post='{21}',RoleId='{22}',UserId='{23}',Remark='{24}',UpdateUserId='{25}',UpdateTime={26},FileName='{27}' Where RID='{28}'";
sql = string.Format(sql, info.UserName, info.UserSex, info.Nationality, info.UserAge, info.Birthday, info.NativePlace, info.StartWorkDate, info.ToCompWorkDate, info.PersonID, info.Specialty, info.HouseHoldAddr, info.HomeAddress, info.HomeTel, info.MobileNo, info.WorkTel, info.Education, info.Major, info.University, info.MeasureWorkYears, info.MeasureWorkContent, info.DeptId, info.Post, info.RoleId, info.UserId, info.Remark, info.UpdateUserId, this.GetServerTimeFuncion(), info.FileName, info.RID);
return(sql);
}
/// <summary>
/// 获取更新Sql
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
public override string GetUpdateSql(XModelBase modelInfo)
{
string sql = String.Empty;
XRoleMenusInfo info = modelInfo as XRoleMenusInfo;
sql = "Update " + this.TableName + " Set RoleId='{0}',MenuId='{1}',OrderIndex={2},Remark='{3}',UpdateUserId='{4}',UpdateTime={5} Where RID='{6}'";
sql = string.Format(sql, info.RoleId, info.MenuId, info.OrderIndex, info.Remark, info.UpdateUserId, this.GetServerTimeFuncion(), info.RID);
return(sql);
}
/// <summary>
/// 自定义修改校验
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
protected override string GetValidateUpdateCustom(XModelBase modelInfo)
{
string validateInfo = string.Empty;
XEquipmentDetectInfo equipmentdetect = modelInfo as XEquipmentDetectInfo;
if (equipmentdetect == 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;
XTemplateBillInfo info = modelInfo as XTemplateBillInfo;
sql = "Update " + this.TableName + " Set Rno='{0}',Bno='{1}',Unitname='{2}',Linkname='{3}',Linktel='{4}',DevNameDesc='{5}',DevSpecDesc='{6}',MnoDesc='{7}',AttachmentDesc='{8}',NumDesc='{9}',PriceDesc='{10}',TotaleDesc='{11}',WriteTime='{12}',GetTime='{13}',Total={14},Linkmanw='{15}',Accnamw='{16}',Unitmemo='{17}',Memo1='{18}',Memo2='{19}',Memo3='{20}',Memo4='{21}',Memo='{22}',Createtime='{23}',Creator='{24}',ModifyTime='{25}',Modifeir='{26}',Desc_wgjc='{27}',Fee_xspjf='{28}',Fee_xspjf_num={29},Fee_jdjyf='{30}',Fee_jdjyf_num={31},Fee_jdf='{32}',Fee_jdf_num={33},Fee_jzf='{34}',Fee_jzf_num={35},Fee_csf='{36}',Fee_csf_num={37},Fee_jcf='{38}',Fee_jcf_num={39},Fee_qtsf='{40}',Fee_qtsf_num={41},Person_jc='{42}',Time_year='{43}',Time_month='{44}',Time_day='{45}',Memo_bill='{46}',Memo_else='{47}',Bill_dizhi='{48}',Bill_youbian='{49}',Bill_jieshouren='{50}' Where RID='{51}'";
sql = string.Format(sql, info.Rno, info.Bno, info.Unitname, info.Linkname, info.Linktel, info.DevNameDesc, info.DevSpecDesc, info.MnoDesc, info.AttachmentDesc, info.NumDesc, info.PriceDesc, info.TotaleDesc, info.WriteTime, info.GetTime, info.Total, info.Linkmanw, info.Accnamw, info.Unitmemo, info.Memo1, info.Memo2, info.Memo3, info.Memo4, info.Memo, info.Createtime, info.Creator, info.ModifyTime, info.Modifeir, info.Desc_wgjc, info.Fee_xspjf, info.Fee_xspjf_num, info.Fee_jdjyf, info.Fee_jdjyf_num, info.Fee_jdf, info.Fee_jdf_num, info.Fee_jzf, info.Fee_jzf_num, info.Fee_csf, info.Fee_csf_num, info.Fee_jcf, info.Fee_jcf_num, info.Fee_qtsf, info.Fee_qtsf_num, info.Person_jc, info.Time_year, info.Time_month, info.Time_day, info.Memo_bill, info.Memo_else, info.Bill_dizhi, info.Bill_youbian, info.Bill_jieshouren, info.RID);
return(sql);
}
/// <summary>
/// 自定义修改校验
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
protected override string GetValidateUpdateCustom(XModelBase modelInfo)
{
string validateInfo = string.Empty;
XTemplateCatalogItemInfo templatecatalogitem = modelInfo as XTemplateCatalogItemInfo;
if (templatecatalogitem == null)
{
return(this.GetNotRightType());
}
return(string.Empty);
}
protected override void FillDetailGrid()
{
if (this.m_CurrentList != null && this.m_CurrentList.Count > 0)
{
XModelBase firstModel = this.m_CurrentList[0];
string mainId = firstModel.ID;
IList <XModelBase> detailList = this.GetDetailListByMainId(mainId);
this.grdDetail.DataSource = detailList;
this.grdDetail.AutoSizeColumns();
}
}
/// <summary>
/// 自定义新增校验
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
protected override string GetValidateInsertCustom(XModelBase modelInfo)
{
string validateInfo = string.Empty;
XUsersRoleInfo usersrole = modelInfo as XUsersRoleInfo;
if (usersrole == null)
{
return(this.GetNotRightType());
}
return(string.Empty);
}
/// <summary>
/// 自定义新增校验
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
protected override string GetValidateInsertCustom(XModelBase modelInfo)
{
string validateInfo = string.Empty;
XEquipmentPDFReportInfo equipmentpdfreport = modelInfo as XEquipmentPDFReportInfo;
if (equipmentpdfreport == null)
{
return(this.GetNotRightType());
}
return(string.Empty);
}
/// <summary>
/// 自定义修改校验
/// </summary>
/// <param name="modelInfo"></param>
/// <returns></returns>
protected override string GetValidateUpdateCustom(XModelBase modelInfo)
{
string validateInfo = string.Empty;
XRemindConfigInfo remindconfig = modelInfo as XRemindConfigInfo;
if (remindconfig == null)
{
return(this.GetNotRightType());
}
return(string.Empty);
}
