protected override void OnLoad(EventArgs e) { if (!Page.IsPostBack) { btnClose.OnClientClick = ActiveWindow.GetHideReference(); if (Request.QueryString["LXR_ID"] != null && Request.QueryString["LXR_ID"].ToString().Trim() != "") { XASYU.MODEL.TABLE_LXRModel temp = new XASYU.MODEL.TABLE_LXRModel(); temp.LXR_id = int.Parse(Request.QueryString["LXR_ID"].ToString().Trim()); int iCount = -1; DataSet ds = XASYU.BLL.DataBaseQuery.query_TABLE_LXR(userBean, temp, ref iCount, 0, 10); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; this.hiddenLXR_id.Text = dr["LXR_id"].ToString(); this.txtLXR_name.Text = dr["LXR_name"].ToString(); this.txtLXR_mobile.Text = dr["LXR_mobile"].ToString(); this.txtLXR_sex.Text = dr["LXR_sex"].ToString(); this.txtLXR_phone.Text = dr["LXR_phone"].ToString(); this.txtLXR_email.Text = dr["LXR_email"].ToString(); this.txtLXR_gzdw.Text = dr["LXR_gzdw"].ToString(); this.txtLXR_sfzid.Text = dr["LXR_sfzid"].ToString(); this.txtLXR_zw.Text = dr["LXR_zw"].ToString(); this.txtLXR_bz.Text = dr["LXR_bz"].ToString(); this.ddlLXR_sfjrwh.SelectedValue = dr["LXR_sfjrwh"].ToString(); this.dthLXR_csrq.SelectedDate = DateTime.Parse(dr["LXR_csrq"].ToString()); this.ddlLXR_sfsrwh.SelectedValue = dr["LXR_sfsrwh"].ToString(); this.dthLXR_gj01.SelectedDate = DateTime.Parse(dr["LXR_gj01"].ToString()); this.txtLXR_gj01nr.Text = dr["LXR_gj01nr"].ToString(); this.dthLXR_gj02.SelectedDate = DateTime.Parse(dr["LXR_gj02"].ToString()); this.txtLXR_gj02nr.Text = dr["LXR_gj02nr"].ToString(); this.dthLXR_gj03.SelectedDate = DateTime.Parse(dr["LXR_gj03"].ToString()); this.txtLXR_gj03nr.Text = dr["LXR_gj03nr"].ToString(); } else { //this.hiddenLXR_id.Value ="0" ; this.dthLXR_csrq.SelectedDate = DateTime.Now; this.dthLXR_gj01.SelectedDate = DateTime.Now; this.dthLXR_gj02.SelectedDate = DateTime.Now; this.dthLXR_gj03.SelectedDate = DateTime.Now; } } else { //this.hiddenLXR_id.Value ="0" ; this.dthLXR_csrq.SelectedDate = DateTime.Now; this.dthLXR_gj01.SelectedDate = DateTime.Now; this.dthLXR_gj02.SelectedDate = DateTime.Now; this.dthLXR_gj03.SelectedDate = DateTime.Now; } } }
/// <summary> /// 增删改TABLE_LXR /// op_TABLE_LXR /// 参数类名:TABLE_LXRModel /// </summary> /// <returns>返回数</returns> public static int op_TABLE_LXR( CykjSoft.Bean.UserBean userBean , XASYU.MODEL.TABLE_LXRModel TABLE_LXR ) { int iRESULT = 0; int iERRCD = 0; string sERRMSG = String.Empty; try { XASYU.DBBusiness.DataBaseManager.op_TABLE_LXR( userBean.YHDLM //用户登陆名 , ref iRESULT , ref iERRCD , ref sERRMSG , DataOperationTypeHelper.GetOperationString(TABLE_LXR.OpType) , TABLE_LXR.LXR_id //LXR_id , TABLE_LXR.LXR_name //LXR_name , TABLE_LXR.LXR_mobile //LXR_mobile , TABLE_LXR.LXR_sex //LXR_sex , TABLE_LXR.LXR_phone //LXR_phone , TABLE_LXR.LXR_email //LXR_email , TABLE_LXR.LXR_gzdw //LXR_gzdw , TABLE_LXR.LXR_sfzid //LXR_sfzid , TABLE_LXR.LXR_zw //LXR_zw , TABLE_LXR.LXR_bz //LXR_bz , TABLE_LXR.LXR_sfjrwh //LXR_sfjrwh , TABLE_LXR.LXR_csrq //LXR_csrq , TABLE_LXR.LXR_sfsrwh //LXR_sfsrwh , TABLE_LXR.LXR_gj01 //LXR_gj01 , TABLE_LXR.LXR_gj01nr //LXR_gj01nr , TABLE_LXR.LXR_gj02 //LXR_gj02 , TABLE_LXR.LXR_gj02nr //LXR_gj02nr , TABLE_LXR.LXR_gj03 //LXR_gj03 , TABLE_LXR.LXR_gj03nr //LXR_gj03nr ); } catch (Exception ex) { iRESULT = -1; ex.ToString(); } return(iRESULT); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { btnClose.OnClientClick = ActiveWindow.GetHideReference(); if (Request.QueryString["LXR_ID"] != null && Request.QueryString["LXR_ID"].ToString().Trim() != "") { XASYU.MODEL.TABLE_LXRModel temp = new XASYU.MODEL.TABLE_LXRModel(); temp.LXR_id = int.Parse(Request.QueryString["LXR_ID"].ToString().Trim()); int iCount = -1; DataSet ds = XASYU.BLL.DataBaseQuery.query_TABLE_LXR(userBean, temp, ref iCount, 0, 10); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; lblhiddenLXR_id.Text = dr["LXR_id"].ToString(); lbltxtLXR_name.Text = dr["LXR_name"].ToString(); lbltxtLXR_mobile.Text = dr["LXR_mobile"].ToString(); lbltxtLXR_sex.Text = dr["LXR_sex"].ToString(); lbltxtLXR_phone.Text = dr["LXR_phone"].ToString(); lbltxtLXR_email.Text = dr["LXR_email"].ToString(); lbltxtLXR_gzdw.Text = dr["LXR_gzdw"].ToString(); lbltxtLXR_sfzid.Text = dr["LXR_sfzid"].ToString(); lbltxtLXR_zw.Text = dr["LXR_zw"].ToString(); lbltxtLXR_bz.Text = dr["LXR_bz"].ToString(); lblddlLXR_sfjrwh.Text = dr["LXR_sfjrwh"].ToString(); lbldthLXR_csrq.Text = dr["LXR_csrq"].ToString(); lblddlLXR_sfsrwh.Text = dr["LXR_sfsrwh"].ToString(); lbldthLXR_gj01.Text = dr["LXR_gj01"].ToString(); lbltxtLXR_gj01nr.Text = dr["LXR_gj01nr"].ToString(); lbldthLXR_gj02.Text = dr["LXR_gj02"].ToString(); lbltxtLXR_gj02nr.Text = dr["LXR_gj02nr"].ToString(); lbldthLXR_gj03.Text = dr["LXR_gj03"].ToString(); lbltxtLXR_gj03nr.Text = dr["LXR_gj03nr"].ToString(); } } } }
/// <summary> /// 查询TABLE_LXR /// query_TABLE_LXR /// 参数类名:TABLE_LXRModel /// </summary> /// <returns>DataSet</returns> public static DataSet query_TABLE_LXR( CykjSoft.Bean.UserBean userBean , XASYU.MODEL.TABLE_LXRModel TABLE_LXR , ref int V_ITOTALCOUNT //记录数 , int V_SSTARTINDEX //开始索引 , int V_SPERPAGESIZE //页大小 ) { return(XASYU.DBBusiness.DataBaseQuery.query_TABLE_LXR( userBean.YHDLM //用户登陆名 , ref V_ITOTALCOUNT //记录数 , V_SSTARTINDEX //开始索引 , V_SPERPAGESIZE //页大小 , TABLE_LXR.LXR_id //LXR_id , TABLE_LXR.LXR_name //LXR_name , TABLE_LXR.LXR_mobile //LXR_mobile , TABLE_LXR.LXR_sex //LXR_sex , TABLE_LXR.LXR_phone //LXR_phone , TABLE_LXR.LXR_email //LXR_email , TABLE_LXR.LXR_gzdw //LXR_gzdw , TABLE_LXR.LXR_sfzid //LXR_sfzid , TABLE_LXR.LXR_zw //LXR_zw , TABLE_LXR.LXR_bz //LXR_bz , TABLE_LXR.LXR_sfjrwh //LXR_sfjrwh , TABLE_LXR.LXR_csrq //LXR_csrq , TABLE_LXR.LXR_sfsrwh //LXR_sfsrwh , TABLE_LXR.LXR_gj01 //LXR_gj01 , TABLE_LXR.LXR_gj01nr //LXR_gj01nr , TABLE_LXR.LXR_gj02 //LXR_gj02 , TABLE_LXR.LXR_gj02nr //LXR_gj02nr , TABLE_LXR.LXR_gj03 //LXR_gj03 , TABLE_LXR.LXR_gj03nr //LXR_gj03nr , TABLE_LXR.StartDate //开始时间 , TABLE_LXR.EndDate //结束时间 )); }