/// <summary>
/// 数据绑定
/// </summary>
protected void databind()
{
E_Enterprise data = new E_Enterprise();
data.EnterpriseID = EnterpriceID;
data = new T_Enterprise().GetModel(data);
if (data != null)
{
ltEPCode.Text = data.EnterpriseCode;
ltEPName.Text = data.EnterpriseNames;
txtAddress.Text = data.Address;
txtEmail.Text = data.Email;
txtFax.Text = data.Fax;
txtItemName.Text = data.ItemName;
txtLinkman.Text = data.Linkman;
txtMobile.Text = data.Mobile;
txtPosition.Text = data.Position;
txtTel.Text = data.Tel;
txtStartDate.Text = Convert.ToDateTime(data.StartDate).ToString("yyyy-MM-dd");
txtExpireDate.Text = Convert.ToDateTime(data.ExpireDate).ToString("yyyy-MM-dd");
txtUserNum.Text = data.UserNum.ToString();
txtUserName.Text = data.AdminUserName;
//txtPassword.Text = data.AdminPassword;
}
}
protected void databind(int enterpriseid)
{
E_Enterprise data = new E_Enterprise();
data.EnterpriseID = enterpriseid;
data = new T_Enterprise().GetModel(data);
if (data == null)
{
return;
}
txtEnterpriseNames.Text = data.EnterpriseNames;
txtLinkman.Text = data.Linkman;
txtPosition.Text = data.Position;
txtTel.Text = data.Tel;
txtEmail.Text = data.Email;
txtMobile.Text = data.Mobile;
txtFax.Text = data.Fax;
txtAddress.Text = data.Address;
txtUserAmount.Text = data.UserAmount.ToString();
txtStartDate.Text = data.StartDate.ToString();
txtExpireDate.Text = data.ExpireDate.ToString();
txtUserNum.Text = data.UserNum.ToString();
txtClientNum.Text = data.ClientNum.ToString();
txtUserName.Text = data.AdminUserName;
txtPassword.Text = data.AdminPassword;
}
//点击修改按钮处理事件
protected void btnSubmit_Click(object sender, EventArgs e)
{
E_Enterprise data = new E_Enterprise();
data.EnterpriseID = EnterpriceID;
data.ItemName = txtItemName.Text;
data.Position = txtPosition.Text;
data.Tel = txtTel.Text;
data.Email = txtEmail.Text;
data.Mobile = txtMobile.Text;
data.Fax = txtFax.Text;
data.Address = txtAddress.Text;
data.Linkman = txtLinkman.Text;
string password = txtPassword.Text.Trim();
data.AdminPassword = string.IsNullOrEmpty(password)?"":MLMGC.COMP.EncryptString.EncryptPassword(password);
bool flag = new T_Enterprise().Update(data);
if (flag)
{
//添加操作日志
new MLMGC.BLL.Enterprise.T_Log().Add(new MLMGC.DataEntity.Enterprise.E_Log()
{
EnterpriseID = EnterpriceID, UserID = UserID, LogTitle = "修改企业基本信息", IP = MLMGC.COMP.Requests.GetRealIP()
});
MLMGC.COMP.Jscript.ShowMsg("修改成功", this);
}
else
{
MLMGC.COMP.Jscript.ShowMsg("修改失败", this);
}
}
/// <summary>
/// 数据绑定
/// </summary>
/// <param name="enterpriseid"></param>
protected void databind(int enterpriseid)
{
E_Enterprise data = new E_Enterprise();
data.EnterpriseID = enterpriseid;
data = new T_Enterprise().GetModel(data);
if (data == null)
{
return;
}
txtEPCode.Enabled = false;
txtEPCode.Text = data.EnterpriseCode;
txtEPName.Text = data.EnterpriseNames;
txtItemName.Text = data.ItemName;
txtLinkman.Text = data.Linkman;
txtPosition.Text = data.Position;
txtTel.Text = data.Tel;
txtEmail.Text = data.Email;
txtMobile.Text = data.Mobile;
txtFax.Text = data.Fax;
txtAddress.Text = data.Address;
txtUserAmount.Text = data.UserAmount.ToString();
txtStartDate.Text = Convert.ToDateTime(data.StartDate ?? DateTime.Now).ToShortDateString();
txtEndDate.Text = Convert.ToDateTime(data.ExpireDate ?? DateTime.Now).ToShortDateString();
txtAdminUserName.Text = data.AdminUserName;
//txtAdminPassword.Text = data.AdminPassword;
}
/// <summary>
/// 管理员修改企业基本信息
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-12-02</remarks>
public bool Update(E_Enterprise data)
{
int rowsAffected = 0;
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@EnterpriseID", SqlDbType.Int),
new SqlParameter("@ItemName", SqlDbType.VarChar, 128),
new SqlParameter("@Linkman", SqlDbType.VarChar, 64),
new SqlParameter("@Position", SqlDbType.VarChar, 64),
new SqlParameter("@Tel", SqlDbType.VarChar, 32),
new SqlParameter("@Mobile", SqlDbType.VarChar, 32),
new SqlParameter("@Fax", SqlDbType.VarChar, 32),
new SqlParameter("@Email", SqlDbType.VarChar, 128),
new SqlParameter("@Address", SqlDbType.VarChar, 128),
new SqlParameter("@Password", SqlDbType.VarChar, 128)
};
parms[0].Value = data.EnterpriseID;
parms[1].Value = data.ItemName;
parms[2].Value = data.Linkman;
parms[3].Value = data.Position;
parms[4].Value = data.Tel;
parms[5].Value = data.Mobile;
parms[6].Value = data.Fax;
parms[7].Value = data.Email;
parms[8].Value = data.Address;
parms[9].Value = data.AdminPassword;
DbHelperSQL.RunProcedures("ProcEP_B_EnterpriseS_Update", parms, out rowsAffected);
return(rowsAffected > 0);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
//获取界面数据
E_Enterprise data = new E_Enterprise();
data.EnterpriseCode = txtEPCode.Text.Trim();
data.EnterpriseNames = txtEPName.Text.Trim();
data.ItemName = txtItemName.Text.Trim();
data.Linkman = txtLinkman.Text.Trim();
data.Position = txtPosition.Text.Trim();
data.Tel = txtTel.Text.Trim();
data.Mobile = txtMobile.Text.Trim();
data.Fax = txtFax.Text.Trim();
data.Email = txtEmail.Text.Trim();
data.Address = txtAddress.Text.Trim();
data.UserAmount = int.Parse(txtUserAmount.Text.Trim());
data.StartDate = DateTime.Parse(txtStartDate.Text.Trim());
data.ExpireDate = DateTime.Parse(txtEndDate.Text.Trim());
data.AdminUserName = txtAdminUserName.Text.Trim();
string password = txtAdminPassword.Text.Trim();
data.AdminPassword = string.IsNullOrEmpty(password)?"":EncryptString.EncryptPassword(password);
if (type == "update")
{
int enterpriseid = Requests.GetQueryInt("eid", 0);
data.EnterpriseID = enterpriseid;
bool b = new T_Enterprise().AdminUpdate(data);
//MLMGC.COMP.Jscript.ShowMsg("修改" + (b ? "成功" : "失败"), this);
if (b)
{
MLMGC.COMP.Jscript.AlertAndRedirect(this, "修改成功", "List.aspx");
}
else
{
MLMGC.COMP.Jscript.ShowMsg("修改失败", this);
}
}
else
{
if (string.IsNullOrEmpty(data.AdminPassword))
{
MLMGC.COMP.Jscript.ShowMsg("第一次操作，请输入密码", this);
return;
}
int result = new T_Enterprise().Add(data);
if (result > 0)
{
MLMGC.COMP.Jscript.AlertAndRedirect(this, "添加成功", "List.aspx");
}
else if (result == -2)
{
MLMGC.COMP.Jscript.ShowMsg("请创建或设置默认数据库", this);
}
else
{
MLMGC.COMP.Jscript.ShowMsg("添加失败", this);
}
}
}
/// <summary>
/// 删除企业
/// </summary>
/// <remarks>tianzhenyun 2011-12-02</remarks>
public void Delete()
{
int enterpriseid = Convert.ToInt32(nv["eid"]);
E_Enterprise data = new E_Enterprise();
data.EnterpriseID = enterpriseid;
bool flag = new T_Enterprise().Delete(data);
HttpContext.Current.Response.Write(flag ? "1" : "0");
}
/// <summary>
/// 更新企业状态
/// </summary>
/// <remarks>tianzhenyun 2011-11-03</remarks>
public void StatusUpdate()
{
int enterpriseid = Convert.ToInt32(nv["eid"]);
int status = Convert.ToInt32(nv["status"]);
E_Enterprise data = new E_Enterprise();
data.EnterpriseID = enterpriseid;
data.Status = status;
bool flag = new T_Enterprise().StatusUpdate(data);
HttpContext.Current.Response.Write(flag ? "1" : "0");
}
/// <summary>
/// 验证企业号是否存在
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public bool Exist(E_Enterprise data)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@EnterpriseCode", SqlDbType.VarChar, 32)
};
parms[0].Value = data.EnterpriseCode;
int ReturnValue = 0;
DbHelperSQL.RunProcedures("ProcEP_B_Enterprise_Exist", parms, out ReturnValue);
return(ReturnValue > 0);
}
/// <summary>
/// 删除企业
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 20111-12-02</remarks>
public bool Delete(E_Enterprise data)
{
int rowsAffected = 0;
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@EnterpriseID", SqlDbType.Int)
};
parms[0].Value = data.EnterpriseID;
DbHelperSQL.RunProcedures("ProcEP_B_EnterpriseS_Delete", parms, out rowsAffected);
return(rowsAffected > 0);
}
/// <summary>
/// 管理员修改企业状态
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-11-02</remarks>
public bool StatusUpdate(E_Enterprise data)
{
SqlParameter[] parms =
{
new SqlParameter("@EnterpriseID", SqlDbType.Int),
new SqlParameter("@Status", SqlDbType.TinyInt)
};
parms[0].Value = data.EnterpriseID;
parms[1].Value = data.Status;
int ReturnValue;
DbHelperSQL.RunProcedures("ProcEP_B_Enterprise_StatusUpdate", parms, out ReturnValue);
return(ReturnValue > 0);
}
protected void databind()
{
E_EnterpriseUser data = new E_EnterpriseUser();
data.UserID = UserID;
data.EnterpriseID = EnterpriceID;
data.EPUserTMRID = EPUserTMRID;
DataTable dt = new T_User().GetUserSelectRole(data);
if (dt != null && dt.Rows.Count >= 1)
{
//var v = from a in dt.Rows where a["EPUserTMRID"] = EPUserTMRID select new { Team=a["TeamName"],Role=a["RoleName"]};
DataRow [] dr = dt.Select("EPUserTMRID =" + EPUserTMRID);
if (dr.Length > 0)
{
//ltCurRole.Text = dr[0]["RoleName"].ToString();
//ltCurTeam.Text = dr[0]["TeamName"].ToString();
hlRole.Text = dr[0]["RoleName"].ToString();
}
hlRole.NavigateUrl = dt.Rows.Count > 1 ? "selectrole.aspx" : "javascript:void(0);";
//DataRow[] rows = dt.Select("EPUserTMRID <>" + EPUserTMRID);
//var v = from a in rows select new { TeamName = a["TeamName"], RoleName = a["RoleName"], TeamID = a["TeamID"], EPUserTMRID = a["EPUserTMRID"], RoleID = a["RoleID"] };
//rpRole.DataSource = v;
//rpRole.DataBind();
}
//获取企业基本信息
E_Enterprise dataEP = new E_Enterprise {
EnterpriseID = EnterpriceID
};
dataEP = new T_Enterprise().Get(dataEP);
if (dataEP != null)
{
epName.Text = dataEP.EnterpriseNames;
epLinkman.Text = dataEP.Linkman;
epTel.Text = dataEP.Tel;
epItemName.Text = dataEP.ItemName ?? "";
}
}
/// <summary>
/// 添加新企业
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public int Add(E_Enterprise data)
{
int rowsAffected = 0;
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@EnterpriseCode", SqlDbType.VarChar, 32),
new SqlParameter("@EnterpriseNames", SqlDbType.VarChar, 128),
new SqlParameter("@ItemName", SqlDbType.VarChar, 128),
new SqlParameter("@Linkman", SqlDbType.VarChar, 64),
new SqlParameter("@Position", SqlDbType.VarChar, 64),
new SqlParameter("@Tel", SqlDbType.VarChar, 32),
new SqlParameter("@Mobile", SqlDbType.VarChar, 32),
new SqlParameter("@Fax", SqlDbType.VarChar, 32),
new SqlParameter("@Email", SqlDbType.VarChar, 128),
new SqlParameter("@Address", SqlDbType.VarChar, 128),
new SqlParameter("@UserAmount", SqlDbType.Int),
new SqlParameter("@StartDate", SqlDbType.SmallDateTime),
new SqlParameter("@ExpireDate", SqlDbType.SmallDateTime),
new SqlParameter("@AdminUserName", SqlDbType.VarChar, 64), //管理员帐号
new SqlParameter("@AdminPassword", SqlDbType.VarChar, 64) //管理员密码
};
parms[0].Value = data.EnterpriseCode;
parms[1].Value = data.EnterpriseNames;
parms[2].Value = data.ItemName;
parms[3].Value = data.Linkman;
parms[4].Value = data.Position;
parms[5].Value = data.Tel;
parms[6].Value = data.Mobile;
parms[7].Value = data.Fax;
parms[8].Value = data.Email;
parms[9].Value = data.Address;
parms[10].Value = data.UserAmount;
parms[11].Value = data.StartDate;
parms[12].Value = data.ExpireDate;
parms[13].Value = data.AdminUserName;
parms[14].Value = data.AdminPassword;
DbHelperSQL.RunProcedures("ProcEP_B_EnterpriseS_Insert", parms, out rowsAffected);
return(rowsAffected);
}
/// <summary>
/// 管理员查看企业详细信息
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-11-03</remarks>
public E_Enterprise GetModel(E_Enterprise data)
{
SqlParameter[] parms =
{
new SqlParameter("@EnterpriseID", SqlDbType.Int)
};
parms[0].Value = data.EnterpriseID;
DataTable dt = DbHelperSQL.RunProcedureTable("ProcEP_B_EnterpriseS_DataSelect", parms);
if (dt != null && dt.Rows.Count == 1)
{
DataRow row = dt.Rows[0];
data.EnterpriseCode = row["EnterpriseCode"].ToString();
data.EnterpriseNames = row["EnterpriseNames"].ToString();
data.Linkman = row["Linkman"] != null ? row["Linkman"].ToString() : string.Empty;
data.Position = row["Position"] != null ? row["Position"].ToString() : string.Empty;
data.Tel = row["Tel"] != null ? row["Tel"].ToString() : string.Empty;
data.Email = row["Email"] != null ? row["Email"].ToString() : string.Empty;
data.Mobile = row["Mobile"] != null ? row["Mobile"].ToString() : string.Empty;
data.Fax = row["Fax"] != null ? row["Fax"].ToString() : string.Empty;
data.Address = row["Address"] != null ? row["Address"].ToString() : string.Empty;
data.UserAmount = row["UserAmount"] != null?Convert.ToInt32(row["UserAmount"]) : 0;
data.UserNum = row["UserNum"] != null?Convert.ToInt32(row["UserNum"]) : 0;
data.ClientNum = row["ClientNum"] != null?Convert.ToInt32(row["ClientNum"]) : 0;
data.StartDate = row["StartDate"] != null?Convert.ToDateTime(row["StartDate"]) : DateTime.Now;
data.ExpireDate = row["ExpireDate"] != null?Convert.ToDateTime(row["ExpireDate"]) : DateTime.Now;
data.AdminUserName = row["AdminUserName"] != null ? row["AdminUserName"].ToString() : string.Empty;
data.AdminPassword = row["AdminPassword"] != null ? row["AdminPassword"].ToString() : string.Empty;
data.ItemName = row["ItemName"] != null ? row["ItemName"].ToString() : string.Empty;
return(data);
}
return(null);
}
/// <summary>
/// 数据绑定
/// </summary>
protected void databind()
{
day = Requests.GetQueryInt("day", MLMGC.COMP.Config.WarningDay);
txtDay.Text = day.ToString();
E_Enterprise data = new E_Enterprise();
data.EnterpriseNames = Requests.GetQueryString("enterprisenames");
txtEnterpriseNames.Text = data.EnterpriseNames;
string start = Requests.GetQueryString("startdate");
string end = Requests.GetQueryString("enddate");
txtStartDate.Value = start;
txtEndDate.Value = end;
data.Page = new MLMGC.DataEntity.E_Page();
if (start != "")
{
data.Page.StartDate = Convert.ToDateTime(start);
}
if (end != "")
{
data.Page.EndDate = Convert.ToDateTime(end);
}
//分页参数
data.Page.PageSize = pageSize;
data.Page.PageIndex = pageIndex;
rpList.DataSource = new T_Enterprise().GetList(data);
rpList.DataBind();
//设置分页样式
pageList1.PageSize = pageSize;
pageList1.CurrentPageIndex = pageIndex;
pageList1.RecordCount = data.Page.TotalCount;
pageList1.CustomInfoHTML = string.Format("共有记录 <span class='red_font'>{0}</span> 条", pageList1.RecordCount);
pageList1.TextAfterPageIndexBox = " 页/" + pageList1.PageCount + " ";
}
/// <summary>
/// 管理员查看企业用户列表
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-11-02</remarks>
public DataTable GetList(E_Enterprise data)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@EnterpriseNames", SqlDbType.VarChar, 128),
new SqlParameter("@StartDate", SqlDbType.SmallDateTime),
new SqlParameter("@EndDate", SqlDbType.SmallDateTime),
new SqlParameter("@PageIndex", SqlDbType.Int),
new SqlParameter("@PageSize", SqlDbType.Int),
new SqlParameter("@TotalCount", SqlDbType.Int)
};
parms[0].Value = data.EnterpriseNames;
parms[1].Value = data.Page.StartDate;
parms[2].Value = data.Page.EndDate;
parms[3].Value = data.Page.PageIndex;
parms[4].Value = data.Page.PageSize;
parms[5].Direction = ParameterDirection.Output;
DataTable dt = DbHelperSQL.RunProcedureTable("ProcEP_B_EnterpriseS_ListSelect", parms);
data.Page.TotalCount = parms[5].Value == DBNull.Value ? 0 : Convert.ToInt32(parms[5].Value);
return(dt);
}
/// <summary>
/// 获取一个企业的基本信息
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>2011-11-21改 田振运添加一些字段</remarks>
public E_Enterprise Get(E_Enterprise data)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@EnterpriseID", SqlDbType.Int)
};
parms[0].Value = data.EnterpriseID;
DataTable dt = DbHelperSQL.RunProcedureTable("ProcEP_B_Enterprise_Select", parms);
if (dt != null && dt.Rows.Count > 0)
{
DataRow row = dt.Rows[0];
data.EnterpriseID = int.Parse(row["EnterpriseID"].ToString());
data.EnterpriseCode = row["EnterpriseCode"].ToString();
data.EnterpriseNames = row["EnterpriseNames"].ToString();
data.UserAmount = int.Parse(row["UserAmount"].ToString());
//2011-11-21改
data.Linkman = row["Linkman"].ToString();
data.Tel = row["Tel"].ToString();
data.ItemName = row["ItemName"].ToString();
data.StartDate = Convert.ToDateTime(row["StartDate"]);
data.ExpireDate = Convert.ToDateTime(row["ExpireDate"]);
//2011-12-02加
data.Position = row["Position"].ToString();
data.Mobile = row["Mobile"].ToString();
data.Fax = row["Fax"].ToString();
data.Email = row["Email"].ToString();
data.Address = row["Address"].ToString();
}
else
{
data = null;
}
return(data);
}
/// <summary>
/// 判断企业号是否存在
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public bool Exist(E_Enterprise data)
{
return(dal.Exist(data));
}
/// <summary>
/// 后台管理员修改企业基本信息
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-02-09</remarks>
public bool AdminUpdate(E_Enterprise data)
{
return(dal.AdminUpdate(data));
}
/// <summary>
/// 删除企业
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 20111-12-02</remarks>
public bool Delete(E_Enterprise data)
{
return(dal.Delete(data));
}
/// <summary>
/// 获取一个企业的基本信息
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public E_Enterprise Get(E_Enterprise data)
{
return(dal.Get(data));
}
protected void databind()
{
kid = RoleID;
//读取用户头像:若没有设置头像则根据性别选择默认的头像
E_User dataAvatar = new E_User();
dataAvatar.EnterpriseID = EnterpriceID;
dataAvatar.UserID = UserID;
dataAvatar = new T_User().GetEPModel(dataAvatar);
if (dataAvatar != null)
{
string url = dataAvatar.Avatar == "" ? "/images/guanliyuan.jpg" :MLMGC.COMP.Config.GetEnterpriseAvatarUrl(dataAvatar.Avatar);
imgAvatar.ImageUrl = url;
}
E_EnterpriseUser data = new E_EnterpriseUser();
data.UserID = UserID;
data.EnterpriseID = EnterpriceID;
data.EPUserTMRID = EPUserTMRID;
ShowReservationTip = (RoleID == ((int)EnumRole.销售人员));
DataTable dt = new T_User().GetUserSelectRole(data);
if (dt != null && dt.Rows.Count >= 1)
{
//var v = from a in dt.Rows where a["EPUserTMRID"] = EPUserTMRID select new { Team=a["TeamName"],Role=a["RoleName"]};
DataRow [] dr = dt.Select("EPUserTMRID =" + EPUserTMRID);
if (dr.Length > 0)
{
ltCurRole.Text = dr[0]["RoleName"].ToString();
ltCurTeam.Text = dr[0]["TeamName"].ToString();
ltRole.Text = dr[0]["RoleName"].ToString();
lblRole.Text = dr[0]["RoleName"].ToString();
ltTrueName.Text = dr[0]["TrueName"].ToString();
//main.Attributes.Add("src", string.Format("main/main{0}.aspx", dr[0]["RoleID"].ToString()=="1"?"1":"2"));
int firstlogin = Convert.ToInt32(dr[0]["FirstLogin"]);
if (firstlogin == 0)
{
ShowTip = true;
}
}
DataRow [] rows = dt.Select("EPUserTMRID <>" + EPUserTMRID);
var v = from a in rows select new { TeamName = a["TeamName"], RoleName = a["RoleName"], TeamID = a["TeamID"], EPUserTMRID = a["EPUserTMRID"], RoleID = a["RoleID"] };
rpRole.DataSource = v;
rpRole.DataBind();
}
//获取企业基本信息
E_Enterprise dataEP = new E_Enterprise {
EnterpriseID = EnterpriceID
};
dataEP = new T_Enterprise().Get(dataEP);
if (dataEP != null)
{
epName.Text = dataEP.EnterpriseNames;
epLinkman.Text = dataEP.Linkman;
epTel.Text = dataEP.Tel;
epItemName.Text = dataEP.ItemName ?? "";
}
//绑定菜单
//获取所有的菜单
dtMenu = new T_User().GetMenuList(new E_EnterpriseUser()
{
EPUserTMRID = base.EPUserTMRID, EnterpriseID = EnterpriceID, UserID = UserID
});
////查找一级节点
//DataRow[] rowFirst = dtMenu.Select("DeptID = 0");
//rpFirstMenu.DataSource = from a in rowFirst select new { MenuID = a["MenuID"], Url = a["Url"], MenuName = a["MenuName"], PID = a["PID"] };
//rpFirstMenu.DataBind();
////查找二级节点
//DataRow[] rowSecond = dtMenu.Select("DeptID=1");
//rpSecondMenu.DataSource = from a in rowSecond select new { MenuID = a["MenuID"], Url = a["Url"], MenuName = a["MenuName"], PID = a["PID"] };
//rpSecondMenu.DataBind();
//查找一级节点
IEnumerable <System.Data.DataRow> firstNode =
from item in dtMenu.AsEnumerable()
where item.Field <byte>("DeptID") == 0
select item;
rpFirstMenu.DataSource = firstNode.CopyToDataTable <DataRow>();
rpFirstMenu.DataBind();
//查找二级节点
IEnumerable <System.Data.DataRow> secondNode =
from item in dtMenu.AsEnumerable()
where item.Field <byte>("DeptID") == 1
select item;
rpSecondMenu.DataSource = secondNode.CopyToDataTable <DataRow>();
rpSecondMenu.DataBind();
}
/// <summary>
/// 管理员查看企业用户列表
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public DataTable GetList(E_Enterprise data)
{
return(dal.GetList(data));
}
/// <summary>
/// 管理员修改企业基本信息
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-12-02</remarks>
public bool Update(E_Enterprise data)
{
return(dal.Update(data));
}
/// <summary>
/// 管理员修改企业状态
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-11-02</remarks>
public bool StatusUpdate(E_Enterprise data)
{
return(dal.StatusUpdate(data));
}
/// <summary>
/// 管理员查看企业详细信息
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-11-03</remarks>
public E_Enterprise GetModel(E_Enterprise data)
{
return(dal.GetModel(data));
}
/// <summary>
/// 添加新企业
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public int Add(E_Enterprise data)
{
return(dal.Add(data));
}
