private void SelectedIndex(int val)
{
if (val == 0)
{
CODE.Text = "";
DESC.Text = "";
return;
}
dbtimeout = (int)Session["dbTimeOut"];
ConnString = (string)Session["ConnString"];
using (conn = new DbConnection(ConnString))
{
string qry = _query;
if (qry == null || qry.Trim() == "")
{
qry = "select " + _fldid + ", " + _flddesc + " from " + _tblname;
if (_cond != null && _cond.Trim() != "")
{
qry += " where (" + _cond + ") ";
}
if (_orderby != null && _orderby.Trim() != "")
{
qry += " order by " + _orderby + " ";
}
}
ListItemCollection items = new ListItemCollection();
MyPage.fillRefList(items, qry, null, dbtimeout, false, conn);
CODE.Text = items[val].Value;
DESC.Text = items[val].Text;
}
}
protected void Page_Load(object sender, EventArgs e)
{
dbtimeout = int.Parse(ConfigurationSettings.AppSettings["dbTimeOut"]);
if (!IsPostBack)
{
conn = new DbConnection(Session["ConnStringLogin"].ToString());
MyPage.fillRefList(DDL_MODULEID, Q_RFMODULE + " and moduleid in (" + MaintainedModuleIDs + ")", null, dbtimeout, false, conn);
conn.ExecReader(Q_RFMODULE + " and moduleid in (" + MaintainedModuleIDs + ")", null, dbtimeout);
while (conn.hasRow())
{
CHK_MODULEID.Items.Add(new ListItem(conn.GetFieldValue(1), conn.GetFieldValue(0)));
}
string cond = " order by sg_grpname ";
MyPage.fillRefList(DDL_SG_GRPUPLINER, Q_GROUP + cond, null, dbtimeout, true, conn);
ClearEntries();
orderby = "";
ViewState["orderby"] = orderby;
conn.Dispose();
}
else
{
orderby = (string)ViewState["orderby"];
}
LBL_RESULT.Text = "";
BTN_SAVE.Attributes.Add("onclick", "if(!cek_mandatory(document.form1)){return false;} else {simpan();};");
IFR_MODULE.Attributes.Add("onload", "resizeFrame()");
}
private void SelectedValue(string val)
{
if (val.Trim() == "" || val.Trim() == " ")
{
CODE.Text = "";
DESC.Text = "";
return;
}
dbtimeout = (int)Session["dbTimeOut"];
ConnString = (string)Session["ConnString"];
using (conn = new DbConnection(ConnString))
{
if (_query == null || _query.Trim() == "")
{
string qry = "select " + _fldid + ", " + _flddesc + " from " + _tblname;
if (_cond != null && _cond.Trim() != "")
{
qry += " where (" + _cond + ") and " + _fldid + " = '" + val + "'";
}
else
{
qry += " where " + _fldid + " = '" + val + "'";
}
conn.ExecReader(qry, null, dbtimeout);
if (conn.hasRow())
{
CODE.Text = conn.GetFieldValue(0);
DESC.Text = conn.GetFieldValue(1);
}
}
else
{
ListItemCollection items = new ListItemCollection();
MyPage.fillRefList(items, _query, null, dbtimeout, false, conn);
CODE.Text = "";
DESC.Text = "";
for (int i = 0; i < items.Count; i++)
{
if (items[i].Value == val)
{
CODE.Text = items[i].Value;
DESC.Text = items[i].Text;
break;
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
dbtimeout = int.Parse(ConfigurationSettings.AppSettings["dbTimeOut"]);
ConnString = Session["ConnStringLogin"].ToString();
if (!IsPostBack)
{
string user = (string)Session["UserID"];
conn = new DbConnection(ConnString);
uREF_BRANCH.fillRefList(Q_RFBRANCH, true);
uREF_BRANCHID.fillRefList(Q_RFBRANCH, true);
uREF_AREAID.fillRefList(Q_RFAREA, true);
MyPage.fillRefList(DDL_RFMODULE, Q_RFMODULE + " and moduleid in (" + MaintainedModuleIDs + ")", null, dbtimeout, false, conn);
ArrayList arrddl = new ArrayList();
arrddl.Add(DDL_RFGROUP);
arrddl.Add(DDL_GROUPID);
string cond = " where moduleid in (" + MaintainedModuleIDs + ") ";
MyPage.fillRefList(arrddl, Q_MODULEGROUPDDL + cond, null, dbtimeout, false, conn);
orderby = "";
ViewState["orderby"] = orderby;
// dummy query to show the grid
DatGrd.DataSource = conn.GetDataTable(Q_MODULEUSER + " WHERE 1 = 2 ", null, dbtimeout);
try
{
DatGrd.DataBind();
}
catch { }
ClearEntries();
conn.Dispose();
}
else
{
orderby = (string)ViewState["orderby"];
}
BTN_SAVE.Attributes.Add("onclick", "if(!cek_mandatory(document.form1)){return false;} else {simpan();};");
//BTN_SAVE.Attributes.Add("onclick", "simpan();");
}
protected void CHK_MODULEID_SelectedIndexChanged(object sender, EventArgs e)
{
using (conn = new DbConnection(Session["ConnStringLogin"].ToString()))
{
string cond = " and moduleid in (''";
for (int i = 0; i < CHK_MODULEID.Items.Count; i++)
{
if (CHK_MODULEID.Items[i].Selected)
{
cond += ", '" + CHK_MODULEID.Items[i].Value + "'";
}
}
cond += ")";
MyPage.fillRefList(RBL_MODULE.Items, Q_RFMODULE + cond, conn);
RBL_MODULE.Items.RemoveAt(0);
try { RBL_MODULE.SelectedIndex = 0; RBL_MODULE_SelectedIndexChanged(null, null); }
catch { }
}
MyPage.SetFocus(this, BTN_SAVE);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
object[] par = new object[2] {
groupid, moduleid
};
modconn.ExecNonQuery(SP_RSTDUPAUTH, par, dbtimeout);
MyPage.fillRefList(dfc_MENUID, Q_RFDUPREJECT, modconn);
ViewData();
//BindData();
BindData2();
//BindData3();
}
else
{
if (Request.Form["sta"] == "save")
{
SaveData();
}
}
}
protected void CODE_TextChanged(object sender, EventArgs e)
{
if (CODE.Text.Trim() == "")
{
CODE.Text = "";
DESC.Text = "";
return;
}
dbtimeout = (int)Session["dbTimeOut"];
ConnString = (string)Session["ConnString"];
//WebControl ctrl;
using (conn = new DbConnection(ConnString))
{
if (_query == null || _query.Trim() == "")
{
string qry = "select " + _fldid + ", " + _flddesc + " from " + _tblname;
if (_cond != null && _cond.Trim() != "")
{
qry += " where (" + _cond + ") and " + _fldid + " = '" + CODE.Text + "'";
}
else
{
qry += " where " + _fldid + " = '" + CODE.Text + "'";
}
conn.ExecReader(qry, null, dbtimeout);
if (conn.hasRow())
{
DESC.Text = conn.GetFieldValue(1);
//ctrl = CommonForm.ModuleSupport.NextCtrl(this.Parent.Page, CODE);
//if (ctrl != null)
// MyPage.SetFocus(this, ctrl);
}
else
{
CODE.Text = "";
DESC.Text = "";
clientmsg = "Kode tidak ditemukan";
MyPage.SetFocus(this, CODE);
}
}
else
{
DropDownList DDL = new DropDownList();
MyPage.fillRefList(DDL.Items, _query, null, dbtimeout, false, conn);
try
{
DDL.SelectedValue = CODE.Text;
DESC.Text = DDL.SelectedItem.Text;
//ctrl = CommonForm.ModuleSupport.NextCtrl(this.Parent.Page, CODE);
//if (ctrl != null)
// MyPage.SetFocus(this, ctrl);
}
catch
{
CODE.Text = "";
DESC.Text = "";
clientmsg = "Kode tidak ditemukan";
MyPage.SetFocus(this, CODE);
}
}
}
}
