/// <summary> /// 更新一条数据 /// </summary> public void Update(DigiPower.Onlinecol.Standard.Model.T_FileAttach_MDL model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_FileAttach set "); strSql.Append("Flag=@Flag,"); strSql.Append("PriKeyValue=@PriKeyValue,"); strSql.Append("AttachCode=@AttachCode,"); strSql.Append("AttachName=@AttachName,"); strSql.Append("AttachPath=@AttachPath,"); strSql.Append("OrderIndex=@OrderIndex,"); strSql.Append("CreateDate=@CreateDate"); strSql.Append(" where AttachID=@AttachID "); SqlParameter[] parameters = { new SqlParameter("@AttachID", SqlDbType.Int, 8), new SqlParameter("@Flag", SqlDbType.NVarChar, 50), new SqlParameter("@PriKeyValue", SqlDbType.Int, 8), new SqlParameter("@AttachCode", SqlDbType.NVarChar, 50), new SqlParameter("@AttachName", SqlDbType.NVarChar, 200), new SqlParameter("@AttachPath", SqlDbType.NVarChar, 250), new SqlParameter("@OrderIndex", SqlDbType.Int, 8), new SqlParameter("@CreateDate", SqlDbType.DateTime) }; parameters[0].Value = model.AttachID; parameters[1].Value = model.Flag; parameters[2].Value = model.PriKeyValue; parameters[3].Value = model.AttachCode; parameters[4].Value = model.AttachName; parameters[5].Value = model.AttachPath; parameters[6].Value = model.OrderIndex; parameters[7].Value = model.CreateDate; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public DigiPower.Onlinecol.Standard.Model.T_FileAttach_MDL GetModel(int AttachID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 AttachID,Flag,PriKeyValue,AttachCode,AttachName,AttachPath,OrderIndex,CreateDate from T_FileAttach "); strSql.Append(" where AttachID=@AttachID "); SqlParameter[] parameters = { new SqlParameter("@AttachID", SqlDbType.Int, 8) }; parameters[0].Value = AttachID; DigiPower.Onlinecol.Standard.Model.T_FileAttach_MDL model = new DigiPower.Onlinecol.Standard.Model.T_FileAttach_MDL(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["AttachID"].ToString() != "") { model.AttachID = int.Parse(ds.Tables[0].Rows[0]["AttachID"].ToString()); } model.Flag = ds.Tables[0].Rows[0]["Flag"].ToString(); if (ds.Tables[0].Rows[0]["PriKeyValue"].ToString() != "") { model.PriKeyValue = int.Parse(ds.Tables[0].Rows[0]["PriKeyValue"].ToString()); } model.AttachCode = ds.Tables[0].Rows[0]["AttachCode"].ToString(); model.AttachName = ds.Tables[0].Rows[0]["AttachName"].ToString(); model.AttachPath = ds.Tables[0].Rows[0]["AttachPath"].ToString(); if (ds.Tables[0].Rows[0]["OrderIndex"].ToString() != "") { model.OrderIndex = int.Parse(ds.Tables[0].Rows[0]["OrderIndex"].ToString()); } if (ds.Tables[0].Rows[0]["CreateDate"].ToString() != "") { model.CreateDate = DateTime.Parse(ds.Tables[0].Rows[0]["CreateDate"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(DigiPower.Onlinecol.Standard.Model.T_FileAttach_MDL model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_FileAttach("); strSql.Append("Flag,PriKeyValue,AttachCode,AttachName,AttachPath,OrderIndex,CreateDate)"); strSql.Append(" values ("); strSql.Append("@Flag,@PriKeyValue,@AttachCode,@AttachName,@AttachPath,@OrderIndex,@CreateDate)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Flag", SqlDbType.NVarChar, 50), new SqlParameter("@PriKeyValue", SqlDbType.Int, 8), new SqlParameter("@AttachCode", SqlDbType.NVarChar, 50), new SqlParameter("@AttachName", SqlDbType.NVarChar, 200), new SqlParameter("@AttachPath", SqlDbType.NVarChar, 250), new SqlParameter("@OrderIndex", SqlDbType.Int, 8), new SqlParameter("@CreateDate", SqlDbType.DateTime) }; parameters[0].Value = model.Flag; parameters[1].Value = model.PriKeyValue; parameters[2].Value = model.AttachCode; parameters[3].Value = model.AttachName; parameters[4].Value = model.AttachPath; parameters[5].Value = model.OrderIndex; parameters[6].Value = model.CreateDate; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }