protected void Btn_OK_Click(object sender, EventArgs e)
{
me = new MapExt();
me.MyPK = this.FK_MapExt;
if (me.RetrieveFromDBSources() == 0)
{
BP.Web.Controls.FrmPopVal pv = new BP.Web.Controls.FrmPopVal(this.FK_MapExt);
me.Copy(pv);
}
int popValFormat = me.PopValFormat;
string val = "";
foreach (Control ctl in this.Pub1.Controls)
{
CheckBox cb = ctl as CheckBox;
if (cb == null)
{
continue;
}
if (cb.ID.Contains("CBs_"))
{
continue;
}
if (cb.Checked == false)
{
continue;
}
string text = cb.Text.Replace("<font color=green>", "");
text = cb.Text.Replace("</font>", "");
switch (popValFormat)
{
case 0: //仅仅编号
val += "," + cb.ID.Replace("CB_", "");
break;
case 1: // 仅名称
val += "," + text;
break;
case 2: // 编号与名称
val += "," + cb.ID.Replace("CB_", "") + "," + text;
break;
default:
break;
}
}
val = val.Replace("<font color=green>", "");
val = val.Replace("</font>", "");
if (val.Length > 2)
{
val = val.Substring(1);
}
this.WinClose(val);
}
protected void Page_Load(object sender, EventArgs e)
{
me = new MapExt();
me.MyPK = this.FK_MapExt;
if (me.RetrieveFromDBSources() == 0)
{
BP.Web.Controls.FrmPopVal pv = new BP.Web.Controls.FrmPopVal(this.FK_MapExt);
me.Copy(pv);
}
string sqlGroup = me.Tag1;
sqlGroup = sqlGroup.Replace("@WebUser.No", BP.Web.WebUser.No);
sqlGroup = sqlGroup.Replace("@WebUser.Name", BP.Web.WebUser.Name);
sqlGroup = sqlGroup.Replace("@WebUser.FK_Dept", BP.Web.WebUser.FK_Dept);
DataTable dtGroup = DBAccess.RunSQLReturnTable(sqlGroup);
if (dtGroup.Rows.Count == 0)
{
this.Pub1.AddFieldSet("配置错误", "分组数据源为空:" + sqlGroup);
return;
}
this.Left.AddUL();
foreach (DataRow dr in dtGroup.Rows)
{
string no = dr[0].ToString();
string name = dr[1].ToString();
this.Left.AddLi("<a href='FrmPopValDir.aspx?GroupVal=" + no + "&FK_MapExt=" + this.FK_MapExt + "&RefPK=" + this.RefPK + "&CtrlVal=" + this.CtrlVal + "' >" + dr[1].ToString() + "</a>");
}
this.Left.AddULEnd();
string gVal = this.GroupVal;
if (string.IsNullOrEmpty(gVal))
{
gVal = dtGroup.Rows[0][0].ToString();
}
string sqlObjs = me.Tag2;
sqlObjs = sqlObjs.Replace("@WebUser.No", BP.Web.WebUser.No);
sqlObjs = sqlObjs.Replace("@WebUser.Name", BP.Web.WebUser.Name);
sqlObjs = sqlObjs.Replace("@WebUser.FK_Dept", BP.Web.WebUser.FK_Dept);
sqlObjs = sqlObjs.Replace("@GroupVal", gVal);
DataTable dtObjs = DBAccess.RunSQLReturnTable(sqlObjs);
bool isCheckbox = false;
if (me.PopValSelectModel == 1)
{
isCheckbox = true;
}
foreach (DataRow dr in dtObjs.Rows)
{
string no = dr[0].ToString();
string name = dr[1].ToString();
if (isCheckbox == true)
{
CheckBox cb = new CheckBox();
cb.ID = "CB_" + no;
cb.Text = name;
this.Pub1.Add(cb);
}
else
{
RadioButton rb = new RadioButton();
rb.ID = "RB_" + no;
rb.Text = name;
rb.GroupName = "ss";
this.Pub1.Add(rb);
}
}
if (dtObjs.Rows.Count == 0)
{
this.Pub1.AddFieldSet("配置或者数据源错误", "查询的entity是空的:" + sqlObjs);
}
}
protected void Page_Load(object sender, EventArgs e)
{
me = new MapExt();
me.MyPK = this.FK_MapExt;
if (me.RetrieveFromDBSources() == 0)
{
BP.Web.Controls.FrmPopVal pv = new BP.Web.Controls.FrmPopVal(this.FK_MapExt);
me.Copy(pv);
}
if (me.PopValShowModel == 1)
{
this.Response.Redirect("FrmPopValDir.aspx?a=2" + this.RequestParas, true);
return;
}
bool isCheckBox = false;
if (me.PopValSelectModel == 0)
{
isCheckBox = true;
}
else
{
isCheckBox = false;
}
string sqlGroup = me.Tag1;
sqlGroup = sqlGroup.Replace("@WebUser.No", BP.Web.WebUser.No);
sqlGroup = sqlGroup.Replace("@WebUser.Name", BP.Web.WebUser.Name);
sqlGroup = sqlGroup.Replace("@WebUser.FK_Dept", BP.Web.WebUser.FK_Dept);
string sqlObjs = me.Tag2;
sqlObjs = sqlObjs.Replace("@WebUser.No", BP.Web.WebUser.No);
sqlObjs = sqlObjs.Replace("@WebUser.Name", BP.Web.WebUser.Name);
sqlObjs = sqlObjs.Replace("@WebUser.FK_Dept", BP.Web.WebUser.FK_Dept);
bool isHaveUnGroup = true;
DataTable dtGroup = new DataTable();
if (sqlGroup.Length > 5)
{
isHaveUnGroup = false;
dtGroup = BP.DA.DBAccess.RunSQLReturnTable(sqlGroup);
}
else
{
dtGroup.Columns.Add("No", typeof(string));
dtGroup.Columns.Add("Name", typeof(string));
DataRow dr = dtGroup.NewRow();
dr["No"] = "01";
dr["Name"] = "全部选择";
dtGroup.Rows.Add(dr);
}
DataTable dtObj = BP.DA.DBAccess.RunSQLReturnTable(sqlObjs);
if (dtObj.Columns.Count == 2)
{
dtObj.Columns.Add("Group", typeof(string));
foreach (DataRow dr in dtObj.Rows)
{
dr["Group"] = "01";
}
}
int cols = 4;
this.Pub1.AddTable("width=95% border=0");
if (isHaveUnGroup == false)
{
foreach (DataRow drGroup in dtGroup.Rows)
{
string ctlIDs = "";
string groupNo = drGroup[0].ToString();
//增加全部选择.
this.Pub1.AddTR();
CheckBox cbx = new CheckBox();
cbx.ID = "CBs_" + drGroup[0].ToString();
cbx.Text = drGroup[1].ToString();
this.Pub1.AddTDTitle("align=left", cbx);
this.Pub1.AddTREnd();
this.Pub1.AddTR();
this.Pub1.AddTDBegin("nowarp=false");
this.Pub1.AddTable("border=0");
int colIdx = -1;
foreach (DataRow drObj in dtObj.Rows)
{
string no = drObj[0].ToString();
string name = drObj[1].ToString();
string group = drObj[2].ToString();
if (group.Trim() != groupNo.Trim())
{
continue;
}
colIdx++;
if (colIdx == 0)
{
this.Pub1.AddTR();
}
CheckBox cb = new CheckBox();
cb.ID = "CB_" + no;
ctlIDs += cb.ID + ",";
cb.Attributes["onclick"] = "isChange=true;";
cb.Text = name;
cb.Checked = this.CtrlVal.Contains("," + no + ",");
if (cb.Checked)
{
cb.Text = "<font color=green>" + cb.Text + "</font>";
}
this.Pub1.AddTD(cb);
if (cols - 1 == colIdx)
{
this.Pub1.AddTREnd();
colIdx = -1;
}
}
cbx.Attributes["onclick"] = "SetSelected(this,'" + ctlIDs + "')";
if (colIdx != -1)
{
while (colIdx != cols - 1)
{
colIdx++;
this.Pub1.AddTD();
}
this.Pub1.AddTREnd();
}
this.Pub1.AddTableEnd();
this.Pub1.AddTDEnd();
this.Pub1.AddTREnd();
}
}
#region 处理未分组的情况.
if (isHaveUnGroup == true)
{
this.Pub1.AddTR();
this.Pub1.AddTDBigDocBegain(); // ("nowarp=true");
this.Pub1.AddTable();
int colIdx = -1;
string ctlIDs = "";
//增加全部选择.
this.Pub1.AddTR();
CheckBox cbx = new CheckBox();
cbx.ID = "CBs_" + dtGroup.Rows[0][0].ToString();
cbx.Text = dtGroup.Rows[0][1].ToString();
this.Pub1.AddTDTitle("align=left colspan=4", cbx);
this.Pub1.AddTREnd();
foreach (DataRow drObj in dtObj.Rows)
{
string group = drObj[2].ToString();
isHaveUnGroup = true;
foreach (DataRow drGroup in dtGroup.Rows)
{
string groupNo = drGroup[0].ToString();
if (group != groupNo)
{
isHaveUnGroup = true;
break;
}
}
if (isHaveUnGroup == false)
{
continue;
}
string no = drObj[0].ToString();
string name = drObj[1].ToString();
colIdx++;
if (colIdx == 0)
{
this.Pub1.AddTR();
}
CheckBox cb = new CheckBox();
cb.ID = "CB_" + no;
ctlIDs += cb.ID + ",";
cb.Text = name + group;
cb.Checked = this.CtrlVal.Contains("," + no + ",");
if (cb.Checked)
{
cb.Text = "<font color=green>" + cb.Text + "</font>";
}
this.Pub1.AddTD(cb);
if (cols - 1 == colIdx)
{
this.Pub1.AddTREnd();
colIdx = -1;
}
}
cbx.Attributes["onclick"] = "SetSelected(this,'" + ctlIDs + "')";
if (colIdx != -1)
{
while (colIdx != cols - 1)
{
colIdx++;
this.Pub1.AddTD();
}
this.Pub1.AddTREnd();
}
this.Pub1.AddTableEnd();
this.Pub1.AddTDEnd();
this.Pub1.AddTREnd();
}
#endregion 处理未分组的情况.
this.Pub1.AddTableEnd();
Button btn = new Button();
btn.ID = "s";
btn.Text = " OK ";
btn.Click += new EventHandler(btn_Click);
this.Pub1.Add(btn);
btn = new Button();
btn.ID = "Cancel";
btn.Text = " Cancel ";
btn.Click += new EventHandler(btn_Click);
this.Pub1.Add(btn);
}
