internal void Update(KFB_XSHY model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update KFB_XSHY set ");
strSql.Append("N_HYIP=:N_HYIP,");
strSql.Append("N_DLSJ=:N_DLSJ,");
strSql.Append("N_SYSJ=:N_SYSJ");
strSql.Append(" where N_HYZH=:N_HYZH and N_HYDJ=:N_HYDJ ");
OracleParameter[] parameters =
{
new OracleParameter(":N_HYZH", OracleType.VarChar, 100),
new OracleParameter(":N_HYDJ", OracleType.Number, 4),
new OracleParameter(":N_HYIP", OracleType.VarChar, 50),
new OracleParameter(":N_DLSJ", OracleType.DateTime),
new OracleParameter(":N_SYSJ", OracleType.DateTime)
};
parameters[0].Value = model.N_HYZH;
parameters[1].Value = model.N_HYDJ;
parameters[2].Value = model.N_HYIP;
parameters[3].Value = model.N_DLSJ;
parameters[4].Value = model.N_SYSJ;
DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 取得流水號
/// </summary>
public void SetSXHY(string strlv, string strid)
{
KFB_XSHY objXSHY = new KFB_XSHY();
objXSHY.N_HYDJ = Convert.ToInt32(Session["LEVEL"].ToString());
objXSHY.N_HYZH = Session["UserID"].ToString();
objXSHY.N_HYIP = CommLib.Utility.GetIpAddress();
objXSHY.N_SYSJ = DateTime.Now;
objXSHY.N_DLSJ = DateTime.Now;
if (!objLogin.Exists(strid, Convert.ToInt32(strlv)))
{
objLogin.Add(objXSHY);
}
else
{
objLogin.Update(objXSHY);
}
}
internal void Add(KFB_XSHY model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into KFB_XSHY(");
strSql.Append("N_HYZH,N_HYDJ,N_HYIP,N_DLSJ,N_SYSJ)");
strSql.Append(" values (");
strSql.Append(":N_HYZH,:N_HYDJ,:N_HYIP,:N_DLSJ,:N_SYSJ)");
OracleParameter[] parameters =
{
new OracleParameter(":N_HYZH", OracleType.VarChar, 100),
new OracleParameter(":N_HYDJ", OracleType.Number, 4),
new OracleParameter(":N_HYIP", OracleType.VarChar, 50),
new OracleParameter(":N_DLSJ", OracleType.DateTime),
new OracleParameter(":N_SYSJ", OracleType.DateTime)
};
parameters[0].Value = model.N_HYZH;
parameters[1].Value = model.N_HYDJ;
parameters[2].Value = model.N_HYIP;
parameters[3].Value = model.N_DLSJ;
parameters[4].Value = model.N_SYSJ;
DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
}
