/// <summary> /// 得到一个对象实体 /// </summary> public AcutuatorTypeEntity DataRowToModel(DataRow row) { AcutuatorTypeEntity model = new AcutuatorTypeEntity(); if (row != null) { if (row["At_ID"] != null && row["At_ID"].ToString() != "") { model.At_ID = int.Parse(row["At_ID"].ToString()); } if (row["At_ModelNumber"] != null) { model.At_ModelNumber = row["At_ModelNumber"].ToString(); } if (row["At_name"] != null) { model.At_name = row["At_name"].ToString(); } if (row["At_manufacture"] != null) { model.At_manufacture = row["At_manufacture"].ToString(); } if (row["At_attr_name_1"] != null) { model.At_attr_name_1 = row["At_attr_name_1"].ToString(); } if (row["At_attr_value_1"] != null) { model.At_attr_value_1 = row["At_attr_value_1"].ToString(); } if (row["At_attr_name_2"] != null) { model.At_attr_name_2 = row["At_attr_name_2"].ToString(); } if (row["At_attr_value_2"] != null) { model.At_attr_value_2 = row["At_attr_value_2"].ToString(); } if (row["At_map_working"] != null) { model.At_map_working = row["At_map_working"].ToString(); } if (row["At_map_idle"] != null) { model.At_map_idle = row["At_map_idle"].ToString(); } if (row["At_map_offline"] != null) { model.At_map_offline = row["At_map_offline"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(AcutuatorTypeEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Acutuator_type set "); strSql.Append("At_ModelNumber=@At_ModelNumber,"); strSql.Append("At_name=@At_name,"); strSql.Append("At_manufacture=@At_manufacture,"); strSql.Append("At_attr_name_1=@At_attr_name_1,"); strSql.Append("At_attr_value_1=@At_attr_value_1,"); strSql.Append("At_attr_name_2=@At_attr_name_2,"); strSql.Append("At_attr_value_2=@At_attr_value_2,"); strSql.Append("At_map_working=@At_map_working,"); strSql.Append("At_map_idle=@At_map_idle,"); strSql.Append("At_map_offline=@At_map_offline"); strSql.Append(" where At_ID=@At_ID"); SqlParameter[] parameters = { new SqlParameter("@At_ModelNumber", SqlDbType.NVarChar, 50), new SqlParameter("@At_name", SqlDbType.NVarChar, 50), new SqlParameter("@At_manufacture", SqlDbType.NVarChar, 50), new SqlParameter("@At_attr_name_1", SqlDbType.NVarChar, 50), new SqlParameter("@At_attr_value_1", SqlDbType.NVarChar, 50), new SqlParameter("@At_attr_name_2", SqlDbType.NVarChar, 50), new SqlParameter("@At_attr_value_2", SqlDbType.NVarChar, 50), new SqlParameter("@At_map_working", SqlDbType.NVarChar, 50), new SqlParameter("@At_map_idle", SqlDbType.NVarChar, 50), new SqlParameter("@At_map_offline", SqlDbType.NVarChar, 50), new SqlParameter("@At_ID", SqlDbType.Int, 4) }; parameters[0].Value = model.At_ModelNumber; parameters[1].Value = model.At_name; parameters[2].Value = model.At_manufacture; parameters[3].Value = model.At_attr_name_1; parameters[4].Value = model.At_attr_value_1; parameters[5].Value = model.At_attr_name_2; parameters[6].Value = model.At_attr_value_2; parameters[7].Value = model.At_map_working; parameters[8].Value = model.At_map_idle; parameters[9].Value = model.At_map_offline; parameters[10].Value = model.At_ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(AcutuatorTypeEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Acutuator_type("); strSql.Append("At_ModelNumber,At_name,At_manufacture,At_attr_name_1,At_attr_value_1,At_attr_name_2,At_attr_value_2,At_map_working,At_map_idle,At_map_offline)"); strSql.Append(" values ("); strSql.Append("@At_ModelNumber,@At_name,@At_manufacture,@At_attr_name_1,@At_attr_value_1,@At_attr_name_2,@At_attr_value_2,@At_map_working,@At_map_idle,@At_map_offline)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@At_ModelNumber", SqlDbType.NVarChar, 50), new SqlParameter("@At_name", SqlDbType.NVarChar, 50), new SqlParameter("@At_manufacture", SqlDbType.NVarChar, 50), new SqlParameter("@At_attr_name_1", SqlDbType.NVarChar, 50), new SqlParameter("@At_attr_value_1", SqlDbType.NVarChar, 50), new SqlParameter("@At_attr_name_2", SqlDbType.NVarChar, 50), new SqlParameter("@At_attr_value_2", SqlDbType.NVarChar, 50), new SqlParameter("@At_map_working", SqlDbType.NVarChar, 50), new SqlParameter("@At_map_idle", SqlDbType.NVarChar, 50), new SqlParameter("@At_map_offline", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.At_ModelNumber; parameters[1].Value = model.At_name; parameters[2].Value = model.At_manufacture; parameters[3].Value = model.At_attr_name_1; parameters[4].Value = model.At_attr_value_1; parameters[5].Value = model.At_attr_name_2; parameters[6].Value = model.At_attr_value_2; parameters[7].Value = model.At_map_working; parameters[8].Value = model.At_map_idle; parameters[9].Value = model.At_map_offline; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public AcutuatorTypeEntity GetModel(int At_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 At_ID,At_ModelNumber,At_name,At_manufacture,At_attr_name_1,At_attr_value_1,At_attr_name_2,At_attr_value_2,At_map_working,At_map_idle,At_map_offline from Acutuator_type "); strSql.Append(" where At_ID=@At_ID"); SqlParameter[] parameters = { new SqlParameter("@At_ID", SqlDbType.Int, 4) }; parameters[0].Value = At_ID; AcutuatorTypeEntity model = new AcutuatorTypeEntity(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(AcutuatorTypeEntity model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(AcutuatorTypeEntity model) { return(dal.Add(model)); }