private void DataBindGrid()
{
int count = 0;
StringBuilder SqlWhere = new StringBuilder();
IList <SqlParam> IList_param = new List <SqlParam>();
SqlWhere.Append(" WHERE MsgTitle<>'注册成功' ");
if (!string.IsNullOrEmpty(this.MsgSender.Value))
{
SqlWhere.AppendFormat(" AND MsgSender='{0}' ", this.MsgSender.Value);
}
if (!string.IsNullOrEmpty(this.MsgType.Value))
{
SqlWhere.AppendFormat(" AND MsgType='{0}' ", this.MsgType.Value);
}
if (!string.IsNullOrEmpty(this.ISRead.Value))
{
SqlWhere.AppendFormat(" AND ISRead='{0}' ", this.ISRead.Value);
}
if (!string.IsNullOrEmpty(this.txt_Search.Value))
{
SqlWhere.Append(" AND U." + this.Searchwhere.Value + " like @obj ");
IList_param.Add(new SqlParam("@obj", '%' + this.txt_Search.Value.Trim() + '%'));
}
DataTable dt = this.peridal.GetMessageListPage(SqlWhere, IList_param, this.PageControl1.PageIndex, this.PageControl1.PageSize, ref count);
ControlBindHelper.BindRepeaterList(dt, this.rp_Item);
this.PageControl1.RecordCount = Convert.ToInt32(count);
this.PageControl1.PageChecking();
}
private void DataBindGrid()
{
int count = 0;
StringBuilder SqlWhere = new StringBuilder();
IList <SqlParam> IList_param = new List <SqlParam>();
//DataTable dt = DataFactory.SqlDataBase().GetDataTable("Base_ATS_OriDataIn");
string strSQL = "select Auto_Approval from Base_UserInfo where User_ID='" + EmpID + "' ";
StringBuilder sbSQL = new StringBuilder(strSQL);
DataTable dtSQL = DataFactory.SqlDataBase().GetDataTableBySQL(sbSQL);
if (dtSQL.Rows[0][0].ToString() == "1")
{
Auto_Approval.Value = "1";
}
else
{
Auto_Approval.Value = "0";
}
string sql = "select * from Base_PerTravelApply where (ApprovalFlag=0 or ApprovalFlag=1) and empid in (select User_ID from Base_UserInfo where boss_id='" + EmpID + "') ";
StringBuilder sb_sql = new StringBuilder(sql);
// DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(sb_sql);
DataTable dt = DataFactory.SqlDataBase().GetPageList(sql, null, "CreateDate", "asc", PageControl1.PageIndex, PageControl1.PageSize, ref count);
ControlBindHelper.BindRepeaterList(dt, rp_Item);
this.PageControl1.RecordCount = Convert.ToInt32(count);
}
private void DataBindGrid()
{
int count = 0;
StringBuilder SqlWhere = new StringBuilder();
IList <SqlParam> IList_param = new List <SqlParam>();
SqlWhere.Append(" WHERE 1=1 ");
if (!string.IsNullOrEmpty(this.companyName.Value))
{
SqlWhere.AppendFormat(" AND companyName='{0}' ", this.companyName.Value);
}
if (!string.IsNullOrEmpty(this.specName.Value))
{
SqlWhere.AppendFormat(" AND specName='{0}' ", this.specName.Value);
}
if (!string.IsNullOrEmpty(this.isLock.Value))
{
SqlWhere.AppendFormat(" AND isLock='{0}' ", this.isLock.Value);
}
DataTable dt = this.peridal.GetSpecialtyListPage(SqlWhere, IList_param, this.PageControl1.PageIndex, this.PageControl1.PageSize, ref count);
ControlBindHelper.BindRepeaterList(dt, this.rp_Item);
this.PageControl1.RecordCount = Convert.ToInt32(count);
this.PageControl1.PageChecking();
}
/// <summary>
/// GridView数据导入方法
/// </summary>
private void LoadData()
{
List <MMS_PurchasePlanContent> infoList = new List <MMS_PurchasePlanContent>();
//调用业务层方法取采购计划单列表
infoList = PurchasePlanService.Instance.GetAllInfo();
RM.Busines.DAL.RM_UserInfo_Dal daluser = new Busines.DAL.RM_UserInfo_Dal();
//取所有的字典信息
List <Base_DictionaryInfo> dictList = DictionaryInfoService.Instance.GetAllInfo();
var query = from info in infoList
where ((info.AuditFlag == null || info.AuditFlag == false) && info.PayMode == "2" && info.PurchaseMan.Contains(RequestSession.GetSessionUser().UserAccount.ToString().Trim())) || (info.PayMode == "1" && info.InvoiceType.Contains(RequestSession.GetSessionUser().UserAccount.ToString().Trim()))
select new
{
id = info.ID,
info.PurchaseBillCode,
info.PurchaseMan,
info.PurchaseDate,
info.InvoiceCode,
info.DeptName,
info.AuditFlag,
info.PayMode,
Operator = daluser.GetUserInfo(info.Operator).Rows[0]["User_Name"].ToString().Trim()
};
DataTable dt = DataTableHelper.CopyToDataTable(query);
ControlBindHelper.BindRepeaterList(dt, this.rp_Item);
//dgvInfo.DataKeyNames = new[] {"ID"}; //设置GridView数据主键
//dgvInfo.DataSource = query.ToList(); //设置GridView数据源
//dgvInfo.DataBind();
}
/// <summary>
/// 所属用户组成员
/// </summary>
public void InitUserRole()
{
if (!string.IsNullOrEmpty(_UserGroup_ID))
{
DataTable dt = user_idao.Load_UserInfoUserGroupList(_UserGroup_ID);
ControlBindHelper.BindRepeaterList(dt, rp_Item);
}
}
public void InitUserRole()
{
if (!string.IsNullOrEmpty(this._key))
{
DataTable dt = this.system_idao.InitUserRole(this._key);
ControlBindHelper.BindRepeaterList(dt, this.rp_Item);
}
}
private void DataBindGrid()
{
StringBuilder SqlWhere = new StringBuilder();
IList <SqlParam> IList_param = new List <SqlParam>();
DataTable dt = DataFactory.SqlDataBase().GetDataTable("Base_ATS_HolidaySetting");
ControlBindHelper.BindRepeaterList(dt, rp_Item);
}
private void DataBindGrid()
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("SELECT WA.*,BR.Roles_Name FROM WF_Activity WA LEFT JOIN Base_Roles BR ON WA.RoleId=BR.Roles_ID WHERE FlowInfoId='{0}' ORDER BY STEP", _key);
DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(sb);
ControlBindHelper.BindRepeaterList(dt, this.rp_Item);
}
private void DataBindGrid()
{
int count = 0;
StringBuilder SqlWhere = new StringBuilder();
IList <SqlParam> IList_param = new List <SqlParam>();
SqlWhere.Append(" WHERE 1=1");
//SqlWhere.Append(" WHERE Checks='是' AND specName IS NOT NULL AND status<>'未审核'");
if (!string.IsNullOrEmpty(this.AreaName.Value))
{
SqlWhere.AppendFormat(" AND AreaName='{0}' ", this.AreaName.Value);
}
if (!string.IsNullOrEmpty(this.EduBackName.Value))
{
SqlWhere.AppendFormat(" AND EduBackName='{0}' ", this.EduBackName.Value);
}
if (!string.IsNullOrEmpty(this.EduTypeName.Value))
{
SqlWhere.AppendFormat(" AND EduTypeName='{0}' ", this.EduTypeName.Value);
}
if (!string.IsNullOrEmpty(this.CompanyID.Value))
{
SqlWhere.AppendFormat(" AND CompanyID='{0}' ", this.CompanyID.Value);
}
if (!string.IsNullOrEmpty(this.specName.Value))
{
SqlWhere.AppendFormat(" AND specName='{0}' ", this.specName.Value);
}
if (!string.IsNullOrEmpty(this.status.Value))
{
SqlWhere.AppendFormat(" AND status='{0}' ", this.status.Value);
}
if (!string.IsNullOrEmpty(this.Checks.Value))
{
SqlWhere.AppendFormat(" AND Checks='{0}' ", this.Checks.Value);
}
if (!string.IsNullOrEmpty(this.sexText.Value))
{
SqlWhere.AppendFormat(" AND sexText='{0}' ", this.sexText.Value);
}
//SqlWhere.Append(" AND User_ID NOT IN (SELECT User_ID FROM UserMessageTemp WHERE User_ID=U.User_ID)");
if (!string.IsNullOrEmpty(this.txt_Search.Value))
{
SqlWhere.Append(" AND U." + this.Searchwhere.Value + " like @obj ");
IList_param.Add(new SqlParam("@obj", '%' + this.txt_Search.Value.Trim() + '%'));
}
//DataTable userdt = this.peridal.GetUserID(SqlWhere, IList_param);
// this.GetUserID(userdt);
DataTable dt = this.peridal.GetUserListPage(SqlWhere, IList_param, this.PageControl1.PageIndex, this.PageControl1.PageSize, ref count);
ControlBindHelper.BindRepeaterList(dt, this.rp_Item);
this.PageControl1.RecordCount = Convert.ToInt32(count);
this.PageControl1.PageChecking();
}
protected void Page_Load(object sender, EventArgs e)
{
_key = RequestSession.GetSessionUser().UserId.ToString();
_UserName = RequestSession.GetSessionUser().UserName.ToString();
InitBasicUserInfo();
AppendHtml.Append(systemidao.AppendProperty_HtmlLabel(Property_Function));
ControlBindHelper.BindRepeaterList(systemidao.GetRoleByMember(_key), rp_Item);//拥有角色
GetMenuTreeTable();
}
/// <summary>
/// 绑定数据源
/// </summary>
private void DataBindGrid(bool isQuery = false)
{
string startDate = txtStartDate.Value + " 00:00:00";
string endDate = txtEndDate.Value + " 23:59:59";
OrdersManager ordersManager = new OrdersManager();
dt = ordersManager.VehicleStatistics(startDate, endDate);
ControlBindHelper.BindRepeaterList(dt, rp_Item);
}
private void InitData()
{
//StringBuilder sb = new StringBuilder();
//sb.Append("SELECT * FROM User_Guarantee WHERE UID=@UID");
//SqlParam[] para = new SqlParam[] { new SqlParam("@UID", UID) };
//DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(sb, para);
DataTable dt = ciDal.GetUserGuaranteeByUID(UID);
ControlBindHelper.BindRepeaterList(dt, this.rp_Item);
}
private void InitData()
{
DataTable dt = new DataTable();
if (!string.IsNullOrEmpty(this._Function))
{
dt = this.systemidao.AppendProperty_List(this._Function);
}
ControlBindHelper.BindRepeaterList(dt, this.rp_Item);
}
/// <summary>
/// 绑定数据源
/// </summary>
private void DataBindGrid(bool isQuery = false)
{
RechargeRules userManager = new RechargeRules();
int count = 0;
int pageIndex = 1;
KeyValuePair <StringBuilder, IList <SqlParam> > keyValue = InitCondition();
DataTable dt = userManager.GetInfoPage(keyValue.Key, keyValue.Value, pageIndex, PageControl1.PageSize, ref count);
ControlBindHelper.BindRepeaterList(dt, rp_Item);
}
private void InitData()
{
StringBuilder sb = new StringBuilder();
sb.Append("SELECT * FROM Pledge_Right WHERE UID=@UID");
SqlParam[] para = new SqlParam[] { new SqlParam("@UID", UID) };
DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(sb, para);
ControlBindHelper.BindRepeaterList(dt, this.rp_Item);
}
/// <summary>
/// 绑定数据源
/// </summary>
private void DataBindGrid()
{
DepositReturnManager depositManager = new DepositReturnManager();
int count = 0;
KeyValuePair <StringBuilder, IList <SqlParam> > keyValue = InitCondition();
DataTable dt = depositManager.GetPage(keyValue.Key, keyValue.Value, PageControl1.PageIndex, PageControl1.PageSize, ref count);
ControlBindHelper.BindRepeaterList(dt, rp_Item);
this.PageControl1.RecordCount = Convert.ToInt32(count);
this.PageControl1.PageChecking();
}
private void DataBindGrid()
{
int count = 0;
StringBuilder SqlWhere = new StringBuilder();
SqlWhere.Append(" and (AuditFlag is null or AuditFlag='1')");
IList <SqlParam> IList_param = new List <SqlParam>();
DataTable dt = this.storetransation_idao.GetStorePurchasePage(SqlWhere);
ControlBindHelper.BindRepeaterList(dt, this.rp_Item);
this.PageControl1.RecordCount = Convert.ToInt32(count);
}
/// <summary>
/// 绑定数据源
/// </summary>
private void DataBindGrid()
{
UserInfoManager userManager = new UserInfoManager();
int count = 0;
StringBuilder SqlWhere = new StringBuilder();
IList <SqlParam> IList_param = new List <SqlParam>();
DataTable dt = userManager.GetUserReportLossInfoPage(SqlWhere, IList_param, PageControl1.PageIndex, PageControl1.PageSize, ref count);
ControlBindHelper.BindRepeaterList(dt, rp_Item);
this.PageControl1.RecordCount = Convert.ToInt32(count);
}
private void DataBindGrid()
{
int count = 0;
StringBuilder SqlWhere = new StringBuilder();
SqlWhere.Append(" and CheckQuantity=0 and quantity>checkquantity and (AuditFlag is null or AuditFlag>'0')");
IList <SqlParam> IList_param = new List <SqlParam>();
DataTable dt = this.storetransation_idao.GetStoreDeliveryPage(SqlWhere, IList_param, this.PageControl1.PageIndex, this.PageControl1.PageSize, ref count);
ControlBindHelper.BindRepeaterList(dt, this.rp_Item);
this.PageControl1.RecordCount = Convert.ToInt32(count);
}
/// <summary>
/// 绑定数据源
/// </summary>
private void DataBindGrid(bool isQuery = false)
{
VehicleMaintainLogManager vehicleMaintainLogManager = new VehicleMaintainLogManager();
int count = 0;
int pageIndex = isQuery ? 1 : PageControl1.PageIndex;
KeyValuePair<StringBuilder, IList<SqlParam>> keyValue = InitCondition();
DataTable dt = vehicleMaintainLogManager.GetVehicleMaintainLogInfoPage(keyValue.Key, keyValue.Value, pageIndex, PageControl1.PageSize, ref count);
ControlBindHelper.BindRepeaterList(dt, rp_Item);
this.PageControl1.PageIndex = pageIndex;
this.PageControl1.RecordCount = Convert.ToInt32(count);
this.PageControl1.PageChecking();
}
private void DataBindGrid()
{
int count = 0;
StringBuilder SqlWhere = new StringBuilder();
IList <SqlParam> IList_param = new List <SqlParam>();
//DataTable dt = DataFactory.SqlDataBase().GetDataTable("Base_ATS_OriDataIn");
string sql = "select * from Base_PerTravelApply where empid='" + EmpID + "' ";
StringBuilder sb_sql = new StringBuilder(sql);
// DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(sb_sql);
DataTable dt = DataFactory.SqlDataBase().GetPageList(sql, null, "CreateDate", "asc", PageControl1.PageIndex, PageControl1.PageSize, ref count);
ControlBindHelper.BindRepeaterList(dt, rp_Item);
this.PageControl1.RecordCount = Convert.ToInt32(count);
}
private void DataBindGrid()
{
int count = 0;
StringBuilder SqlWhere = new StringBuilder();
IList <SqlParam> IList_param = new List <SqlParam>();
SqlWhere.Append(" WHERE WFStatus IN (1,6) ");
DataTable dt = this.peridal.GetMyApproveOverListPage(SqlWhere, IList_param, this.PageControl1.PageIndex, this.PageControl1.PageSize, ref count);
ControlBindHelper.BindRepeaterList(dt, this.rp_Item);
this.PageControl1.RecordCount = Convert.ToInt32(count);
this.PageControl1.PageChecking();
}
/// <summary>
/// GridView数据导入方法
/// </summary>
private void LoadData()
{
string str = @"select plancon.*,material.Material_Type,Material_Name,Material_Specification,Material_Unit,Material_Supplier from (
select plancontent.PurchaseBillCode,plancontent.DeptName,plancontent.PurchaseDate,detail.ProductCode,detail.Quantity from MMS_PurchasePlanContent plancontent inner join
MMS_PurchasePlanDetail detail on plancontent.PurchaseBillCode=detail.PurchaseBillCode
where AuditFlag=1) plancon
left join dbo.MMS_MaterialInfo material on plancon.ProductCode=material.Material_ID
order by deptname,productcode";
str = string.Format(str);
DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(new StringBuilder(str));
ControlBindHelper.BindRepeaterList(dt, this.rp_Item);
}
private void DataBindGrid()
{
int count = 0;
StringBuilder SqlWhere = new StringBuilder();
IList <SqlParam> IList_param = new List <SqlParam>();
SqlWhere.AppendFormat(" WHERE sysUserID='{0}' ", RequestSession.GetSessionUser().UserId.ToString());
if (!string.IsNullOrEmpty(this.AreaName.Value))
{
SqlWhere.AppendFormat(" AND AreaName='{0}' ", this.AreaName.Value);
}
if (!string.IsNullOrEmpty(this.EduBackName.Value))
{
SqlWhere.AppendFormat(" AND EduBackName='{0}' ", this.EduBackName.Value);
}
if (!string.IsNullOrEmpty(this.EduTypeName.Value))
{
SqlWhere.AppendFormat(" AND EduTypeName='{0}' ", this.EduTypeName.Value);
}
if (!string.IsNullOrEmpty(this.CompanyID.Value))
{
SqlWhere.AppendFormat(" AND CompanyID='{0}' ", this.CompanyID.Value);
}
if (!string.IsNullOrEmpty(this.specName.Value))
{
SqlWhere.AppendFormat(" AND specName='{0}' ", this.specName.Value);
}
if (!string.IsNullOrEmpty(this.status.Value))
{
SqlWhere.AppendFormat(" AND status='{0}' ", this.status.Value);
}
if (!string.IsNullOrEmpty(this.Checks.Value))
{
SqlWhere.AppendFormat(" AND Checks='{0}' ", this.Checks.Value);
}
if (!string.IsNullOrEmpty(this.txt_Search.Value))
{
SqlWhere.Append(" AND U." + this.Searchwhere.Value + " like @obj ");
IList_param.Add(new SqlParam("@obj", '%' + this.txt_Search.Value.Trim() + '%'));
}
DataTable dt = this.peridal.GetFlagListPage(SqlWhere, IList_param, this.PageControl1.PageIndex, this.PageControl1.PageSize, ref count);
ControlBindHelper.BindRepeaterList(dt, this.rp_Item);
this.PageControl1.RecordCount = Convert.ToInt32(count);
this.PageControl1.PageChecking();
}
private void DataBindGrid()
{
int count = 0;
string strsql = "insert into Base_LeaveConsole(EmpID) select USER_ID from Base_UserInfo where USER_ID not in (select empid from Base_LeaveConsole)";
StringBuilder sbsql = new StringBuilder(strsql);
DataFactory.SqlDataBase().ExecuteBySql(sbsql);
//StringBuilder SqlWhere = new StringBuilder();
//IList<SqlParam> IList_param = new List<SqlParam>();
string sql = "select * from uvw_Base_LeaveConsole ";
//string sql = "select '06E75A21-5274-40AA-9263-E21C56F7B539' AS EmpID, 'Roy Wang' as User_Name, 0 AS JZAL, '1900-1-1' AS JZDate, 0 AS CKAL, 0 AS CYAL, 0 AS SYTX, 0 AS UsedAL, 0 AS UseAL, 0 AS ALEdit, 0 AS UsedTX, 0 AS UseTX";
StringBuilder sb_sql = new StringBuilder(sql);
DataTable dt = DataFactory.SqlDataBase().GetPageList(sql, null, "User_Name", "asc", PageControl1.PageIndex, PageControl1.PageSize, ref count);
ControlBindHelper.BindRepeaterList(dt, rp_Item);
this.PageControl1.RecordCount = Convert.ToInt32(count);
}
/// <summary>
/// 绑定数据源
/// </summary>
private void DataBindGrid()
{
VehicleModelManager vModelManage = new VehicleModelManager();
int count = 0;
StringBuilder SqlWhere = new StringBuilder();
IList <SqlParam> IList_param = new List <SqlParam>();
if (!string.IsNullOrEmpty(txtName.Value))
{
SqlWhere.Append(" and s.Name like @name ");
IList_param.Add(new SqlParam("@name", '%' + txtName.Value.Trim() + '%'));
}
DataTable dt = vModelManage.GetPage(SqlWhere, IList_param, PageControl1.PageIndex, PageControl1.PageSize, ref count);
ControlBindHelper.BindRepeaterList(dt, rp_Item);
this.PageControl1.RecordCount = Convert.ToInt32(count);
}
/// <summary>
/// 绑定数据源
/// </summary>
private void DataBindGrid()
{
MessageManager messageManager = new MessageManager();
int count = 0;
StringBuilder SqlWhere = new StringBuilder();
IList <SqlParam> IList_param = new List <SqlParam>();
if (!string.IsNullOrEmpty(this.txtMessageTitle.Value))
{
SqlWhere.Append(" and MessageTitle like @MessageTitle ");
IList_param.Add(new SqlParam("@MessageTitle", '%' + this.txtMessageTitle.Value + '%'));
}
if (!this.drpState.SelectedValue.Equals("-1"))
{
SqlWhere.Append(" and State = '" + this.drpState.SelectedValue + "' ");
}
if (!string.IsNullOrEmpty(this.txtReleaseTime.Value))
{
SqlWhere.Append(" and ('" + this.txtReleaseTime.Value + "'>=ReleaseTime )");
}
if ((!string.IsNullOrEmpty(this.txtStartCreateTime.Value)) && string.IsNullOrEmpty(this.txtEndCreateTime.Value))
{
SqlWhere.Append(" and '" + txtStartCreateTime.Value + "' <= EndTime");
}
else if (string.IsNullOrEmpty(this.txtStartCreateTime.Value) && (!string.IsNullOrEmpty(this.txtEndCreateTime.Value)))
{
SqlWhere.Append(" and '" + this.txtEndCreateTime.Value + "' >= BeginTime");
}
else if ((!string.IsNullOrEmpty(this.txtStartCreateTime.Value)) && string.IsNullOrEmpty(this.txtEndCreateTime.Value))
{
SqlWhere.Append(" and (（and '" + this.txtStartCreateTime.Value + "' <= BeginTime and '" + this.txtEndCreateTime.Value + "'>=BeginTime)||（and '" + this.txtStartCreateTime.Value + "' >= BeginTime and '" + this.txtStartCreateTime.Value + "'<=EndTime))");
}
DataTable dt = messageManager.GetPitsInfoPage(SqlWhere, IList_param, PageControl1.PageIndex, PageControl1.PageSize, ref count);
ControlBindHelper.BindRepeaterList(dt, rp_Item);
this.PageControl1.RecordCount = Convert.ToInt32(count);
}
private void DataBindGrid()
{
int count = 0;
StringBuilder SqlWhere = new StringBuilder();
IList <SqlParam> IList_param = new List <SqlParam>();
if (this.BeginBuilTime.Value != "" || this.endBuilTime.Value != "")
{
SqlWhere.Append(" and Sys_LoginLog_Time >= @BeginBuilTime");
SqlWhere.Append(" and Sys_LoginLog_Time <= @endBuilTime");
IList_param.Add(new SqlParam("@BeginBuilTime", CommonHelper.GetDateTime(this.BeginBuilTime.Value)));
IList_param.Add(new SqlParam("@endBuilTime", CommonHelper.GetDateTime(this.endBuilTime.Value).AddDays(1.0)));
}
SqlWhere.Append(" and User_Account = @User_Account");
IList_param.Add(new SqlParam("@User_Account", RequestSession.GetSessionUser().UserAccount));
DataTable dt = this.user_idao.GetSysLoginLogPage(SqlWhere, IList_param, this.PageControl1.PageIndex, this.PageControl1.PageSize, ref count);
ControlBindHelper.BindRepeaterList(dt, this.rp_Item);
this.PageControl1.RecordCount = Convert.ToInt32(count);
}
private void DataBindGrid()
{
int count = 0;
StringBuilder SqlWhere = new StringBuilder();
IList <SqlParam> IList_param = new List <SqlParam>();
if (!string.IsNullOrEmpty(this.txt_Search.Value))
{
SqlWhere.Append(" and U." + this.Searchwhere.Value + " like @obj ");
IList_param.Add(new SqlParam("@obj", '%' + this.txt_Search.Value.Trim() + '%'));
}
if (!string.IsNullOrEmpty(this._Organization_ID))
{
SqlWhere.Append(" AND S.Organization_ID IN(" + this._Organization_ID + ")");
}
DataTable dt = this.user_idao.GetUserInfoPage(SqlWhere, IList_param, this.PageControl1.PageIndex, this.PageControl1.PageSize, ref count);
ControlBindHelper.BindRepeaterList(dt, this.rp_Item);
this.PageControl1.RecordCount = Convert.ToInt32(count);
}
private void InitData()
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("SELECT * FROM Contract_Finger WHERE [UID]='{0}' AND ClassID IN ({1})", this.UID, this.ClassID);
DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(sb);
if (DataTableHelper.IsExistRows(dt))
{
ControlBindHelper.BindRepeaterList(dt, this.rp_Item);
this.FID.Value = dt.Rows[0]["FID"].ToString();
this.FistFingerName = dt.Rows[0]["FingerName"].ToString();
this.ContractType = dt.Rows[0]["CONTRACTTYPE"].ToString();
}
else
{
this.FReg.Visible = false;
_Vis = "none";
}
}
