/// <summary> /// 更新一条数据 /// </summary> public bool Update(TF.RunSafty.Model.TAB_ReadDoc model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TAB_ReadDoc set "); strSql.Append("strFileGUID=@strFileGUID,"); strSql.Append("strWorkShopGUID=@strWorkShopGUID,"); strSql.Append("StrTypeGUID=@StrTypeGUID,"); strSql.Append("strFileName=@strFileName,"); strSql.Append("strFilePath=@strFilePath,"); strSql.Append("dtBeginTime=@dtBeginTime,"); strSql.Append("dtEndTime=@dtEndTime,"); strSql.Append("dtUpTime=@dtUpTime,"); strSql.Append("nReadMode=@nReadMode,"); strSql.Append("nReadInterval=@nReadInterval"); strSql.Append(" where nid=@nid"); SqlParameter[] parameters = { new SqlParameter("@strFileGUID", SqlDbType.VarChar, 50), new SqlParameter("@strWorkShopGUID", SqlDbType.VarChar, 50), new SqlParameter("@StrTypeGUID", SqlDbType.VarChar, 50), new SqlParameter("@strFileName", SqlDbType.VarChar, 50), new SqlParameter("@strFilePath", SqlDbType.VarChar, 100), new SqlParameter("@dtBeginTime", SqlDbType.VarChar, 50), new SqlParameter("@dtEndTime", SqlDbType.VarChar, 50), new SqlParameter("@dtUpTime", SqlDbType.DateTime), new SqlParameter("@nReadMode", SqlDbType.Int, 4), new SqlParameter("@nReadInterval", SqlDbType.Int, 4), new SqlParameter("@nid", SqlDbType.Int, 4) }; parameters[0].Value = model.strFileGUID; parameters[1].Value = model.strWorkShopGUID; parameters[2].Value = model.StrTypeGUID; parameters[3].Value = model.strFileName; parameters[4].Value = model.strFilePath; parameters[5].Value = model.dtBeginTime; parameters[6].Value = model.dtEndTime; parameters[7].Value = model.dtUpTime; parameters[8].Value = model.nReadMode; parameters[9].Value = model.nReadInterval; parameters[10].Value = model.nid; int rows = (int)SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public TF.RunSafty.Model.TAB_ReadDoc DataRowToModel(DataRow row) { TF.RunSafty.Model.TAB_ReadDoc model = new TF.RunSafty.Model.TAB_ReadDoc(); if (row != null) { if (row["nid"] != null && row["nid"].ToString() != "") { model.nid = int.Parse(row["nid"].ToString()); } if (row["strFileGUID"] != null) { model.strFileGUID = row["strFileGUID"].ToString(); } if (row["strWorkShopGUID"] != null) { model.strWorkShopGUID = row["strWorkShopGUID"].ToString(); } if (row["StrTypeGUID"] != null) { model.StrTypeGUID = row["StrTypeGUID"].ToString(); } if (row["strFileName"] != null) { model.strFileName = row["strFileName"].ToString(); } if (row["strFilePath"] != null) { model.strFilePath = row["strFilePath"].ToString(); } if (row["dtBeginTime"] != null) { model.dtBeginTime = row["dtBeginTime"].ToString(); } if (row["dtEndTime"] != null) { model.dtEndTime = row["dtEndTime"].ToString(); } if (row["dtUpTime"] != null && row["dtUpTime"].ToString() != "") { model.dtUpTime = DateTime.Parse(row["dtUpTime"].ToString()); } if (row["nReadMode"] != null && row["nReadMode"].ToString() != "") { model.nReadMode = int.Parse(row["nReadMode"].ToString()); } if (row["nReadInterval"] != null && row["nReadInterval"].ToString() != "") { model.nReadInterval = int.Parse(row["nReadInterval"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TF.RunSafty.Model.TAB_ReadDoc model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TAB_ReadDoc("); strSql.Append("strFileGUID,strWorkShopGUID,StrTypeGUID,strFileName,strFilePath,dtBeginTime,dtEndTime,dtUpTime,nReadMode,nReadInterval)"); strSql.Append(" values ("); strSql.Append("@strFileGUID,@strWorkShopGUID,@StrTypeGUID,@strFileName,@strFilePath,@dtBeginTime,@dtEndTime,@dtUpTime,@nReadMode,@nReadInterval)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@strFileGUID", SqlDbType.VarChar, 50), new SqlParameter("@strWorkShopGUID", SqlDbType.VarChar, 50), new SqlParameter("@StrTypeGUID", SqlDbType.VarChar, 50), new SqlParameter("@strFileName", SqlDbType.VarChar, 50), new SqlParameter("@strFilePath", SqlDbType.VarChar, 100), new SqlParameter("@dtBeginTime", SqlDbType.VarChar, 50), new SqlParameter("@dtEndTime", SqlDbType.VarChar, 50), new SqlParameter("@dtUpTime", SqlDbType.DateTime), new SqlParameter("@nReadMode", SqlDbType.Int, 4), new SqlParameter("@nReadInterval", SqlDbType.Int, 4) }; parameters[0].Value = model.strFileGUID; parameters[1].Value = model.strWorkShopGUID; parameters[2].Value = model.StrTypeGUID; parameters[3].Value = model.strFileName; parameters[4].Value = model.strFilePath; parameters[5].Value = model.dtBeginTime; parameters[6].Value = model.dtEndTime; parameters[7].Value = model.dtUpTime; parameters[8].Value = model.nReadMode; parameters[9].Value = model.nReadInterval; object obj = SqlHelper.ExecuteScalar(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public TF.RunSafty.Model.TAB_ReadDoc GetModel(int nid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 nid,strFileGUID,strWorkShopGUID,StrTypeGUID,strFileName,strFilePath,dtBeginTime,dtEndTime,dtUpTime,nReadMode,nReadInterval from TAB_ReadDoc "); strSql.Append(" where nid=@nid"); SqlParameter[] parameters = { new SqlParameter("@nid", SqlDbType.Int, 4) }; parameters[0].Value = nid; TF.RunSafty.Model.TAB_ReadDoc model = new TF.RunSafty.Model.TAB_ReadDoc(); DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }