/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Gunark.Model.group model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into gunark_group(");
strSql.Append("GROUP_ID,GROUP_LEADER,AVAILABLE)");
strSql.Append(" values (");
strSql.Append("@GROUP_ID,@GROUP_LEADER,@AVAILABLE)");
MySqlParameter[] parameters = {
new MySqlParameter("@GROUP_ID", MySqlDbType.VarChar,50),
new MySqlParameter("@GROUP_LEADER", MySqlDbType.VarChar,255),
new MySqlParameter("@AVAILABLE", MySqlDbType.Int32,10)};
parameters[0].Value = model.GROUP_ID;
parameters[1].Value = model.GROUP_LEADER;
parameters[2].Value = model.AVAILABLE;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Gunark.Model.gbg model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into gunark_gbg(");
strSql.Append("GGGBID,GUNARK_ID,GUN_LOCATION,BULLET_LOCATION,GROUP_ID)");
strSql.Append(" values (");
strSql.Append("@GGGBID,@GUNARK_ID,@GUN_LOCATION,@BULLET_LOCATION,@GROUP_ID)");
MySqlParameter[] parameters = {
new MySqlParameter("@GGGBID", MySqlDbType.VarChar,50),
new MySqlParameter("@GUNARK_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@GUN_LOCATION", MySqlDbType.Int32,10),
new MySqlParameter("@BULLET_LOCATION", MySqlDbType.Int32,10),
new MySqlParameter("@GROUP_ID", MySqlDbType.VarChar,255)};
parameters[0].Value = model.GGGBID;
parameters[1].Value = model.GUNARK_ID;
parameters[2].Value = model.GUN_LOCATION;
parameters[3].Value = model.BULLET_LOCATION;
parameters[4].Value = model.GROUP_ID;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Gunark.Model.admin model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into gunark_admin(");
strSql.Append("ID,ADMIN_KIND,ADMIN_DUTYBEGIN,ADMIN_DUTYEND,ADMIN_STATUS,USERID,ADMIN_ID)");
strSql.Append(" values (");
strSql.Append("@ID,@ADMIN_KIND,@ADMIN_DUTYBEGIN,@ADMIN_DUTYEND,@ADMIN_STATUS,@USERID,@ADMIN_ID)");
MySqlParameter[] parameters = {
new MySqlParameter("@ID", MySqlDbType.VarChar,255),
new MySqlParameter("@ADMIN_KIND", MySqlDbType.VarChar,10),
new MySqlParameter("@ADMIN_DUTYBEGIN", MySqlDbType.VarChar,255),
new MySqlParameter("@ADMIN_DUTYEND", MySqlDbType.VarChar,255),
new MySqlParameter("@ADMIN_STATUS", MySqlDbType.Int32,10),
new MySqlParameter("@USERID", MySqlDbType.VarChar,255),
new MySqlParameter("@ADMIN_ID", MySqlDbType.VarChar,255)};
parameters[0].Value = model.ID;
parameters[1].Value = model.ADMIN_KIND;
parameters[2].Value = model.ADMIN_DUTYBEGIN;
parameters[3].Value = model.ADMIN_DUTYEND;
parameters[4].Value = model.ADMIN_STATUS;
parameters[5].Value = model.USERID;
parameters[6].Value = model.ADMIN_ID;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Gunark.Model.gun_records model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into gun_records(");
strSql.Append("GUNARK_RECORD_ID,RECORD_BULLET_TYPE,RECORD_GUN_UNM,RECORD_LEND_TIME,RECORD_RETURN_TIME)");
strSql.Append(" values (");
strSql.Append("@GUNARK_RECORD_ID,@RECORD_BULLET_TYPE,@RECORD_GUN_UNM,@RECORD_LEND_TIME,@RECORD_RETURN_TIME)");
MySqlParameter[] parameters = {
new MySqlParameter("@GUNARK_RECORD_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@RECORD_BULLET_TYPE", MySqlDbType.VarChar,255),
new MySqlParameter("@RECORD_GUN_UNM", MySqlDbType.Int32,10),
new MySqlParameter("@RECORD_LEND_TIME", MySqlDbType.DateTime),
new MySqlParameter("@RECORD_RETURN_TIME", MySqlDbType.DateTime)};
parameters[0].Value = model.GUNARK_RECORD_ID;
parameters[1].Value = model.RECORD_BULLET_TYPE;
parameters[2].Value = model.RECORD_GUN_UNM;
parameters[3].Value = model.RECORD_LEND_TIME;
parameters[4].Value = model.RECORD_RETURN_TIME;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Gunark.Model.position_info model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into gunark_position_info(");
strSql.Append("GUN_POSITION_INFO_ID,UNIT_ID,GUNARK_ID,GUN_POSITION_NUMBER,GUN_POSITION_STATUS,GUN_INFO_ID,GUN_BULLET_NUMBER,GUN_TYPE)");
strSql.Append(" values (");
strSql.Append("@GUN_POSITION_INFO_ID,@UNIT_ID,@GUNARK_ID,@GUN_POSITION_NUMBER,@GUN_POSITION_STATUS,@GUN_INFO_ID,@GUN_BULLET_NUMBER,@GUN_TYPE)");
MySqlParameter[] parameters = {
new MySqlParameter("@GUN_POSITION_INFO_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@UNIT_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@GUNARK_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@GUN_POSITION_NUMBER", MySqlDbType.VarChar,255),
new MySqlParameter("@GUN_POSITION_STATUS", MySqlDbType.VarChar,255),
new MySqlParameter("@GUN_INFO_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@GUN_BULLET_NUMBER", MySqlDbType.VarChar,255),
new MySqlParameter("@GUN_TYPE", MySqlDbType.VarChar,255)};
parameters[0].Value = model.GUN_POSITION_INFO_ID;
parameters[1].Value = model.UNIT_ID;
parameters[2].Value = model.GUNARK_ID;
parameters[3].Value = model.GUN_POSITION_NUMBER;
parameters[4].Value = model.GUN_POSITION_STATUS;
parameters[5].Value = model.GUN_INFO_ID;
parameters[6].Value = model.GUN_BULLET_NUMBER;
parameters[7].Value = model.GUN_TYPE;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Gunark.Model.log model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into gunark_log(");
strSql.Append("LOG_TIME,LOG_DISCRIBE,LOG_TYPE,OPREAT_USER,BULLET_NUMBER,GUN_NUMBER,ALARM_TYPE,ALARM_DISCRIBE)");
strSql.Append(" values (");
strSql.Append("@LOG_TIME,@LOG_DISCRIBE,@LOG_TYPE,@OPREAT_USER,@BULLET_NUMBER,@GUN_NUMBER,@ALARM_TYPE,@ALARM_DISCRIBE)");
MySqlParameter[] parameters = {
new MySqlParameter("@LOG_TIME", MySqlDbType.VarChar,255),
new MySqlParameter("@LOG_DISCRIBE", MySqlDbType.VarChar,255),
new MySqlParameter("@LOG_TYPE", MySqlDbType.Int32,2),
new MySqlParameter("@OPREAT_USER", MySqlDbType.VarChar,255),
new MySqlParameter("@BULLET_NUMBER", MySqlDbType.VarChar,255),
new MySqlParameter("@GUN_NUMBER", MySqlDbType.VarChar,255),
new MySqlParameter("@ALARM_TYPE", MySqlDbType.VarChar,255),
new MySqlParameter("@ALARM_DISCRIBE", MySqlDbType.Int32,255)};
parameters[0].Value = model.LOG_TIME;
parameters[1].Value = model.LOG_DISCRIBE;
parameters[2].Value = model.LOG_TYPE;
parameters[3].Value = model.OPREAT_USER;
parameters[4].Value = model.BULLET_NUMBER;
parameters[5].Value = model.GUN_NUMBER;
parameters[6].Value = model.ALARM_TYPE;
parameters[7].Value = model.ALARM_DISCRIBE;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Gunark.Model.task_info_detail model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into gunark_task_info_detail(");
strSql.Append("TASK_DETAIL_ID,TASK_ID,UNIT_ID,GUNARK_ID,GUN_INFO_ID,GUN_POSITION_INFO_ID,BULLET_TYPE,MAGAZINE_INFO_ID,APPLY_BULLET_QTY,DEPLETION_BULLET_QTY,TAKE_GUNBULLET_TIME,RETURN_GUNBULLET_TIME,TAKE_GUNBULLET_USER,RETURN_GUNBULLET_USER,FLAG_TYPE,GUN_TYPE,GUN_DUTY_USER,BULLET_ID)");
strSql.Append(" values (");
strSql.Append("@TASK_DETAIL_ID,@TASK_ID,@UNIT_ID,@GUNARK_ID,@GUN_INFO_ID,@GUN_POSITION_INFO_ID,@BULLET_TYPE,@MAGAZINE_INFO_ID,@APPLY_BULLET_QTY,@DEPLETION_BULLET_QTY,@TAKE_GUNBULLET_TIME,@RETURN_GUNBULLET_TIME,@TAKE_GUNBULLET_USER,@RETURN_GUNBULLET_USER,@FLAG_TYPE,@GUN_TYPE,@GUN_DUTY_USER,@BULLET_ID)");
MySqlParameter[] parameters = {
new MySqlParameter("@TASK_DETAIL_ID", MySqlDbType.VarChar,50),
new MySqlParameter("@TASK_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@UNIT_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@GUNARK_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@GUN_INFO_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@GUN_POSITION_INFO_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@BULLET_TYPE", MySqlDbType.VarChar,255),
new MySqlParameter("@MAGAZINE_INFO_ID", MySqlDbType.VarChar,50),
new MySqlParameter("@APPLY_BULLET_QTY", MySqlDbType.Int32,10),
new MySqlParameter("@DEPLETION_BULLET_QTY", MySqlDbType.Int32,10),
new MySqlParameter("@TAKE_GUNBULLET_TIME", MySqlDbType.Time),
new MySqlParameter("@RETURN_GUNBULLET_TIME", MySqlDbType.Time),
new MySqlParameter("@TAKE_GUNBULLET_USER", MySqlDbType.VarChar,255),
new MySqlParameter("@RETURN_GUNBULLET_USER", MySqlDbType.VarChar,255),
new MySqlParameter("@FLAG_TYPE", MySqlDbType.Int32,10),
new MySqlParameter("@GUN_TYPE", MySqlDbType.VarChar,255),
new MySqlParameter("@GUN_DUTY_USER", MySqlDbType.VarChar,255),
new MySqlParameter("@BULLET_ID", MySqlDbType.VarChar,255)};
parameters[0].Value = model.TASK_DETAIL_ID;
parameters[1].Value = model.TASK_ID;
parameters[2].Value = model.UNIT_ID;
parameters[3].Value = model.GUNARK_ID;
parameters[4].Value = model.GUN_INFO_ID;
parameters[5].Value = model.GUN_POSITION_INFO_ID;
parameters[6].Value = model.BULLET_TYPE;
parameters[7].Value = model.MAGAZINE_INFO_ID;
parameters[8].Value = model.APPLY_BULLET_QTY;
parameters[9].Value = model.DEPLETION_BULLET_QTY;
parameters[10].Value = model.TAKE_GUNBULLET_TIME;
parameters[11].Value = model.RETURN_GUNBULLET_TIME;
parameters[12].Value = model.TAKE_GUNBULLET_USER;
parameters[13].Value = model.RETURN_GUNBULLET_USER;
parameters[14].Value = model.FLAG_TYPE;
parameters[15].Value = model.GUN_TYPE;
parameters[16].Value = model.GUN_DUTY_USER;
parameters[17].Value = model.BULLET_ID;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Gunark.Model.alarm_records model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into gunark_alarm_records(");
strSql.Append("ALARM_RECORD_ID,GUNARK_ID,UNIT_ID,ALARM_TYPE,ALARM_BEGIN_TIME,ALARM_DESCRIPTION,ALARM_HANDLE_TIME,ALARM_HANDLE_USERID,ALARM_HANDLE_TYPE,ALARM_ATATE,TASK_ID,ALARM_FINISH_TIME,ALARM_COUNT)");
strSql.Append(" values (");
strSql.Append("@ALARM_RECORD_ID,@GUNARK_ID,@UNIT_ID,@ALARM_TYPE,@ALARM_BEGIN_TIME,@ALARM_DESCRIPTION,@ALARM_HANDLE_TIME,@ALARM_HANDLE_USERID,@ALARM_HANDLE_TYPE,@ALARM_ATATE,@TASK_ID,@ALARM_FINISH_TIME,@ALARM_COUNT)");
MySqlParameter[] parameters = {
new MySqlParameter("@ALARM_RECORD_ID", MySqlDbType.Int32,10),
new MySqlParameter("@GUNARK_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@UNIT_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@ALARM_TYPE", MySqlDbType.VarChar,255),
new MySqlParameter("@ALARM_BEGIN_TIME", MySqlDbType.Time),
new MySqlParameter("@ALARM_DESCRIPTION", MySqlDbType.VarChar,255),
new MySqlParameter("@ALARM_HANDLE_TIME", MySqlDbType.Time),
new MySqlParameter("@ALARM_HANDLE_USERID", MySqlDbType.VarChar,255),
new MySqlParameter("@ALARM_HANDLE_TYPE", MySqlDbType.VarChar,255),
new MySqlParameter("@ALARM_ATATE", MySqlDbType.Int32,10),
new MySqlParameter("@TASK_ID", MySqlDbType.Int32,10),
new MySqlParameter("@ALARM_FINISH_TIME", MySqlDbType.Time),
new MySqlParameter("@ALARM_COUNT", MySqlDbType.Int32,10)};
parameters[0].Value = model.ALARM_RECORD_ID;
parameters[1].Value = model.GUNARK_ID;
parameters[2].Value = model.UNIT_ID;
parameters[3].Value = model.ALARM_TYPE;
parameters[4].Value = model.ALARM_BEGIN_TIME;
parameters[5].Value = model.ALARM_DESCRIPTION;
parameters[6].Value = model.ALARM_HANDLE_TIME;
parameters[7].Value = model.ALARM_HANDLE_USERID;
parameters[8].Value = model.ALARM_HANDLE_TYPE;
parameters[9].Value = model.ALARM_ATATE;
parameters[10].Value = model.TASK_ID;
parameters[11].Value = model.ALARM_FINISH_TIME;
parameters[12].Value = model.ALARM_COUNT;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Gunark.Model.gun_info model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into gun_info(");
strSql.Append("GUN_INFO_ID,GUNARK_ID,UNIT_ID,GUN_NUMBER,GUN_TYPE,GUN_STATUS,GUN_BULLET_LOCATION,LOSS_DESCRIPTION,REMARK,IN_TIME,OUT_TIME,SYN_FLAG)");
strSql.Append(" values (");
strSql.Append("@GUN_INFO_ID,@GUNARK_ID,@UNIT_ID,@GUN_NUMBER,@GUN_TYPE,@GUN_STATUS,@GUN_BULLET_LOCATION,@LOSS_DESCRIPTION,@REMARK,@IN_TIME,@OUT_TIME,@SYN_FLAG)");
MySqlParameter[] parameters = {
new MySqlParameter("@GUN_INFO_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@GUNARK_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@UNIT_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@GUN_NUMBER", MySqlDbType.VarChar,255),
new MySqlParameter("@GUN_TYPE", MySqlDbType.VarChar,255),
new MySqlParameter("@GUN_STATUS", MySqlDbType.VarChar,255),
new MySqlParameter("@GUN_BULLET_LOCATION", MySqlDbType.VarChar,255),
new MySqlParameter("@LOSS_DESCRIPTION", MySqlDbType.VarChar,255),
new MySqlParameter("@REMARK", MySqlDbType.VarChar,255),
new MySqlParameter("@IN_TIME", MySqlDbType.DateTime),
new MySqlParameter("@OUT_TIME", MySqlDbType.DateTime),
new MySqlParameter("@SYN_FLAG", MySqlDbType.Int32,10)};
parameters[0].Value = model.GUN_INFO_ID;
parameters[1].Value = model.GUNARK_ID;
parameters[2].Value = model.UNIT_ID;
parameters[3].Value = model.GUN_NUMBER;
parameters[4].Value = model.GUN_TYPE;
parameters[5].Value = model.GUN_STATUS;
parameters[6].Value = model.GUN_BULLET_LOCATION;
parameters[7].Value = model.LOSS_DESCRIPTION;
parameters[8].Value = model.REMARK;
parameters[9].Value = model.IN_TIME;
parameters[10].Value = model.OUT_TIME;
parameters[11].Value = model.SYN_FLAG;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Gunark.Model.fingerprint model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into gunark_fingerprint(");
strSql.Append("USER_FINGERPRINT_ID,USER_POLICENUMB,USER_NAME,USER_PWD,FINGER_NUMBER,UNIT_ID,USER_FINGERPRINT,USER_TYPE,IS_UPDATE,USER_BAN,USER_PRIVIEGES)");
strSql.Append(" values (");
strSql.Append("@USER_FINGERPRINT_ID,@USER_POLICENUMB,@USER_NAME,@USER_PWD,@FINGER_NUMBER,@UNIT_ID,@USER_FINGERPRINT,@USER_TYPE,@IS_UPDATE,@USER_BAN,@USER_PRIVIEGES)");
MySqlParameter[] parameters = {
new MySqlParameter("@USER_FINGERPRINT_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@USER_POLICENUMB", MySqlDbType.VarChar,255),
new MySqlParameter("@USER_NAME", MySqlDbType.VarChar,255),
new MySqlParameter("@USER_PWD", MySqlDbType.VarChar,255),
new MySqlParameter("@FINGER_NUMBER", MySqlDbType.VarChar,255),
new MySqlParameter("@UNIT_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@USER_FINGERPRINT", MySqlDbType.Blob),
new MySqlParameter("@USER_TYPE", MySqlDbType.VarChar,255),
new MySqlParameter("@IS_UPDATE", MySqlDbType.Int32,10),
new MySqlParameter("@USER_BAN", MySqlDbType.Int32,10),
new MySqlParameter("@USER_PRIVIEGES", MySqlDbType.Int32,10)};
parameters[0].Value = model.USER_FINGERPRINT_ID;
parameters[1].Value = model.USER_POLICENUMB;
parameters[2].Value = model.USER_NAME;
parameters[3].Value = model.USER_PWD;
parameters[4].Value = model.FINGER_NUMBER;
parameters[5].Value = model.UNIT_ID;
parameters[6].Value = model.USER_FINGERPRINT;
parameters[7].Value = model.USER_TYPE;
parameters[8].Value = model.IS_UPDATE;
parameters[9].Value = model.USER_BAN;
parameters[10].Value = model.USER_PRIVIEGES;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Gunark.Model.magazine_info model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into gunark_magazine_info(");
strSql.Append("MAGAZINE_INFO_ID,GUNARK_ID,UNIT_ID,MAGAZINE_NUMBER,STOCK_QTY,MAGAZINE_NAME,CAPACITY_QTY,SYN_FLAG,BULLET_MODEL,MAGAZINE_STATUS,BULLET_GROUP_ID)");
strSql.Append(" values (");
strSql.Append("@MAGAZINE_INFO_ID,@GUNARK_ID,@UNIT_ID,@MAGAZINE_NUMBER,@STOCK_QTY,@MAGAZINE_NAME,@CAPACITY_QTY,@SYN_FLAG,@BULLET_MODEL,@MAGAZINE_STATUS,@BULLET_GROUP_ID)");
MySqlParameter[] parameters = {
new MySqlParameter("@MAGAZINE_INFO_ID", MySqlDbType.VarChar,50),
new MySqlParameter("@GUNARK_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@UNIT_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@MAGAZINE_NUMBER", MySqlDbType.VarChar,255),
new MySqlParameter("@STOCK_QTY", MySqlDbType.Int32,10),
new MySqlParameter("@MAGAZINE_NAME", MySqlDbType.VarChar,255),
new MySqlParameter("@CAPACITY_QTY", MySqlDbType.Int32,10),
new MySqlParameter("@SYN_FLAG", MySqlDbType.Int32,10),
new MySqlParameter("@BULLET_MODEL", MySqlDbType.VarChar,255),
new MySqlParameter("@MAGAZINE_STATUS", MySqlDbType.Int32,10),
new MySqlParameter("@BULLET_GROUP_ID", MySqlDbType.VarChar,50)};
parameters[0].Value = model.MAGAZINE_INFO_ID;
parameters[1].Value = model.GUNARK_ID;
parameters[2].Value = model.UNIT_ID;
parameters[3].Value = model.MAGAZINE_NUMBER;
parameters[4].Value = model.STOCK_QTY;
parameters[5].Value = model.MAGAZINE_NAME;
parameters[6].Value = model.CAPACITY_QTY;
parameters[7].Value = model.SYN_FLAG;
parameters[8].Value = model.BULLET_MODEL;
parameters[9].Value = model.MAGAZINE_STATUS;
parameters[10].Value = model.BULLET_GROUP_ID;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Gunark.Model.magazine_info model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update gunark_magazine_info set ");
strSql.Append("GUNARK_ID=@GUNARK_ID,");
strSql.Append("UNIT_ID=@UNIT_ID,");
strSql.Append("MAGAZINE_NUMBER=@MAGAZINE_NUMBER,");
strSql.Append("STOCK_QTY=@STOCK_QTY,");
strSql.Append("MAGAZINE_NAME=@MAGAZINE_NAME,");
strSql.Append("CAPACITY_QTY=@CAPACITY_QTY,");
strSql.Append("SYN_FLAG=@SYN_FLAG,");
strSql.Append("BULLET_MODEL=@BULLET_MODEL,");
strSql.Append("MAGAZINE_STATUS=@MAGAZINE_STATUS,");
strSql.Append("BULLET_GROUP_ID=@BULLET_GROUP_ID");
strSql.Append(" where MAGAZINE_INFO_ID=@MAGAZINE_INFO_ID ");
MySqlParameter[] parameters = {
new MySqlParameter("@GUNARK_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@UNIT_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@MAGAZINE_NUMBER", MySqlDbType.VarChar,255),
new MySqlParameter("@STOCK_QTY", MySqlDbType.Int32,10),
new MySqlParameter("@MAGAZINE_NAME", MySqlDbType.VarChar,255),
new MySqlParameter("@CAPACITY_QTY", MySqlDbType.Int32,10),
new MySqlParameter("@SYN_FLAG", MySqlDbType.Int32,10),
new MySqlParameter("@BULLET_MODEL", MySqlDbType.VarChar,255),
new MySqlParameter("@MAGAZINE_STATUS", MySqlDbType.Int32,10),
new MySqlParameter("@BULLET_GROUP_ID", MySqlDbType.VarChar,50),
new MySqlParameter("@MAGAZINE_INFO_ID", MySqlDbType.VarChar,50)};
parameters[0].Value = model.GUNARK_ID;
parameters[1].Value = model.UNIT_ID;
parameters[2].Value = model.MAGAZINE_NUMBER;
parameters[3].Value = model.STOCK_QTY;
parameters[4].Value = model.MAGAZINE_NAME;
parameters[5].Value = model.CAPACITY_QTY;
parameters[6].Value = model.SYN_FLAG;
parameters[7].Value = model.BULLET_MODEL;
parameters[8].Value = model.MAGAZINE_STATUS;
parameters[9].Value = model.BULLET_GROUP_ID;
parameters[10].Value = model.MAGAZINE_INFO_ID;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Gunark.Model.task_info_detail model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update gunark_task_info_detail set ");
strSql.Append("TASK_ID=@TASK_ID,");
strSql.Append("UNIT_ID=@UNIT_ID,");
strSql.Append("GUNARK_ID=@GUNARK_ID,");
strSql.Append("GUN_INFO_ID=@GUN_INFO_ID,");
strSql.Append("GUN_POSITION_INFO_ID=@GUN_POSITION_INFO_ID,");
strSql.Append("BULLET_TYPE=@BULLET_TYPE,");
strSql.Append("MAGAZINE_INFO_ID=@MAGAZINE_INFO_ID,");
strSql.Append("APPLY_BULLET_QTY=@APPLY_BULLET_QTY,");
strSql.Append("DEPLETION_BULLET_QTY=@DEPLETION_BULLET_QTY,");
strSql.Append("TAKE_GUNBULLET_TIME=@TAKE_GUNBULLET_TIME,");
strSql.Append("RETURN_GUNBULLET_TIME=@RETURN_GUNBULLET_TIME,");
strSql.Append("TAKE_GUNBULLET_USER=@TAKE_GUNBULLET_USER,");
strSql.Append("RETURN_GUNBULLET_USER=@RETURN_GUNBULLET_USER,");
strSql.Append("FLAG_TYPE=@FLAG_TYPE,");
strSql.Append("GUN_TYPE=@GUN_TYPE,");
strSql.Append("GUN_DUTY_USER=@GUN_DUTY_USER,");
strSql.Append("BULLET_ID=@BULLET_ID");
strSql.Append(" where TASK_DETAIL_ID=@TASK_DETAIL_ID ");
MySqlParameter[] parameters = {
new MySqlParameter("@TASK_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@UNIT_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@GUNARK_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@GUN_INFO_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@GUN_POSITION_INFO_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@BULLET_TYPE", MySqlDbType.VarChar,255),
new MySqlParameter("@MAGAZINE_INFO_ID", MySqlDbType.VarChar,50),
new MySqlParameter("@APPLY_BULLET_QTY", MySqlDbType.Int32,10),
new MySqlParameter("@DEPLETION_BULLET_QTY", MySqlDbType.Int32,10),
new MySqlParameter("@TAKE_GUNBULLET_TIME", MySqlDbType.Time),
new MySqlParameter("@RETURN_GUNBULLET_TIME", MySqlDbType.Time),
new MySqlParameter("@TAKE_GUNBULLET_USER", MySqlDbType.VarChar,255),
new MySqlParameter("@RETURN_GUNBULLET_USER", MySqlDbType.VarChar,255),
new MySqlParameter("@FLAG_TYPE", MySqlDbType.Int32,10),
new MySqlParameter("@GUN_TYPE", MySqlDbType.VarChar,255),
new MySqlParameter("@GUN_DUTY_USER", MySqlDbType.VarChar,255),
new MySqlParameter("@BULLET_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@TASK_DETAIL_ID", MySqlDbType.VarChar,50)};
parameters[0].Value = model.TASK_ID;
parameters[1].Value = model.UNIT_ID;
parameters[2].Value = model.GUNARK_ID;
parameters[3].Value = model.GUN_INFO_ID;
parameters[4].Value = model.GUN_POSITION_INFO_ID;
parameters[5].Value = model.BULLET_TYPE;
parameters[6].Value = model.MAGAZINE_INFO_ID;
parameters[7].Value = model.APPLY_BULLET_QTY;
parameters[8].Value = model.DEPLETION_BULLET_QTY;
parameters[9].Value = model.TAKE_GUNBULLET_TIME;
parameters[10].Value = model.RETURN_GUNBULLET_TIME;
parameters[11].Value = model.TAKE_GUNBULLET_USER;
parameters[12].Value = model.RETURN_GUNBULLET_USER;
parameters[13].Value = model.FLAG_TYPE;
parameters[14].Value = model.GUN_TYPE;
parameters[15].Value = model.GUN_DUTY_USER;
parameters[16].Value = model.BULLET_ID;
parameters[17].Value = model.TASK_DETAIL_ID;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Gunark.Model.fingerprint model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Gunark.Model.task_info model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Gunark.Model.gbg model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update gunark_gbg set ");
strSql.Append("GUNARK_ID=@GUNARK_ID,");
strSql.Append("GUN_LOCATION=@GUN_LOCATION,");
strSql.Append("BULLET_LOCATION=@BULLET_LOCATION,");
strSql.Append("GROUP_ID=@GROUP_ID");
strSql.Append(" where GGGBID=@GGGBID ");
MySqlParameter[] parameters = {
new MySqlParameter("@GUNARK_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@GUN_LOCATION", MySqlDbType.Int32,10),
new MySqlParameter("@BULLET_LOCATION", MySqlDbType.Int32,10),
new MySqlParameter("@GROUP_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@GGGBID", MySqlDbType.VarChar,50)};
parameters[0].Value = model.GUNARK_ID;
parameters[1].Value = model.GUN_LOCATION;
parameters[2].Value = model.BULLET_LOCATION;
parameters[3].Value = model.GROUP_ID;
parameters[4].Value = model.GGGBID;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Gunark.Model.fingerprint model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Gunark.Model.gun_info model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update gun_info set ");
strSql.Append("GUNARK_ID=@GUNARK_ID,");
strSql.Append("UNIT_ID=@UNIT_ID,");
strSql.Append("GUN_NUMBER=@GUN_NUMBER,");
strSql.Append("GUN_TYPE=@GUN_TYPE,");
strSql.Append("GUN_STATUS=@GUN_STATUS,");
strSql.Append("GUN_BULLET_LOCATION=@GUN_BULLET_LOCATION,");
strSql.Append("LOSS_DESCRIPTION=@LOSS_DESCRIPTION,");
strSql.Append("REMARK=@REMARK,");
strSql.Append("IN_TIME=@IN_TIME,");
strSql.Append("OUT_TIME=@OUT_TIME,");
strSql.Append("SYN_FLAG=@SYN_FLAG");
strSql.Append(" where GUN_INFO_ID=@GUN_INFO_ID ");
MySqlParameter[] parameters = {
new MySqlParameter("@GUNARK_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@UNIT_ID", MySqlDbType.VarChar,255),
new MySqlParameter("@GUN_NUMBER", MySqlDbType.VarChar,255),
new MySqlParameter("@GUN_TYPE", MySqlDbType.VarChar,255),
new MySqlParameter("@GUN_STATUS", MySqlDbType.VarChar,255),
new MySqlParameter("@GUN_BULLET_LOCATION", MySqlDbType.VarChar,255),
new MySqlParameter("@LOSS_DESCRIPTION", MySqlDbType.VarChar,255),
new MySqlParameter("@REMARK", MySqlDbType.VarChar,255),
new MySqlParameter("@IN_TIME", MySqlDbType.DateTime),
new MySqlParameter("@OUT_TIME", MySqlDbType.DateTime),
new MySqlParameter("@SYN_FLAG", MySqlDbType.Int32,10),
new MySqlParameter("@GUN_INFO_ID", MySqlDbType.VarChar,255)};
parameters[0].Value = model.GUNARK_ID;
parameters[1].Value = model.UNIT_ID;
parameters[2].Value = model.GUN_NUMBER;
parameters[3].Value = model.GUN_TYPE;
parameters[4].Value = model.GUN_STATUS;
parameters[5].Value = model.GUN_BULLET_LOCATION;
parameters[6].Value = model.LOSS_DESCRIPTION;
parameters[7].Value = model.REMARK;
parameters[8].Value = model.IN_TIME;
parameters[9].Value = model.OUT_TIME;
parameters[10].Value = model.SYN_FLAG;
parameters[11].Value = model.GUN_INFO_ID;
int rows=DbHelperMySQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Gunark.Model.task_info model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Gunark.Model.group model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update gunark_group set ");
strSql.Append("GROUP_LEADER=@GROUP_LEADER,");
strSql.Append("AVAILABLE=@AVAILABLE");
strSql.Append(" where GROUP_ID=@GROUP_ID ");
MySqlParameter[] parameters = {
new MySqlParameter("@GROUP_LEADER", MySqlDbType.VarChar,255),
new MySqlParameter("@AVAILABLE", MySqlDbType.Int32,10),
new MySqlParameter("@GROUP_ID", MySqlDbType.VarChar,50)};
parameters[0].Value = model.GROUP_LEADER;
parameters[1].Value = model.AVAILABLE;
parameters[2].Value = model.GROUP_ID;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Gunark.Model.gun_records model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Gunark.Model.log model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Gunark.Model.position_info model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Gunark.Model.admin model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Gunark.Model.log model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update gunark_log set ");
strSql.Append("LOG_TIME=@LOG_TIME,");
strSql.Append("LOG_DISCRIBE=@LOG_DISCRIBE,");
strSql.Append("LOG_TYPE=@LOG_TYPE,");
strSql.Append("OPREAT_USER=@OPREAT_USER,");
strSql.Append("BULLET_NUMBER=@BULLET_NUMBER,");
strSql.Append("GUN_NUMBER=@GUN_NUMBER,");
strSql.Append("ALARM_TYPE=@ALARM_TYPE,");
strSql.Append("ALARM_DISCRIBE=@ALARM_DISCRIBE");
strSql.Append(" where ID=@ID");
MySqlParameter[] parameters = {
new MySqlParameter("@LOG_TIME", MySqlDbType.VarChar,255),
new MySqlParameter("@LOG_DISCRIBE", MySqlDbType.VarChar,255),
new MySqlParameter("@LOG_TYPE", MySqlDbType.Int32,2),
new MySqlParameter("@OPREAT_USER", MySqlDbType.VarChar,255),
new MySqlParameter("@BULLET_NUMBER", MySqlDbType.VarChar,255),
new MySqlParameter("@GUN_NUMBER", MySqlDbType.VarChar,255),
new MySqlParameter("@ALARM_TYPE", MySqlDbType.VarChar,255),
new MySqlParameter("@ALARM_DISCRIBE", MySqlDbType.Int32,255),
new MySqlParameter("@ID", MySqlDbType.Int32,11)};
parameters[0].Value = model.LOG_TIME;
parameters[1].Value = model.LOG_DISCRIBE;
parameters[2].Value = model.LOG_TYPE;
parameters[3].Value = model.OPREAT_USER;
parameters[4].Value = model.BULLET_NUMBER;
parameters[5].Value = model.GUN_NUMBER;
parameters[6].Value = model.ALARM_TYPE;
parameters[7].Value = model.ALARM_DISCRIBE;
parameters[8].Value = model.ID;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Gunark.Model.gunark model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update gunark_gunark set ");
strSql.Append("GUNARK_NUMBER=@GUNARK_NUMBER,");
strSql.Append("GUNARK_BIGTYPE=@GUNARK_BIGTYPE,");
strSql.Append("GUNARK_IP=@GUNARK_IP,");
strSql.Append("GUNARK_GATEWAY=@GUNARK_GATEWAY,");
strSql.Append("GUNARK_SUBNET=@GUNARK_SUBNET,");
strSql.Append("GUNARK_TYPE=@GUNARK_TYPE,");
strSql.Append("GUNARK_NAME=@GUNARK_NAME,");
strSql.Append("GUNARK_SIZE=@GUNARK_SIZE,");
strSql.Append("GUNARK_NUMOFGUN=@GUNARK_NUMOFGUN,");
strSql.Append("GUNARK_NUMOFBULLET=@GUNARK_NUMOFBULLET,");
strSql.Append("GUNARK_NUMOFBULLETWAREHOUSE=@GUNARK_NUMOFBULLETWAREHOUSE,");
strSql.Append("GUNARK_PORT=@GUNARK_PORT,");
strSql.Append("GUNARK_LOCATION=@GUNARK_LOCATION,");
strSql.Append("GUNARK_PICURL=@GUNARK_PICURL,");
strSql.Append("GUNARK_REMARK=@GUNARK_REMARK,");
strSql.Append("GUNARK_VERIFYSTATUS=@GUNARK_VERIFYSTATUS,");
strSql.Append("GUNARK_ISSEALUP=@GUNARK_ISSEALUP,");
strSql.Append("GUNARK_ISONLINE=@GUNARK_ISONLINE,");
strSql.Append("GUNARK_ISPOWERON=@GUNARK_ISPOWERON,");
strSql.Append("GUNARK_ISOPEN=@GUNARK_ISOPEN,");
strSql.Append("GUNARK_ISWARNING=@GUNARK_ISWARNING,");
strSql.Append("GUNARK_ENTERTIME=@GUNARK_ENTERTIME,");
strSql.Append("UNITINFO_CODE=@UNITINFO_CODE,");
strSql.Append("GUNARK_STATUS=@GUNARK_STATUS,");
strSql.Append("GUNARK_CAMERAIP=@GUNARK_CAMERAIP,");
strSql.Append("GUNARK_VERSION=@GUNARK_VERSION,");
strSql.Append("GUNARK_ALCOHOLIS=@GUNARK_ALCOHOLIS,");
strSql.Append("GUNARK_CODEIS=@GUNARK_CODEIS,");
strSql.Append("GUNARK_GUNARKIS=@GUNARK_GUNARKIS,");
strSql.Append("GUNARK_GGGBUNIQUEIS=@GUNARK_GGGBUNIQUEIS,");
strSql.Append("GUNARK_ISCHECKING=@GUNARK_ISCHECKING,");
strSql.Append("GUNARK_ISOFFLINE=@GUNARK_ISOFFLINE,");
strSql.Append("GUNARK_ISCARDREADING=@GUNARK_ISCARDREADING,");
strSql.Append("GUNARK_EMERGENCYNUMBER=@GUNARK_EMERGENCYNUMBER");
strSql.Append(" where GUNARK_ID=@GUNARK_ID ");
MySqlParameter[] parameters = {
new MySqlParameter("@GUNARK_NUMBER", MySqlDbType.VarChar,255),
new MySqlParameter("@GUNARK_BIGTYPE", MySqlDbType.VarChar,255),
new MySqlParameter("@GUNARK_IP", MySqlDbType.VarChar,255),
new MySqlParameter("@GUNARK_GATEWAY", MySqlDbType.VarChar,255),
new MySqlParameter("@GUNARK_SUBNET", MySqlDbType.VarChar,255),
new MySqlParameter("@GUNARK_TYPE", MySqlDbType.VarChar,255),
new MySqlParameter("@GUNARK_NAME", MySqlDbType.VarChar,255),
new MySqlParameter("@GUNARK_SIZE", MySqlDbType.VarChar,255),
new MySqlParameter("@GUNARK_NUMOFGUN", MySqlDbType.VarChar,255),
new MySqlParameter("@GUNARK_NUMOFBULLET", MySqlDbType.VarChar,255),
new MySqlParameter("@GUNARK_NUMOFBULLETWAREHOUSE", MySqlDbType.VarChar,255),
new MySqlParameter("@GUNARK_PORT", MySqlDbType.VarChar,255),
new MySqlParameter("@GUNARK_LOCATION", MySqlDbType.VarChar,255),
new MySqlParameter("@GUNARK_PICURL", MySqlDbType.VarChar,255),
new MySqlParameter("@GUNARK_REMARK", MySqlDbType.VarChar,255),
new MySqlParameter("@GUNARK_VERIFYSTATUS", MySqlDbType.VarChar,255),
new MySqlParameter("@GUNARK_ISSEALUP", MySqlDbType.Int32,1),
new MySqlParameter("@GUNARK_ISONLINE", MySqlDbType.Int32,1),
new MySqlParameter("@GUNARK_ISPOWERON", MySqlDbType.Int32,1),
new MySqlParameter("@GUNARK_ISOPEN", MySqlDbType.Int32,1),
new MySqlParameter("@GUNARK_ISWARNING", MySqlDbType.Int32,1),
new MySqlParameter("@GUNARK_ENTERTIME", MySqlDbType.VarChar,255),
new MySqlParameter("@UNITINFO_CODE", MySqlDbType.VarChar,255),
new MySqlParameter("@GUNARK_STATUS", MySqlDbType.Int32,10),
new MySqlParameter("@GUNARK_CAMERAIP", MySqlDbType.VarChar,255),
new MySqlParameter("@GUNARK_VERSION", MySqlDbType.VarChar,255),
new MySqlParameter("@GUNARK_ALCOHOLIS", MySqlDbType.VarChar,255),
new MySqlParameter("@GUNARK_CODEIS", MySqlDbType.VarChar,255),
new MySqlParameter("@GUNARK_GUNARKIS", MySqlDbType.VarChar,255),
new MySqlParameter("@GUNARK_GGGBUNIQUEIS", MySqlDbType.VarChar,255),
new MySqlParameter("@GUNARK_ISCHECKING", MySqlDbType.Int32,10),
new MySqlParameter("@GUNARK_ISOFFLINE", MySqlDbType.Int32,10),
new MySqlParameter("@GUNARK_ISCARDREADING", MySqlDbType.Int32,10),
new MySqlParameter("@GUNARK_EMERGENCYNUMBER", MySqlDbType.Int32,10),
new MySqlParameter("@GUNARK_ID", MySqlDbType.VarChar,255)};
parameters[0].Value = model.GUNARK_NUMBER;
parameters[1].Value = model.GUNARK_BIGTYPE;
parameters[2].Value = model.GUNARK_IP;
parameters[3].Value = model.GUNARK_GATEWAY;
parameters[4].Value = model.GUNARK_SUBNET;
parameters[5].Value = model.GUNARK_TYPE;
parameters[6].Value = model.GUNARK_NAME;
parameters[7].Value = model.GUNARK_SIZE;
parameters[8].Value = model.GUNARK_NUMOFGUN;
parameters[9].Value = model.GUNARK_NUMOFBULLET;
parameters[10].Value = model.GUNARK_NUMOFBULLETWAREHOUSE;
parameters[11].Value = model.GUNARK_PORT;
parameters[12].Value = model.GUNARK_LOCATION;
parameters[13].Value = model.GUNARK_PICURL;
parameters[14].Value = model.GUNARK_REMARK;
parameters[15].Value = model.GUNARK_VERIFYSTATUS;
parameters[16].Value = model.GUNARK_ISSEALUP;
parameters[17].Value = model.GUNARK_ISONLINE;
parameters[18].Value = model.GUNARK_ISPOWERON;
parameters[19].Value = model.GUNARK_ISOPEN;
parameters[20].Value = model.GUNARK_ISWARNING;
parameters[21].Value = model.GUNARK_ENTERTIME;
parameters[22].Value = model.UNITINFO_CODE;
parameters[23].Value = model.GUNARK_STATUS;
parameters[24].Value = model.GUNARK_CAMERAIP;
parameters[25].Value = model.GUNARK_VERSION;
parameters[26].Value = model.GUNARK_ALCOHOLIS;
parameters[27].Value = model.GUNARK_CODEIS;
parameters[28].Value = model.GUNARK_GUNARKIS;
parameters[29].Value = model.GUNARK_GGGBUNIQUEIS;
parameters[30].Value = model.GUNARK_ISCHECKING;
parameters[31].Value = model.GUNARK_ISOFFLINE;
parameters[32].Value = model.GUNARK_ISCARDREADING;
parameters[33].Value = model.GUNARK_EMERGENCYNUMBER;
parameters[34].Value = model.GUNARK_ID;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Gunark.Model.position_info model)
{
return dal.Add(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Gunark.Model.admin model)
{
return dal.Add(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Gunark.Model.log model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Gunark.Model.gun_records model)
{
return dal.Update(model);
}
