/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.T_DataMemory model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_DataMemory set "); strSql.Append("PointID=@PointID,"); strSql.Append("HsdTableName=@HsdTableName,"); strSql.Append("AddTableName=@AddTableName,"); strSql.Append("GfTableName=@GfTableName,"); strSql.Append("GfAddTableName=@GfAddTableName,"); strSql.Append("MnCode=@MnCode"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@PointID", SqlDbType.Int, 4), new SqlParameter("@HsdTableName", SqlDbType.NVarChar, 50), new SqlParameter("@AddTableName", SqlDbType.NVarChar, 50), new SqlParameter("@GfTableName", SqlDbType.NVarChar, 50), new SqlParameter("@GfAddTableName", SqlDbType.NVarChar, 50), new SqlParameter("@MnCode", SqlDbType.NVarChar, 25), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.PointID; parameters[1].Value = model.HsdTableName; parameters[2].Value = model.AddTableName; parameters[3].Value = model.GfTableName; parameters[4].Value = model.GfAddTableName; parameters[5].Value = model.MnCode; parameters[6].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.T_DataMemory DataRowToModel(DataRow row) { Maticsoft.Model.T_DataMemory model = new Maticsoft.Model.T_DataMemory(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["PointID"] != null && row["PointID"].ToString() != "") { model.PointID = int.Parse(row["PointID"].ToString()); } if (row["HsdTableName"] != null) { model.HsdTableName = row["HsdTableName"].ToString(); } if (row["AddTableName"] != null) { model.AddTableName = row["AddTableName"].ToString(); } if (row["GfTableName"] != null) { model.GfTableName = row["GfTableName"].ToString(); } if (row["GfAddTableName"] != null) { model.GfAddTableName = row["GfAddTableName"].ToString(); } if (row["MnCode"] != null) { model.MnCode = row["MnCode"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Maticsoft.Model.T_DataMemory model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_DataMemory("); strSql.Append("PointID,HsdTableName,AddTableName,GfTableName,GfAddTableName,MnCode)"); strSql.Append(" values ("); strSql.Append("@PointID,@HsdTableName,@AddTableName,@GfTableName,@GfAddTableName,@MnCode)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@PointID", SqlDbType.Int, 4), new SqlParameter("@HsdTableName", SqlDbType.NVarChar, 50), new SqlParameter("@AddTableName", SqlDbType.NVarChar, 50), new SqlParameter("@GfTableName", SqlDbType.NVarChar, 50), new SqlParameter("@GfAddTableName", SqlDbType.NVarChar, 50), new SqlParameter("@MnCode", SqlDbType.NVarChar, 25) }; parameters[0].Value = model.PointID; parameters[1].Value = model.HsdTableName; parameters[2].Value = model.AddTableName; parameters[3].Value = model.GfTableName; parameters[4].Value = model.GfAddTableName; parameters[5].Value = model.MnCode; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.T_DataMemory GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,PointID,HsdTableName,AddTableName,GfTableName,GfAddTableName,MnCode from T_DataMemory "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; Maticsoft.Model.T_DataMemory model = new Maticsoft.Model.T_DataMemory(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }