本文整理汇总了C#中DataAccess.getLocalPlan方法的典型用法代码示例。如果您正苦于以下问题：C# DataAccess.getLocalPlan方法的具体用法？C# DataAccess.getLocalPlan怎么用？C# DataAccess.getLocalPlan使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DataAccess的用法示例。
在下文中一共展示了DataAccess.getLocalPlan方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: performSelectChange
protected void performSelectChange()
{
int iCid = Convert.ToInt32(ddCollege.SelectedValue);
int iFy = Convert.ToInt32(ddFiscalYear.SelectedValue);
DataAccess obj = new DataAccess();
SqlDataReader mydr = obj.getLocalPlan(iCid, iFy);
if (mydr.Read())
{
if (mydr.HasRows)
{
btnCreatePlan.Visible = false;
btnSave.Visible = true;
try
{
cbLocked.Checked = (bool)mydr["flg_locked"];
}
catch
{
cbLocked.Checked = false;
}
if (cbLocked.Checked == true)
{
txtAppropiation.Enabled = false;
cbLocked.Enabled = false;
btnSave.Visible = false;
}
else
{
txtAppropiation.Enabled = true;
cbLocked.Enabled = true;
btnSave.Visible = true;
}
lblLocalPlan.Text = mydr["key_local_plan_id"].ToString();
txtAppropiation.Text = string.Format("{0:n}",mydr["nbr_yearly_appropiation"]);
lblTotalAllAct.Text = string.Format("{0:n}", mydr["nbr_total_activities"]);
lblBalance.Text = string.Format("{0:n}", mydr["nbr_balance"]);
lblStatus.Text = mydr["txt_local_plan_level_status"].ToString();
lblLevel.Text = mydr["txt_local_plan_level_status_desc"].ToString();
}
}
else
{
lblLocalPlan.Text = "";
txtAppropiation.Text = "";
lblTotalAllAct.Text = "";
lblBalance.Text = "";
cbLocked.Checked = false;
lblStatus.Text = "";
lblLevel.Text = "";
btnCreatePlan.Visible = true;
btnSave.Visible = false;
}
lblMsg.Text = "";
}