/// <summary> /// 增加一条数据 /// </summary> public void Add(Dianda.Model.DOC_transport_To model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into DOC_transport_To("); strSql.Append("ID,FROMUSER,TOUSER,TITLES,FILEPATH,DATETIME,DELFLAG,ISREAD,READTIME)"); strSql.Append(" values ("); strSql.Append("@ID,@FROMUSER,@TOUSER,@TITLES,@FILEPATH,@DATETIME,@DELFLAG,@ISREAD,@READTIME)"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.VarChar, 50), new SqlParameter("@FROMUSER", SqlDbType.VarChar, 50), new SqlParameter("@TOUSER", SqlDbType.VarChar, 50), new SqlParameter("@TITLES", SqlDbType.VarChar, 500), new SqlParameter("@FILEPATH", SqlDbType.VarChar, 300), new SqlParameter("@DATETIME", SqlDbType.DateTime), new SqlParameter("@DELFLAG", SqlDbType.Int, 4), new SqlParameter("@ISREAD", SqlDbType.Int, 4), new SqlParameter("@READTIME", SqlDbType.DateTime) }; parameters[0].Value = model.ID; parameters[1].Value = model.FROMUSER; parameters[2].Value = model.TOUSER; parameters[3].Value = model.TITLES; parameters[4].Value = model.FILEPATH; parameters[5].Value = model.DATETIME; parameters[6].Value = model.DELFLAG; parameters[7].Value = model.ISREAD; parameters[8].Value = model.READTIME; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public Dianda.Model.DOC_transport_To GetModel(string ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,FROMUSER,TOUSER,TITLES,FILEPATH,DATETIME,DELFLAG,ISREAD,READTIME from DOC_transport_To "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.VarChar, 50) }; parameters[0].Value = ID; Dianda.Model.DOC_transport_To model = new Dianda.Model.DOC_transport_To(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { model.ID = ds.Tables[0].Rows[0]["ID"].ToString(); model.FROMUSER = ds.Tables[0].Rows[0]["FROMUSER"].ToString(); model.TOUSER = ds.Tables[0].Rows[0]["TOUSER"].ToString(); model.TITLES = ds.Tables[0].Rows[0]["TITLES"].ToString(); model.FILEPATH = ds.Tables[0].Rows[0]["FILEPATH"].ToString(); if (ds.Tables[0].Rows[0]["DATETIME"].ToString() != "") { model.DATETIME = DateTime.Parse(ds.Tables[0].Rows[0]["DATETIME"].ToString()); } if (ds.Tables[0].Rows[0]["DELFLAG"].ToString() != "") { model.DELFLAG = int.Parse(ds.Tables[0].Rows[0]["DELFLAG"].ToString()); } if (ds.Tables[0].Rows[0]["ISREAD"].ToString() != "") { model.ISREAD = int.Parse(ds.Tables[0].Rows[0]["ISREAD"].ToString()); } if (ds.Tables[0].Rows[0]["READTIME"].ToString() != "") { model.READTIME = DateTime.Parse(ds.Tables[0].Rows[0]["READTIME"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Dianda.Model.DOC_transport_To model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update DOC_transport_To set "); strSql.Append("FROMUSER=@FROMUSER,"); strSql.Append("TOUSER=@TOUSER,"); strSql.Append("TITLES=@TITLES,"); strSql.Append("FILEPATH=@FILEPATH,"); strSql.Append("DATETIME=@DATETIME,"); strSql.Append("DELFLAG=@DELFLAG,"); strSql.Append("ISREAD=@ISREAD,"); strSql.Append("READTIME=@READTIME"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.VarChar, 50), new SqlParameter("@FROMUSER", SqlDbType.VarChar, 50), new SqlParameter("@TOUSER", SqlDbType.VarChar, 50), new SqlParameter("@TITLES", SqlDbType.VarChar, 500), new SqlParameter("@FILEPATH", SqlDbType.VarChar, 300), new SqlParameter("@DATETIME", SqlDbType.DateTime), new SqlParameter("@DELFLAG", SqlDbType.Int, 4), new SqlParameter("@ISREAD", SqlDbType.Int, 4), new SqlParameter("@READTIME", SqlDbType.DateTime) }; parameters[0].Value = model.ID; parameters[1].Value = model.FROMUSER; parameters[2].Value = model.TOUSER; parameters[3].Value = model.TITLES; parameters[4].Value = model.FILEPATH; parameters[5].Value = model.DATETIME; parameters[6].Value = model.DELFLAG; parameters[7].Value = model.ISREAD; parameters[8].Value = model.READTIME; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }