private void BindingPosBiz(string pos_knd_id) { Biz_PositionKindBizMaps posKndBiz = new Biz_PositionKindBizMaps(); DataSet ds = posKndBiz.GetPosKndBizMap(pos_knd_id, ""); UltraWebGrid2.DataSource = ds; UltraWebGrid2.DataBind(); }
private void KndBizMapGridBinding() { Biz_PositionKindBizMaps maps = new Biz_PositionKindBizMaps(); DataSet ds = maps.GetPosKndBizMaps(); UltraWebGrid2.DataSource = ds; UltraWebGrid2.DataBind(); }
protected void UltraWebGrid3_InitializeRow(object sender, RowEventArgs e) { DataRowView drw = (DataRowView)e.Data; Biz_PositionKindBizMaps kndBizMap = new Biz_PositionKindBizMaps(); TemplatedColumn cCol = (TemplatedColumn)e.Row.Band.Columns.FromKey("CHK_BOX"); CheckBox objchk = (CheckBox)((CellItem)cCol.CellItems[e.Row.BandIndex]).FindControl("cBox"); objchk.Checked = kndBizMap.IsExist(this.hdfPoskndID.Value, drw["POS_BIZ_ID"].ToString()); }
public static void BindKndBiz(TreeView treeView) { string valueStr_knd = "POS_KND_ID"; string textStr_knd = "POS_KND_NAME"; string valueStr_biz = "POS_BIZ_ID"; string textStr_biz = "POS_BIZ_NAME"; string imageUrlDir = "../images/dept_icon/"; Biz_PositionKinds posKind = new Biz_PositionKinds(); DataTable dtKnd = posKind.GetPositionKinds().Tables[0]; Biz_PositionKindBizMaps posKndBiz = new Biz_PositionKindBizMaps(); DataTable dtKndBiz = posKndBiz.GetPosKndBizMaps().Tables[0]; TreeNode rootNode = CreateNode("", "Root", imageUrlDir + "purple/R.gif", true, TreeNodeSelectAction.None, false); treeView.Nodes.Add(rootNode); foreach (DataRow dbRowKnd in dtKnd.Rows) { TreeNode newNode = CreateNode(dbRowKnd[valueStr_knd].ToString() , dbRowKnd[textStr_knd].ToString() , imageUrlDir + "blue/k.gif" , false , TreeNodeSelectAction.Expand , false); rootNode.ChildNodes.Add(newNode); DataRow[] drArrBiz = dtKndBiz.Select(string.Format(@"POS_KND_ID = '{0}'", dbRowKnd["POS_KND_ID"])); foreach (DataRow drBiz in drArrBiz) { TreeNode newChildNode = CreateNode(drBiz[valueStr_biz].ToString() , drBiz[textStr_biz].ToString() , imageUrlDir + "red/b.gif" , false , TreeNodeSelectAction.Select , false); newNode.ChildNodes.Add(newChildNode); } } }
protected void ibnSave_Click(object sender, ImageClickEventArgs e) { string strIdxs = UltraGridUtility.GetCheckBoxValues(UltraWebGrid3 , "CHK_BOX" , "cBox" , "POS_BIZ_ID"); string[] pos_biz_ids = strIdxs.Substring(0, strIdxs.Length - 1).Split(';'); Biz_PositionKindBizMaps positionKindBizMap = new Biz_PositionKindBizMaps(); DataTable dataTable = positionKindBizMap.GetDataTableSchema(); DataRow row = null; for (int i = 0; i < pos_biz_ids.Length; i++) { DataRow dataRow = dataTable.NewRow(); dataRow["POS_KND_ID"] = this.hdfPoskndID.Value; dataRow["POS_BIZ_ID"] = pos_biz_ids[i].ToString(); dataRow["DATE"] = DateTime.Now; dataRow["USER"] = gUserInfo.Emp_Ref_ID; dataTable.Rows.Add(dataRow); } bool bResult = positionKindBizMap.ModifyPosKndBizMap(this.hdfPoskndID.Value, dataTable); if (bResult) { SelectBizGridBinding(hdfPoskndID.Value); KndBizMapGridBinding(); } else { ltrScript.Text = JSHelper.GetAlertBackScript("수정되지 않았습니다."); return; } }