public static bool ExistsRecord(ModelK8Exp model)
{
StringBuilder builder = new StringBuilder();
builder.Append("Select * from");
builder.Append(" K8_ExploitS ");
builder.Append(" where ");
builder.Append("[appName]=@appName and [addURL]=@addURL and [method]=@method and [cookie]=@cookie and [sumbitData]=@sumbitData");
builder.Append(" and [referer]=@referer and [userAgent]=@userAgent and [encode]=@encode and [allowRedirect]=@allowRedirect");
using (OleDbCommand command = new OleDbCommand(builder.ToString()))
{
command.Parameters.Add("@appName", OleDbType.VarChar, 0x3e8).Value = model.appName;
command.Parameters.Add("@addURL", OleDbType.VarChar).Value = model.addURL;
command.Parameters.Add("@method", OleDbType.VarChar, 20).Value = model.method;
command.Parameters.Add("@cookie", OleDbType.VarChar).Value = model.cookie;
command.Parameters.Add("@sumbitData", OleDbType.VarChar).Value = model.sumbitData;
command.Parameters.Add("@referer", OleDbType.VarChar).Value = model.referer;
command.Parameters.Add("@userAgent", OleDbType.VarChar).Value = model.userAgent;
command.Parameters.Add("@encode", OleDbType.VarChar, 20).Value = model.encode;
command.Parameters.Add("@allowRedirect", OleDbType.VarChar, 20).Value = model.allowRedirect;
if (K8accessHelper.GetRecordCount(command) > 0)
{
return(true);
}
}
return(false);
}
public static bool UpdateRecord(ModelK8Exp model, int ID)
{
StringBuilder builder = new StringBuilder();
builder.Append("UPDATE");
builder.Append(" K8_ExploitS SET");
builder.Append("[appName]=@appName,[btnName]=@btnName,[btnTip]=@btnTip,[method]=@method,");
builder.Append("[cookie]=@cookie,[sumbitData]=@sumbitData,[referer]=@referer,[userAgent]=@userAgent,[encode]=@encode,[allowRedirect]=@allowRedirect,");
builder.Append("[AddTime]=@AddTime");
builder.Append(" WHERE ");
builder.Append("ID=" + ID);
using (OleDbCommand command = new OleDbCommand(builder.ToString()))
{
command.Parameters.Add("@appName", OleDbType.VarChar, 0x3e8).Value = model.appName;
command.Parameters.Add("@btnName", OleDbType.VarChar, 0x3e8).Value = model.btnName;
command.Parameters.Add("@btnTip", OleDbType.VarChar).Value = model.btnTip;
command.Parameters.Add("@method", OleDbType.VarChar, 20).Value = model.method;
command.Parameters.Add("@cookie", OleDbType.VarChar).Value = model.cookie;
command.Parameters.Add("@sumbitData", OleDbType.VarChar).Value = model.sumbitData;
command.Parameters.Add("@referer", OleDbType.VarChar).Value = model.referer;
command.Parameters.Add("@userAgent", OleDbType.VarChar).Value = model.userAgent;
command.Parameters.Add("@encode", OleDbType.VarChar, 20).Value = model.encode;
command.Parameters.Add("@allowRedirect", OleDbType.VarChar, 20).Value = model.allowRedirect;
command.Parameters.Add("@AddTime", OleDbType.VarChar, 50).Value = model.AddTime;
return(K8accessHelper.ExecSQLparameter(command));
}
}
public static bool InsertRecord(ModelK8Exp model)
{
StringBuilder builder = new StringBuilder();
builder.Append("Insert into");
builder.Append(" K8_ExploitS ");
builder.Append("([appName],[btnName],[btnTip],[addURL],[method],[cookie],[sumbitData],[referer],[userAgent],[encode],[allowRedirect],[AddTime])");
builder.Append(" VALUES ");
builder.Append("(@appName,@btnName,@btnTip,@addURL,@method,@cookie,@sumbitData,@referer,@userAgent,@encode,@allowRedirect,@AddTime)");
using (OleDbCommand command = new OleDbCommand(builder.ToString()))
{
command.Parameters.Add("@appName", OleDbType.VarChar, 0x3e8).Value = model.appName;
command.Parameters.Add("@btnName", OleDbType.VarChar, 0x3e8).Value = model.btnName;
command.Parameters.Add("@btnTip", OleDbType.VarChar).Value = model.btnTip;
command.Parameters.Add("@addURL", OleDbType.VarChar).Value = model.addURL;
command.Parameters.Add("@method", OleDbType.VarChar, 20).Value = model.method;
command.Parameters.Add("@cookie", OleDbType.VarChar).Value = model.cookie;
command.Parameters.Add("@sumbitData", OleDbType.VarChar).Value = model.sumbitData;
command.Parameters.Add("@referer", OleDbType.VarChar).Value = model.referer;
command.Parameters.Add("@userAgent", OleDbType.VarChar).Value = model.userAgent;
command.Parameters.Add("@encode", OleDbType.VarChar, 20).Value = model.encode;
command.Parameters.Add("@allowRedirect", OleDbType.VarChar, 20).Value = model.allowRedirect;
command.Parameters.Add("@AddTime", OleDbType.VarChar, 50).Value = model.AddTime;
return(K8accessHelper.ExecSQLparameter(command));
}
}
public static string ExistsRecordGetBtnName(string[] ModelArray)
{
ModelK8Exp model = new ModelK8Exp {
appName = ModelArray[0],
method = ModelArray[1],
cookie = ModelArray[2],
sumbitData = ModelArray[3],
referer = ModelArray[4],
userAgent = ModelArray[5],
encode = ModelArray[6],
allowRedirect = ModelArray[7]
};
return(DALk8Exp.ExistsRecordGetBtnNameDS(model).Tables[0].Rows[0][0].ToString());
}
public static bool ExistsRecord(string[] ModelArray)
{
ModelK8Exp model = new ModelK8Exp {
appName = ModelArray[0],
method = ModelArray[1],
cookie = ModelArray[2],
sumbitData = ModelArray[3],
referer = ModelArray[4],
userAgent = ModelArray[5],
encode = ModelArray[6],
allowRedirect = ModelArray[7],
addURL = ModelArray[8]
};
return(DALk8Exp.ExistsRecord(model));
}
public static bool UpdateRecord(string[] ModelArray, int ID)
{
ModelK8Exp model = new ModelK8Exp {
appName = ModelArray[0],
btnName = ModelArray[1],
btnTip = ModelArray[2],
method = ModelArray[3],
cookie = ModelArray[4],
sumbitData = ModelArray[5],
referer = ModelArray[6],
userAgent = ModelArray[7],
encode = ModelArray[8],
allowRedirect = ModelArray[9],
AddTime = ModelArray[10]
};
return(DALk8Exp.UpdateRecord(model, ID));
}
