Exemplo n.º 1
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public Gunark.Model.gun_info DataRowToModel(DataRow row)
 {
     Gunark.Model.gun_info model=new Gunark.Model.gun_info();
     if (row != null)
     {
         if(row["GUN_INFO_ID"]!=null)
         {
             model.GUN_INFO_ID=row["GUN_INFO_ID"].ToString();
         }
         if(row["GUNARK_ID"]!=null)
         {
             model.GUNARK_ID=row["GUNARK_ID"].ToString();
         }
         if(row["UNIT_ID"]!=null)
         {
             model.UNIT_ID=row["UNIT_ID"].ToString();
         }
         if(row["GUN_NUMBER"]!=null)
         {
             model.GUN_NUMBER=row["GUN_NUMBER"].ToString();
         }
         if(row["GUN_TYPE"]!=null)
         {
             model.GUN_TYPE=row["GUN_TYPE"].ToString();
         }
         if(row["GUN_STATUS"]!=null)
         {
             model.GUN_STATUS=row["GUN_STATUS"].ToString();
         }
         if(row["GUN_BULLET_LOCATION"]!=null)
         {
             model.GUN_BULLET_LOCATION=row["GUN_BULLET_LOCATION"].ToString();
         }
         if(row["LOSS_DESCRIPTION"]!=null)
         {
             model.LOSS_DESCRIPTION=row["LOSS_DESCRIPTION"].ToString();
         }
         if(row["REMARK"]!=null)
         {
             model.REMARK=row["REMARK"].ToString();
         }
         if(row["IN_TIME"]!=null && row["IN_TIME"].ToString()!="")
         {
             model.IN_TIME=DateTime.Parse(row["IN_TIME"].ToString());
         }
         if(row["OUT_TIME"]!=null && row["OUT_TIME"].ToString()!="")
         {
             model.OUT_TIME=DateTime.Parse(row["OUT_TIME"].ToString());
         }
         if(row["SYN_FLAG"]!=null && row["SYN_FLAG"].ToString()!="")
         {
             model.SYN_FLAG=int.Parse(row["SYN_FLAG"].ToString());
         }
     }
     return model;
 }
Exemplo n.º 2
0
        /// <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);
            }
        }
Exemplo n.º 3
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public Gunark.Model.gun_info DataRowToModel(DataRow row)
 {
     Gunark.Model.gun_info model = new Gunark.Model.gun_info();
     if (row != null)
     {
         if (row["GUN_INFO_ID"] != null)
         {
             model.GUN_INFO_ID = row["GUN_INFO_ID"].ToString();
         }
         if (row["GUNARK_ID"] != null)
         {
             model.GUNARK_ID = row["GUNARK_ID"].ToString();
         }
         if (row["UNIT_ID"] != null)
         {
             model.UNIT_ID = row["UNIT_ID"].ToString();
         }
         if (row["GUN_NUMBER"] != null)
         {
             model.GUN_NUMBER = row["GUN_NUMBER"].ToString();
         }
         if (row["GUN_TYPE"] != null)
         {
             model.GUN_TYPE = row["GUN_TYPE"].ToString();
         }
         if (row["GUN_STATUS"] != null)
         {
             model.GUN_STATUS = row["GUN_STATUS"].ToString();
         }
         if (row["GUN_BULLET_LOCATION"] != null)
         {
             model.GUN_BULLET_LOCATION = row["GUN_BULLET_LOCATION"].ToString();
         }
         if (row["LOSS_DESCRIPTION"] != null)
         {
             model.LOSS_DESCRIPTION = row["LOSS_DESCRIPTION"].ToString();
         }
         if (row["REMARK"] != null)
         {
             model.REMARK = row["REMARK"].ToString();
         }
         if (row["IN_TIME"] != null && row["IN_TIME"].ToString() != "")
         {
             model.IN_TIME = DateTime.Parse(row["IN_TIME"].ToString());
         }
         if (row["OUT_TIME"] != null && row["OUT_TIME"].ToString() != "")
         {
             model.OUT_TIME = DateTime.Parse(row["OUT_TIME"].ToString());
         }
         if (row["SYN_FLAG"] != null && row["SYN_FLAG"].ToString() != "")
         {
             model.SYN_FLAG = int.Parse(row["SYN_FLAG"].ToString());
         }
     }
     return(model);
 }
Exemplo n.º 4
0
        /// <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);
            }
        }
Exemplo n.º 5
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public Gunark.Model.gun_info GetModel(string GUN_INFO_ID)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select 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 from gun_info ");
            strSql.Append(" where GUN_INFO_ID=@GUN_INFO_ID ");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@GUN_INFO_ID", MySqlDbType.VarChar, 255)
            };
            parameters[0].Value = GUN_INFO_ID;

            Gunark.Model.gun_info model = new Gunark.Model.gun_info();
            DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }
Exemplo n.º 6
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public Gunark.Model.gun_info GetModel(string GUN_INFO_ID)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("select 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 from gun_info ");
            strSql.Append(" where GUN_INFO_ID=@GUN_INFO_ID ");
            MySqlParameter[] parameters = {
                    new MySqlParameter("@GUN_INFO_ID", MySqlDbType.VarChar,255)			};
            parameters[0].Value = GUN_INFO_ID;

            Gunark.Model.gun_info model=new Gunark.Model.gun_info();
            DataSet ds=DbHelperMySQL.Query(strSql.ToString(),parameters);
            if(ds.Tables[0].Rows.Count>0)
            {
                return DataRowToModel(ds.Tables[0].Rows[0]);
            }
            else
            {
                return null;
            }
        }