/// <summary> /// 查询TABLE_SMS /// query_TABLE_SMS /// 参数类名:TABLE_SMSModel /// </summary> /// <returns>DataSet</returns> public static DataSet query_TABLE_SMS( CykjSoft.Bean.UserBean userBean , XASYU.MODEL.TABLE_SMSModel TABLE_SMS , ref int V_ITOTALCOUNT //记录数 , int V_SSTARTINDEX //开始索引 , int V_SPERPAGESIZE //页大小 ) { return(XASYU.DBBusiness.DataBaseQuery.query_TABLE_SMS( userBean.YHDLM //用户登陆名 , ref V_ITOTALCOUNT //记录数 , V_SSTARTINDEX //开始索引 , V_SPERPAGESIZE //页大小 , TABLE_SMS.SMS_id //SMS_id , TABLE_SMS.SMS_jsr //SMS_jsr , TABLE_SMS.SMS_nr //SMS_nr , TABLE_SMS.SMS_ljfs //SMS_ljfs , TABLE_SMS.SMS_fstime //SMS_fstime , TABLE_SMS.SMS_dstime //SMS_dstime , TABLE_SMS.SMS_dxlx //SMS_dxlx , TABLE_SMS.SMS_dxzt //SMS_dxzt , TABLE_SMS.SMS_hzzt //SMS_hzzt , TABLE_SMS.SMS_wapdx //SMS_wapdx , TABLE_SMS.SMS_fjname //SMS_fjname , TABLE_SMS.SMS_zchf //SMS_zchf , TABLE_SMS.SMS_ztbg //SMS_ztbg , TABLE_SMS.SMS_hftx //SMS_hftx , TABLE_SMS.SMS_hmd //SMS_hmd , TABLE_SMS.SMS_sfzf //SMS_sfzf , TABLE_SMS.SMS_delete //SMS_delete , TABLE_SMS.StartDate //开始时间 , TABLE_SMS.EndDate //结束时间 )); }
protected override void OnLoad(EventArgs e) { if (!Page.IsPostBack) { btnClose.OnClientClick = ActiveWindow.GetHideReference(); if (Request.QueryString["SMS_ID"] != null && Request.QueryString["SMS_ID"].ToString().Trim() != "") { XASYU.MODEL.TABLE_SMSModel temp = new XASYU.MODEL.TABLE_SMSModel(); temp.SMS_id = int.Parse(Request.QueryString["SMS_ID"].ToString().Trim()); int iCount = -1; DataSet ds = XASYU.BLL.DataBaseQuery.query_TABLE_SMS(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.hiddenSMS_id.Text = dr["SMS_id"].ToString(); this.txtSMS_jsr.Text = dr["SMS_jsr"].ToString(); this.txtSMS_nr.Text = dr["SMS_nr"].ToString(); this.ddlSMS_ljfs.SelectedValue = dr["SMS_ljfs"].ToString(); this.dthSMS_fstime.SelectedDate = DateTime.Parse(dr["SMS_fstime"].ToString()); this.dthSMS_dstime.SelectedDate = DateTime.Parse(dr["SMS_dstime"].ToString()); this.txtSMS_dxlx.Text = dr["SMS_dxlx"].ToString(); this.ddlSMS_dxzt.SelectedValue = dr["SMS_dxzt"].ToString(); this.ddlSMS_hzzt.SelectedValue = dr["SMS_hzzt"].ToString(); this.txtSMS_wapdx.Text = dr["SMS_wapdx"].ToString(); this.ddlSMS_fjname.SelectedValue = dr["SMS_fjname"].ToString(); this.ddlSMS_zchf.SelectedValue = dr["SMS_zchf"].ToString(); this.ddlSMS_ztbg.SelectedValue = dr["SMS_ztbg"].ToString(); this.ddlSMS_hftx.SelectedValue = dr["SMS_hftx"].ToString(); this.txtSMS_hmd.Text = dr["SMS_hmd"].ToString(); this.ddlSMS_sfzf.SelectedValue = dr["SMS_sfzf"].ToString(); this.ddlSMS_delete.SelectedValue = dr["SMS_delete"].ToString(); } else { //this.hiddenSMS_id.Value ="0" ; this.dthSMS_fstime.SelectedDate = DateTime.Now; this.dthSMS_dstime.SelectedDate = DateTime.Now; } } else { //this.hiddenSMS_id.Value ="0" ; this.dthSMS_fstime.SelectedDate = DateTime.Now; this.dthSMS_dstime.SelectedDate = DateTime.Now; } } }
/// <summary> /// 增删改TABLE_SMS /// op_TABLE_SMS /// 参数类名:TABLE_SMSModel /// </summary> /// <returns>返回数</returns> public static int op_TABLE_SMS( CykjSoft.Bean.UserBean userBean , XASYU.MODEL.TABLE_SMSModel TABLE_SMS ) { int iRESULT = 0; int iERRCD = 0; string sERRMSG = String.Empty; try { XASYU.DBBusiness.DataBaseManager.op_TABLE_SMS( userBean.YHDLM //用户登陆名 , ref iRESULT , ref iERRCD , ref sERRMSG , DataOperationTypeHelper.GetOperationString(TABLE_SMS.OpType) , TABLE_SMS.SMS_id //SMS_id , TABLE_SMS.SMS_jsr //SMS_jsr , TABLE_SMS.SMS_nr //SMS_nr , TABLE_SMS.SMS_ljfs //SMS_ljfs , TABLE_SMS.SMS_fstime //SMS_fstime , TABLE_SMS.SMS_dstime //SMS_dstime , TABLE_SMS.SMS_dxlx //SMS_dxlx , TABLE_SMS.SMS_dxzt //SMS_dxzt , TABLE_SMS.SMS_hzzt //SMS_hzzt , TABLE_SMS.SMS_wapdx //SMS_wapdx , TABLE_SMS.SMS_fjname //SMS_fjname , TABLE_SMS.SMS_zchf //SMS_zchf , TABLE_SMS.SMS_ztbg //SMS_ztbg , TABLE_SMS.SMS_hftx //SMS_hftx , TABLE_SMS.SMS_hmd //SMS_hmd , TABLE_SMS.SMS_sfzf //SMS_sfzf , TABLE_SMS.SMS_delete //SMS_delete ); } 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["SMS_ID"] != null && Request.QueryString["SMS_ID"].ToString().Trim() != "") { XASYU.MODEL.TABLE_SMSModel temp = new XASYU.MODEL.TABLE_SMSModel(); temp.SMS_id = int.Parse(Request.QueryString["SMS_ID"].ToString().Trim()); int iCount = -1; DataSet ds = XASYU.BLL.DataBaseQuery.query_TABLE_SMS(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]; lblhiddenSMS_id.Text = dr["SMS_id"].ToString(); lbltxtSMS_jsr.Text = dr["SMS_jsr"].ToString(); lbltxtSMS_nr.Text = dr["SMS_nr"].ToString(); lblddlSMS_ljfs.Text = dr["SMS_ljfs"].ToString(); lbldthSMS_fstime.Text = dr["SMS_fstime"].ToString(); lbldthSMS_dstime.Text = dr["SMS_dstime"].ToString(); lbltxtSMS_dxlx.Text = dr["SMS_dxlx"].ToString(); lblddlSMS_dxzt.Text = dr["SMS_dxzt"].ToString(); lblddlSMS_hzzt.Text = dr["SMS_hzzt"].ToString(); lbltxtSMS_wapdx.Text = dr["SMS_wapdx"].ToString(); lblddlSMS_fjname.Text = dr["SMS_fjname"].ToString(); lblddlSMS_zchf.Text = dr["SMS_zchf"].ToString(); lblddlSMS_ztbg.Text = dr["SMS_ztbg"].ToString(); lblddlSMS_hftx.Text = dr["SMS_hftx"].ToString(); lbltxtSMS_hmd.Text = dr["SMS_hmd"].ToString(); lblddlSMS_sfzf.Text = dr["SMS_sfzf"].ToString(); lblddlSMS_delete.Text = dr["SMS_delete"].ToString(); } } } }