/// <summary>
/// 设置操作按钮可显示
/// </summary>
public void SetToolButtonVisible()
{
ButtonItem p_Insert = ToolBarItemGet(-1, ToolButtonName.btnInsert.ToString());
ButtonItem p_Update = ToolBarItemGet(-1, ToolButtonName.btnUpdate.ToString());
ButtonItem p_Delete = ToolBarItemGet(-1, ToolButtonName.btnDelete.ToString());
ButtonItem p_InsertExis = ToolBarItemGet(-1, ToolButtonName.btnInsertExist.ToString());
ButtonItem p_Submit = ToolBarItemGet(-1, ToolButtonName.btnSubmit.ToString());
ButtonItem p_SubmitCancel = ToolBarItemGet(-1, ToolButtonName.btnSubmitCancel.ToString());
ButtonItem p_Preview = ToolBarItemGet(-1, ToolButtonName.btnPreview.ToString());
ButtonItem p_Print = ToolBarItemGet(-1, ToolButtonName.btnPrint.ToString());
ButtonItem p_Design = ToolBarItemGet(-1, ToolButtonName.btnDesign.ToString());
ComboBoxItem p_PrintFile = ToolBarCItemGet(-1, ToolButtonName.drpPrintFile.ToString());
p_Insert.Visible = _btnInsertVisible;
p_Delete.Visible = _btnDeleteVisible;
p_Update.Visible = _btnUpdateVisible;
p_InsertExis.Visible = _btnInsertExistVisible;
p_Submit.Visible = _btnSubmitVisible;
p_SubmitCancel.Visible = _btnSubmitCancelVisible;
p_Preview.Visible = _btnPrintVisible;
p_Print.Visible = _btnPrintVisible;
p_Design.Visible = _btnPrintVisible;
p_PrintFile.Visible = _btnPrintVisible;
BaseToolBar.Refresh();
}
/// <summary>
/// 设置操作按钮可显示
/// </summary>
public void SetToolButtonVisible()
{
ButtonItem p_Query = ToolBarItemGet(-1, ToolButtonName.btnQuery.ToString());
ButtonItem p_Insert = ToolBarItemGet(-1, ToolButtonName.btnInsert.ToString());
ButtonItem p_Update = ToolBarItemGet(-1, ToolButtonName.btnUpdate.ToString());
ButtonItem p_Delete = ToolBarItemGet(-1, ToolButtonName.btnDelete.ToString());
ButtonItem p_Save = ToolBarItemGet(-1, ToolButtonName.btnSave.ToString());
ButtonItem p_Drop = ToolBarItemGet(-1, ToolButtonName.btnCancel.ToString());
ButtonItem p_Submit = ToolBarItemGet(-1, ToolButtonName.btnSubmit.ToString());
ButtonItem p_CancelSubmit = ToolBarItemGet(-1, ToolButtonName.btnSubmitCancel.ToString());
ButtonItem p_AuditPass = ToolBarItemGet(-1, ToolButtonName.btnAudit.ToString());
ButtonItem p_AuditRefuse = ToolBarItemGet(-1, ToolButtonName.btnAuditCancel.ToString());
ButtonItem p_FormCancel = ToolBarItemGet(-1, ToolButtonName.btnFormCancel.ToString());
ButtonItem p_FormRestore = ToolBarItemGet(-1, ToolButtonName.btnFormRestore.ToString());
ButtonItem p_AddRow = ToolBarItemGet(-1, ToolButtonName.btnAddRow.ToString());
ButtonItem p_DelRow = ToolBarItemGet(-1, ToolButtonName.btnDelRow.ToString());
p_AddRow.Visible = _btnAddRowVisible;
p_DelRow.Visible = _btnDelRowVisible;
p_Insert.Visible = _btnInsertVisible;
p_Delete.Visible = _btnDeleteVisible;
p_Update.Visible = _btnUpdateVisible;
p_Query.Visible = _btnQueryVisible;
BaseToolBar.Refresh();
}
/// <summary>
/// 设置操作按钮可显示
/// </summary>
public void SetToolButtonVisible()
{
ButtonItem p_Delete = ToolBarItemGet(-1, ToolButtonName.btnDelete.ToString());
p_Delete.Visible = _btnDeleteVisible;
BaseToolBar.Refresh();
}
/// <summary>
/// 设置操作按钮可显示
/// </summary>
public void SetToolButtonVisible()
{
ButtonItem p_Query = ToolBarItemGet(-1, ToolButtonName.btnQuery.ToString());
ButtonItem p_Insert = ToolBarItemGet(-1, ToolButtonName.btnInsert.ToString());
ButtonItem p_Update = ToolBarItemGet(-1, ToolButtonName.btnUpdate.ToString());
ButtonItem p_Delete = ToolBarItemGet(-1, ToolButtonName.btnDelete.ToString());
ButtonItem p_InsertExis = ToolBarItemGet(-1, ToolButtonName.btnInsertExist.ToString());
ButtonItem p_Browse = ToolBarItemGet(-1, ToolButtonName.btnBrowse.ToString());
ButtonItem p_QueryAdvance = ToolBarItemGet(-1, ToolButtonName.btnQueryAdvance.ToString());
ButtonItem p_ToExcel = ToolBarItemGet(-1, ToolButtonName.btnToExcel.ToString());
ButtonItem p_Preview = ToolBarItemGet(-1, ToolButtonName.btnPreview.ToString());
ButtonItem p_Print = ToolBarItemGet(-1, ToolButtonName.btnPrint.ToString());
ButtonItem p_Design = ToolBarItemGet(-1, ToolButtonName.btnDesign.ToString());
ComboBoxItem p_PrintFile = ToolBarCItemGet(-1, ToolButtonName.drpPrintFile.ToString());
p_Query.Visible = _btnQueryVisible;
p_QueryAdvance.Visible = _btnQueryAdvanceVisible;
p_Insert.Visible = _btnInsertVisible;
p_Delete.Visible = _btnDeleteVisible;
p_Update.Visible = _btnUpdateVisible;
p_InsertExis.Visible = _btnInsertExistVisible;
p_ToExcel.Visible = _btnToExcelVisible;
p_Browse.Visible = _btnBrowseVisible;
p_Preview.Visible = _btnPrintVisible;
p_Print.Visible = _btnPrintVisible;
p_Design.Visible = _btnPrintVisible;
p_PrintFile.Visible = _btnPrintVisible;
BaseToolBar.Refresh();
}
/// <summary>
/// 设置操作按钮状态
/// </summary>
public void SetToolButtonStatus(int p_FormSubmitFlag, int p_DelFlag)
{
bool p_SubmitFlag = this.SubmitFlag;
bool p_AuditFlag = this.AuditFlag;
ButtonItem p_Insert = ToolBarItemGet(-1, ToolButtonName.btnInsert.ToString());
ButtonItem p_Update = ToolBarItemGet(-1, ToolButtonName.btnUpdate.ToString());
ButtonItem p_Delete = ToolBarItemGet(-1, ToolButtonName.btnDelete.ToString());
ButtonItem p_Save = ToolBarItemGet(-1, ToolButtonName.btnSave.ToString());
ButtonItem p_Drop = ToolBarItemGet(-1, ToolButtonName.btnCancel.ToString());
ButtonItem p_Submit = ToolBarItemGet(-1, ToolButtonName.btnSubmit.ToString());
ButtonItem p_CancelSubmit = ToolBarItemGet(-1, ToolButtonName.btnSubmitCancel.ToString());
ButtonItem p_AuditPass = ToolBarItemGet(-1, ToolButtonName.btnAudit.ToString());
ButtonItem p_AuditRefuse = ToolBarItemGet(-1, ToolButtonName.btnAuditCancel.ToString());
//ButtonItem p_FormCancel = ToolBarItemGet(-1, ToolButtonName.btnFormCancel.ToString());
//ButtonItem p_FormRestore = ToolBarItemGet(-1, ToolButtonName.btnFormRestore.ToString());
if (!p_AuditFlag)//不需要审核
{
p_AuditPass.Visible = false;
p_AuditRefuse.Visible = false;
}
if (!p_SubmitFlag)//不需要提交
{
p_Submit.Visible = false;
p_CancelSubmit.Visible = false;
}
p_Update.Enabled = false;
p_Delete.Enabled = false;
//p_FormCancel.Enabled = false;
//p_FormRestore.Enabled = false;
switch (p_FormSubmitFlag)//当前单据状态
{
case (int)ConfirmFlag.未提交:
if (p_SubmitFlag) //需要提交 如果不需要提交的话就不存在未提交状态的可能
{
p_Update.Enabled = true;
p_Delete.Enabled = true;
p_Submit.Enabled = true;
p_CancelSubmit.Enabled = false;
p_AuditPass.Enabled = false;
p_AuditRefuse.Enabled = false;
}
else
{
p_Update.Enabled = true;
p_Delete.Enabled = true;
}
break;
case (int)ConfirmFlag.已提交: //已提交，可以撤销提交,可以被审核
p_Submit.Enabled = false;
p_CancelSubmit.Enabled = true;
p_AuditPass.Enabled = true;
p_AuditRefuse.Enabled = true;
break;
case (int)ConfirmFlag.审核通过: //审核通过只能出现审核拒绝
if (p_AuditFlag) //需要审核
{
p_Submit.Enabled = false;
p_CancelSubmit.Enabled = false;
p_AuditPass.Enabled = false;
p_AuditRefuse.Enabled = true;
}
else //不需要审核
{
if (p_SubmitFlag) //需要提交
{
p_Submit.Enabled = false;
p_CancelSubmit.Enabled = true;
}
else //不需要提交
{
p_Update.Enabled = true;
p_Delete.Enabled = true;
}
}
break;
case (int)ConfirmFlag.审核拒绝: //审核拒绝出现审核通过或者可以更新
p_Submit.Enabled = false;
p_CancelSubmit.Enabled = false;
p_AuditPass.Enabled = true;
p_AuditRefuse.Enabled = false;
p_Update.Enabled = true;
p_Delete.Enabled = true;
break;
}
BaseToolBar.Refresh();
}
/// <summary>
/// 设置操作按钮状态
/// </summary>
public void SetToolButtonStatus(FormStatus p_Status, int p_FormSubmitFlag, int p_DelFlag)
{
this.HTFormStatus = p_Status;
bool p_SubmitFlag = this.SubmitFlag;
bool p_AuditFlag = this.AuditFlag;
ButtonItem p_Insert = ToolBarItemGet(-1, ToolButtonName.btnInsert.ToString());
ButtonItem p_Update = ToolBarItemGet(-1, ToolButtonName.btnUpdate.ToString());
ButtonItem p_Delete = ToolBarItemGet(-1, ToolButtonName.btnDelete.ToString());
ButtonItem p_Save = ToolBarItemGet(-1, ToolButtonName.btnSave.ToString());
ButtonItem p_Drop = ToolBarItemGet(-1, ToolButtonName.btnCancel.ToString());
ButtonItem p_Submit = ToolBarItemGet(-1, ToolButtonName.btnSubmit.ToString());
ButtonItem p_CancelSubmit = ToolBarItemGet(-1, ToolButtonName.btnSubmitCancel.ToString());
ButtonItem p_AuditPass = ToolBarItemGet(-1, ToolButtonName.btnAudit.ToString());
ButtonItem p_AuditRefuse = ToolBarItemGet(-1, ToolButtonName.btnAuditCancel.ToString());
ButtonItem p_FormCancel = ToolBarItemGet(-1, ToolButtonName.btnFormCancel.ToString());
ButtonItem p_FormRestore = ToolBarItemGet(-1, ToolButtonName.btnFormRestore.ToString());
ButtonItem p_AddRow = ToolBarItemGet(-1, ToolButtonName.btnAddRow.ToString());
ButtonItem p_DelRow = ToolBarItemGet(-1, ToolButtonName.btnDelRow.ToString());
ButtonItem p_First = ToolBarItemGet(-1, ToolButtonName.btnFirst.ToString());
ButtonItem p_Pre = ToolBarItemGet(-1, ToolButtonName.btnPre.ToString());
ButtonItem p_Next = ToolBarItemGet(-1, ToolButtonName.btnNext.ToString());
ButtonItem p_Last = ToolBarItemGet(-1, ToolButtonName.btnLast.ToString());
p_First.Enabled = false;
p_Pre.Enabled = false;
p_Next.Enabled = false;
p_Last.Enabled = false;
p_Insert.Enabled = false;
p_Update.Enabled = false;
p_Delete.Enabled = false;
p_Save.Enabled = false;
p_Drop.Enabled = false;
if (!p_AuditFlag)//不需要审核
{
p_AuditPass.Visible = false;
p_AuditRefuse.Visible = false;
}
if (!p_SubmitFlag)//不需要提交
{
p_Submit.Visible = false;
p_CancelSubmit.Visible = false;
}
p_FormCancel.Enabled = false;
p_FormRestore.Enabled = false;
p_AddRow.Enabled = false;
p_DelRow.Enabled = false;
switch (p_Status)
{
case FormStatus.查询:
this.HTDataID = SysConvert.ToInt32(this.SetToolButtonPosStatus(this.HTDataID.ToString(), HTDataTableName)); //设置单据张数导航定位状态
if (p_DelFlag == 0)
{
p_FormCancel.Enabled = true;
}
else
{
p_FormRestore.Enabled = true;
}
p_Insert.Enabled = true;
switch (p_FormSubmitFlag) //当前单据状态
{
case (int)ConfirmFlag.未提交:
if (p_SubmitFlag) //需要提交 如果不需要提交的话就不存在未提交状态的可能
{
p_Update.Enabled = true;
p_Delete.Enabled = true;
p_Submit.Enabled = true;
p_CancelSubmit.Enabled = false;
p_AuditPass.Enabled = false;
p_AuditRefuse.Enabled = false;
}
else
{
p_Update.Enabled = true;
p_Delete.Enabled = true;
}
break;
case (int)ConfirmFlag.已提交: //已提交，可以撤销提交,可以被审核
p_Submit.Enabled = false;
p_CancelSubmit.Enabled = true;
p_AuditPass.Enabled = true;
p_AuditRefuse.Enabled = true;
break;
case (int)ConfirmFlag.审核通过: //审核通过只能出现审核拒绝
if (p_AuditFlag) //需要审核
{
p_Submit.Enabled = false;
p_CancelSubmit.Enabled = false;
p_AuditPass.Enabled = false;
p_AuditRefuse.Enabled = true;
}
else //不需要审核
{
if (p_SubmitFlag) //需要提交
{
p_Submit.Enabled = false;
p_CancelSubmit.Enabled = true;
}
else //不需要提交
{
p_Update.Enabled = true;
p_Delete.Enabled = true;
}
}
break;
case (int)ConfirmFlag.审核拒绝: //审核拒绝出现审核通过或者可以更新
p_Submit.Enabled = false;
p_CancelSubmit.Enabled = false;
p_AuditPass.Enabled = true;
p_AuditRefuse.Enabled = false;
p_Update.Enabled = true;
p_Delete.Enabled = true;
break;
}
break;
case FormStatus.新增:
p_Save.Enabled = true;
p_Drop.Enabled = true;
p_AddRow.Enabled = true;
p_DelRow.Enabled = true;
p_Submit.Enabled = false;
p_CancelSubmit.Enabled = false;
p_AuditPass.Enabled = false;
p_AuditRefuse.Enabled = false;
break;
case FormStatus.修改:
p_Save.Enabled = true;
p_Drop.Enabled = true;
p_AddRow.Enabled = true;
p_DelRow.Enabled = true;
p_Submit.Enabled = false;
p_CancelSubmit.Enabled = false;
p_AuditPass.Enabled = false;
p_AuditRefuse.Enabled = false;
break;
case FormStatus.放弃:
goto case FormStatus.查询;
}
BaseToolBar.Refresh();
}
/// <summary>
/// 设置单据张数导航定位状态
/// </summary>
/// <param name="p_First">首张</param>
/// <param name="p_Prev">前张</param>
/// <param name="p_Next">下张</param>
/// <param name="p_Last">末张</param>
/// <param name="p_IOFormID">单据ID</param>
/// <param name="p_TableName">查询表名</param>
/// <param name="p_HeadType">单据大类</param>
/// <param name="p_SubType">单据小类</param>
/// <returns>单据ID</returns>
public string SetToolButtonPosStatus(string p_IDValue, string p_TableName, string p_IDFieldName, string p_Condition)
{
string outstr = p_IDValue;
p_Condition = _SetPosCondition;//查询条件
ButtonItem p_First = ToolBarItemGet(-1, ToolButtonName.btnFirst.ToString());
ButtonItem p_Prev = ToolBarItemGet(-1, ToolButtonName.btnPre.ToString());
ButtonItem p_Next = ToolBarItemGet(-1, ToolButtonName.btnNext.ToString());
ButtonItem p_Last = ToolBarItemGet(-1, ToolButtonName.btnLast.ToString());
p_First.Tag = "";
p_First.Enabled = true;
p_Prev.Tag = "";
p_Prev.Enabled = true;
p_Next.Tag = "";
p_Next.Enabled = true;
p_Last.Tag = "";
p_Last.Enabled = true;
string sql = string.Empty;
//string tempstr = string.Empty;
sql = "SELECT TOP 1 " + p_IDFieldName + " FROM " + p_TableName + " WHERE DelFlag=0 " + p_Condition + " ORDER BY " + p_IDFieldName + " ASC";//首张
DataTable dt = SysUtils.Fill(sql);
if (dt.Rows.Count != 0)
{
p_First.Tag = SysConvert.ToString(dt.Rows[0][0].ToString());
}
sql = "SELECT TOP 1 " + p_IDFieldName + " FROM " + p_TableName + " WHERE DelFlag=0 " + p_Condition + " ORDER BY " + p_IDFieldName + " DESC";//末张
dt = SysUtils.Fill(sql);
if (dt.Rows.Count != 0)
{
p_Last.Tag = SysConvert.ToString(dt.Rows[0][0].ToString());
}
if (p_IDValue == "" || p_IDValue == "0")//如果定位的是0则自动载入末张
{
p_IDValue = SysConvert.ToString(p_Last.Tag);
outstr = p_IDValue;
}
sql = "SELECT TOP 1 " + p_IDFieldName + " FROM " + p_TableName + " WHERE " + p_IDFieldName + " >" + SysString.ToDBString(p_IDValue) + " AND DelFlag=0 " + p_Condition + " ORDER BY " + p_IDFieldName + " ASC";//下张
dt = SysUtils.Fill(sql);
if (dt.Rows.Count != 0)
{
p_Next.Tag = SysConvert.ToString(dt.Rows[0][0].ToString());
}
sql = "SELECT TOP 1 " + p_IDFieldName + " FROM " + p_TableName + " WHERE " + p_IDFieldName + "<" + SysString.ToDBString(p_IDValue) + " AND DelFlag=0 " + p_Condition + " ORDER BY " + p_IDFieldName + " DESC";//上张
dt = SysUtils.Fill(sql);
if (dt.Rows.Count != 0)
{
p_Prev.Tag = SysConvert.ToString(dt.Rows[0][0].ToString());
}
if (SysConvert.ToString(p_First.Tag) == p_IDValue || SysConvert.ToString(p_First.Tag) == "" || SysConvert.ToString(p_First.Tag) == "0")
{
p_First.Enabled = false;
}
if (SysConvert.ToString(p_Prev.Tag) == p_IDValue || SysConvert.ToString(p_Prev.Tag) == "" || SysConvert.ToString(p_Prev.Tag) == "0")
{
p_Prev.Enabled = false;
}
if (SysConvert.ToString(p_Next.Tag) == p_IDValue || SysConvert.ToString(p_Next.Tag) == "" || SysConvert.ToString(p_Next.Tag) == "0")
{
p_Next.Enabled = false;
}
if (SysConvert.ToString(p_Last.Tag) == p_IDValue || SysConvert.ToString(p_Last.Tag) == "" || SysConvert.ToString(p_Last.Tag) == "0")
{
p_Last.Enabled = false;
}
BaseToolBar.Refresh();
return(outstr);
}
