/// <summary> /// 增删改TABLE_SJX /// op_TABLE_SJX /// 参数类名:TABLE_SJXModel /// </summary> /// <returns>返回数</returns> public static int op_TABLE_SJX( CykjSoft.Bean.UserBean userBean , XASYU.MODEL.TABLE_SJXModel TABLE_SJX ) { int iRESULT = 0; int iERRCD = 0; string sERRMSG = String.Empty; try { XASYU.DBBusiness.DataBaseManager.op_TABLE_SJX( userBean.YHDLM //用户登陆名 , ref iRESULT , ref iERRCD , ref sERRMSG , DataOperationTypeHelper.GetOperationString(TABLE_SJX.OpType) , TABLE_SJX.SJX_id //SJX_id , TABLE_SJX.SJX_mobile //SJX_mobile , TABLE_SJX.SJX_nr //SJX_nr , TABLE_SJX.SJX_jstime //SJX_jstime ); } catch (Exception ex) { iRESULT = -1; ex.ToString(); } return(iRESULT); }
protected override void OnLoad(EventArgs e) { if (!Page.IsPostBack) { btnClose.OnClientClick = ActiveWindow.GetHideReference(); if (Request.QueryString["SJX_ID"] != null && Request.QueryString["SJX_ID"].ToString().Trim() != "") { XASYU.MODEL.TABLE_SJXModel temp = new XASYU.MODEL.TABLE_SJXModel(); temp.SJX_id = int.Parse(Request.QueryString["SJX_ID"].ToString().Trim()); int iCount = -1; DataSet ds = XASYU.BLL.DataBaseQuery.query_TABLE_SJX(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.hiddenSJX_id.Text = dr["SJX_id"].ToString(); this.txtSJX_mobile.Text = dr["SJX_mobile"].ToString(); this.txtSJX_nr.Text = dr["SJX_nr"].ToString(); this.dthSJX_jstime.SelectedDate = DateTime.Parse(dr["SJX_jstime"].ToString()); } else { //this.hiddenSJX_id.Value ="0" ; this.dthSJX_jstime.SelectedDate = DateTime.Now; } } else { //this.hiddenSJX_id.Value ="0" ; this.dthSJX_jstime.SelectedDate = DateTime.Now; } } }
/// <summary> /// 查询TABLE_SJX /// query_TABLE_SJX /// 参数类名:TABLE_SJXModel /// </summary> /// <returns>DataSet</returns> public static DataSet query_TABLE_SJX( CykjSoft.Bean.UserBean userBean , XASYU.MODEL.TABLE_SJXModel TABLE_SJX , ref int V_ITOTALCOUNT //记录数 , int V_SSTARTINDEX //开始索引 , int V_SPERPAGESIZE //页大小 ) { return(XASYU.DBBusiness.DataBaseQuery.query_TABLE_SJX( userBean.YHDLM //用户登陆名 , ref V_ITOTALCOUNT //记录数 , V_SSTARTINDEX //开始索引 , V_SPERPAGESIZE //页大小 , TABLE_SJX.SJX_id //SJX_id , TABLE_SJX.SJX_mobile //SJX_mobile , TABLE_SJX.SJX_nr //SJX_nr , TABLE_SJX.SJX_jstime //SJX_jstime , TABLE_SJX.StartDate //开始时间 , TABLE_SJX.EndDate //结束时间 )); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { btnClose.OnClientClick = ActiveWindow.GetHideReference(); if (Request.QueryString["SJX_ID"] != null && Request.QueryString["SJX_ID"].ToString().Trim() != "") { XASYU.MODEL.TABLE_SJXModel temp = new XASYU.MODEL.TABLE_SJXModel(); temp.SJX_id = int.Parse(Request.QueryString["SJX_ID"].ToString().Trim()); int iCount = -1; DataSet ds = XASYU.BLL.DataBaseQuery.query_TABLE_SJX(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]; lblhiddenSJX_id.Text = dr["SJX_id"].ToString(); lbltxtSJX_mobile.Text = dr["SJX_mobile"].ToString(); lbltxtSJX_nr.Text = dr["SJX_nr"].ToString(); lbldthSJX_jstime.Text = dr["SJX_jstime"].ToString(); } } } }