internal void addDLIP(KFB_DLIP model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into KFB_DLIP( ");
strSql.Append("N_HYZH,N_HYIP,N_CGCS,N_SPCS,N_ZJDLSJ,N_HYDJ)");
strSql.Append(" values (");
strSql.Append(":N_HYZH,:N_HYIP,:N_CGCS,:N_SPCS,:N_ZJDLSJ,:N_HYDJ)");
OracleParameter[] parameters =
{
new OracleParameter(":N_HYZH", OracleType.VarChar, 100),
new OracleParameter(":N_HYIP", OracleType.VarChar, 50),
new OracleParameter(":N_CGCS", OracleType.Number, 4),
new OracleParameter(":N_SPCS", OracleType.Number, 4),
new OracleParameter(":N_ZJDLSJ", OracleType.DateTime),
new OracleParameter(":N_HYDJ", OracleType.VarChar, 4)
};
parameters[0].Value = model.N_HYZH;
parameters[1].Value = model.N_HYIP;
parameters[2].Value = model.N_CGCS;
parameters[3].Value = model.N_SPCS;
parameters[4].Value = model.N_ZJDLSJ;
parameters[5].Value = model.N_HYDJ;
DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
}
//修改会员登录次数
public void Setdl(string strlv, string strid, string strty)
{
KFB_DLIP mo_DLIP = new KFB_DLIP();
//if (!o_DLIP.Exists(strid))
//{
mo_DLIP.N_HYDJ = strlv;
mo_DLIP.N_HYZH = strid;
mo_DLIP.N_HYIP = this.Request.UserHostAddress;
mo_DLIP.N_ZJDLSJ = DateTime.Now;
if (strty.Equals("cg"))
{
mo_DLIP.N_CGCS = 1;
mo_DLIP.N_SPCS = 0;
}
else if (strty.Equals("sb"))
{
mo_DLIP.N_CGCS = 0;
mo_DLIP.N_SPCS = 1;
}
objLogin.addDLIP(mo_DLIP);
}
