public Model_SysUser_token DataRowToModel(DataRow row) { Model_SysUser_token _token = new Model_SysUser_token(); if (row != null) { if (row["user_id"] != null) { _token.user_id = row["user_id"].ToString(); } if (row["product_type"] != null) { _token.product_type = row["product_type"].ToString(); } if (row["token"] != null) { _token.token = row["token"].ToString(); } if ((row["token_time"] != null) && (row["token_time"].ToString() != "")) { _token.token_time = new DateTime?(DateTime.Parse(row["token_time"].ToString())); } if ((row["login_time"] != null) && (row["login_time"].ToString() != "")) { _token.login_time = new DateTime?(DateTime.Parse(row["login_time"].ToString())); } if (row["login_ip"] != null) { _token.login_ip = row["login_ip"].ToString(); } } return(_token); }
public bool Add(Model_SysUser_token model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into SysUser_token("); builder.Append("user_id,product_type,token,token_time,login_time,login_ip)"); builder.Append(" values ("); builder.Append("@user_id,@product_type,@token,@token_time,@login_time,@login_ip)"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@user_id", SqlDbType.Char, 0x24), new SqlParameter("@product_type", SqlDbType.VarChar, 50), new SqlParameter("@token", SqlDbType.VarChar, 50), new SqlParameter("@token_time", SqlDbType.DateTime), new SqlParameter("@login_time", SqlDbType.DateTime), new SqlParameter("@login_ip", SqlDbType.VarChar, 50) }; cmdParms[0].Value = model.user_id; cmdParms[1].Value = model.product_type; cmdParms[2].Value = model.token; cmdParms[3].Value = model.token_time; cmdParms[4].Value = model.login_time; cmdParms[5].Value = model.login_ip; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public List <Model_SysUser_token> DataTableToList(DataTable dt) { List <Model_SysUser_token> list = new List <Model_SysUser_token>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { Model_SysUser_token item = this.dal.DataRowToModel(dt.Rows[i]); if (item != null) { list.Add(item); } } } return(list); }
public bool Update(Model_SysUser_token model) { StringBuilder builder = new StringBuilder(); builder.Append("update SysUser_token set "); builder.Append("token=@token,"); builder.Append("token_time=@token_time,"); builder.Append("login_time=@login_time,"); builder.Append("login_ip=@login_ip"); builder.Append(" where user_id=@user_id and product_type=@product_type "); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@token", SqlDbType.VarChar, 50), new SqlParameter("@token_time", SqlDbType.DateTime), new SqlParameter("@login_time", SqlDbType.DateTime), new SqlParameter("@login_ip", SqlDbType.VarChar, 50), new SqlParameter("@user_id", SqlDbType.Char, 0x24), new SqlParameter("@product_type", SqlDbType.VarChar, 50) }; cmdParms[0].Value = model.token; cmdParms[1].Value = model.token_time; cmdParms[2].Value = model.login_time; cmdParms[3].Value = model.login_ip; cmdParms[4].Value = model.user_id; cmdParms[5].Value = model.product_type; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public bool Add(Model_SysUser_token model) { return(this.dal.Add(model)); }
public bool Update(Model_SysUser_token model) { return(this.dal.Update(model)); }