/// <summary> /// 更新一条数据 /// </summary> public bool Update(Common.Model.Equipment model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Equipment set "); strSql.Append("EQUIP_ID=@EQUIP_ID,"); strSql.Append("DEPARTMENT=@DEPARTMENT,"); strSql.Append("EQUIP_MAKER=@EQUIP_MAKER,"); strSql.Append("EQUIP_MODEL=@EQUIP_MODEL,"); strSql.Append("LOCID=@LOCID,"); strSql.Append("UPDATED_TIME=@UPDATED_TIME,"); strSql.Append("UPDATED_BY=@UPDATED_BY"); strSql.Append(" where "); SqlParameter[] parameters = { new SqlParameter("@EQUIP_ID", SqlDbType.VarChar, 50), new SqlParameter("@DEPARTMENT", SqlDbType.VarChar, 50), new SqlParameter("@EQUIP_MAKER", SqlDbType.VarChar, 50), new SqlParameter("@EQUIP_MODEL", SqlDbType.VarChar, 50), new SqlParameter("@LOCID", SqlDbType.VarChar, 50), new SqlParameter("@UPDATED_TIME", SqlDbType.DateTime), new SqlParameter("@UPDATED_BY", SqlDbType.VarChar, 50) }; parameters[0].Value = model.EQUIP_ID; parameters[1].Value = model.DEPARTMENT; parameters[2].Value = model.EQUIP_MAKER; parameters[3].Value = model.EQUIP_MODEL; parameters[4].Value = model.LOCID; parameters[5].Value = model.UPDATED_TIME; parameters[6].Value = model.UPDATED_BY; int rows = Common.DB.SqlDB.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Common.Model.Equipment GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 EQUIP_ID,DEPARTMENT,EQUIP_MAKER,EQUIP_MODEL,LOCID,UPDATED_TIME,UPDATED_BY from Equipment "); strSql.Append(" where "); SqlParameter[] parameters = { }; Common.Model.Equipment model = new Common.Model.Equipment(); DataSet ds = Common.DB.SqlDB.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 Add(Common.Model.Equipment model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Equipment("); strSql.Append("EQUIP_ID,DEPARTMENT,EQUIP_MAKER,EQUIP_MODEL,LOCID,UPDATED_TIME,UPDATED_BY)"); strSql.Append(" values ("); strSql.Append("@EQUIP_ID,@DEPARTMENT,@EQUIP_MAKER,@EQUIP_MODEL,@LOCID,@UPDATED_TIME,@UPDATED_BY)"); SqlParameter[] parameters = { new SqlParameter("@EQUIP_ID", SqlDbType.VarChar, 50), new SqlParameter("@DEPARTMENT", SqlDbType.VarChar, 50), new SqlParameter("@EQUIP_MAKER", SqlDbType.VarChar, 50), new SqlParameter("@EQUIP_MODEL", SqlDbType.VarChar, 50), new SqlParameter("@LOCID", SqlDbType.VarChar, 50), new SqlParameter("@UPDATED_TIME", SqlDbType.DateTime), new SqlParameter("@UPDATED_BY", SqlDbType.VarChar, 50) }; parameters[0].Value = model.EQUIP_ID; parameters[1].Value = model.DEPARTMENT; parameters[2].Value = model.EQUIP_MAKER; parameters[3].Value = model.EQUIP_MODEL; parameters[4].Value = model.LOCID; parameters[5].Value = model.UPDATED_TIME; parameters[6].Value = model.UPDATED_BY; int rows = Common.DB.SqlDB.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Common.Model.Equipment DataRowToModel(DataRow row) { Common.Model.Equipment model = new Common.Model.Equipment(); if (row != null) { if (row["EQUIP_ID"] != null) { model.EQUIP_ID = row["EQUIP_ID"].ToString(); } if (row["DEPARTMENT"] != null) { model.DEPARTMENT = row["DEPARTMENT"].ToString(); } if (row["EQUIP_MAKER"] != null) { model.EQUIP_MAKER = row["EQUIP_MAKER"].ToString(); } if (row["EQUIP_MODEL"] != null) { model.EQUIP_MODEL = row["EQUIP_MODEL"].ToString(); } if (row["LOCID"] != null) { model.LOCID = row["LOCID"].ToString(); } if (row["UPDATED_TIME"] != null && row["UPDATED_TIME"].ToString() != "") { model.UPDATED_TIME = DateTime.Parse(row["UPDATED_TIME"].ToString()); } if (row["UPDATED_BY"] != null) { model.UPDATED_BY = row["UPDATED_BY"].ToString(); } } return(model); }