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 //结束时间
));
}
