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