public void DataBindEx()
{
DigiPower.Onlinecol.Standard.BLL.UserOperate bll = new DigiPower.Onlinecol.Standard.BLL.UserOperate();
DataSet list1 = bll.GetDepartmentList("select SystemInfoID,SystemInfoName from T_SystemInfo where CurrentType = 'SplitString'");
DropDownList1.DataTextField = "SystemInfoName";
DropDownList1.DataValueField = "SystemInfoID";
DropDownList1.DataSource = list1;
DropDownList1.DataBind();
}
public void DataBindEx()
{
DigiPower.Onlinecol.Standard.BLL.UserOperate bll = new DigiPower.Onlinecol.Standard.BLL.UserOperate();
DataSet list1 = bll.GetDepartmentList("select CanDefineTypeID,ShowName from vwDefineType where DefineTypeID = " + _InfoID + "");
DropDownList1.DataTextField = "ShowName";
DropDownList1.DataValueField = "CanDefineTypeID";
DropDownList1.DataSource = list1;
DropDownList1.DataBind();
}
/// <summary>
/// 绑定列表
/// </summary>
private void BindGridView()
{
DigiPower.Onlinecol.Standard.BLL.UserOperate ubll = new DigiPower.Onlinecol.Standard.BLL.UserOperate();
DataSet ds = new DataSet();
if (ViewState["sqlwhere"] != null && !String.IsNullOrEmpty(ViewState["sqlwhere"].ToString()))
{
ds = ubll.GetDepartmentList("select * from vwDefine where " + ViewState["sqlwhere"].ToString());
}
else if (!String.IsNullOrEmpty(SqlWhere))
{
ds = ubll.GetDepartmentList("select * from vwDefine where " + SqlWhere);
}
else
{
ds = ubll.GetDepartmentList("select * from vwDefine where " + "1=1");
}
List <string> l1 = new List <string>();
l1.Add("MainType");
l1.Add("Split");
l1.Add("TableName");
l1.Add("FieldName");
l1.Add("ShowName");
l1.Add("StartLocation");
l1.Add("EndLocation");
l1.Add("IsSerial");
ctrlGridEx1.InitGrid("DefineResultID", l1, ds, "~/SystemManage/DefinedAdd.aspx?Action=Edit");
}
protected void Page_Load(object sender, EventArgs e)
{
MyAddInit();
if (!this.IsPostBack)
{
DigiPower.Onlinecol.Standard.BLL.UserOperate ubll = new DigiPower.Onlinecol.Standard.BLL.UserOperate();
if (Action.ToLower().Equals("edit"))
{
DataSet ds = new DataSet();
ds = ubll.GetDepartmentList("select * from vwDefine where DefineResultID = " + ID + "");
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
CanDefineTypeID.InfoID = ds.Tables[0].Rows[0]["SystemInfoID"].ToString();
CanDefineTypeID.DataBindEx();
CutLength.StartLocation = Common.ConvertEx.ToInt(ds.Tables[0].Rows[0]["StartLocation"].ToString());
CutLength.EndLocation = Common.ConvertEx.ToInt(ds.Tables[0].Rows[0]["EndLocation"].ToString());
CutLength.DataBindEx();
}
}
if (Action.ToLower().Equals("add"))
{
CanDefineTypeID.InfoID = ID;
CanDefineTypeID.DataBindEx();
CutLength.StartLocation = 0;
CutLength.EndLocation = 10;
CutLength.DataBindEx();
}
if (!String.IsNullOrEmpty(Action))
{
//给当前页面操作状态赋值
if (Action.ToLower().Equals("add"))
{
ViewState["ps"] = CommonEnum.PageState.ADD;
}
if (Action.ToLower().Equals("edit"))
{
ViewState["ps"] = CommonEnum.PageState.EDIT;
}
}
if ((CommonEnum.PageState)ViewState["ps"] == CommonEnum.PageState.EDIT)
{
if (!String.IsNullOrEmpty(ID))
{
BindPage(ID);
}
}
}
}
