/// <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();
}
}
}
}
