public bool AddTransmitConfig(Model_TransmitConfig model)
{
string newGUID = Guid.NewGuid().ToString();
string strSql = @"insert into [TAB_System_TransmitConfig] ([strWorkShopGUID],[nPost]) values (@strWorkShopGUID,@nPost)";
SqlParameter[] sqlParams = { new SqlParameter("strWorkShopGUID", model.strWorkShopGUID),
new SqlParameter("nPost", model.nPost) };
return(SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams) > 0);
}
public bool UpdateTransmitConfig(Model_TransmitConfig model)
{
string newGUID = Guid.NewGuid().ToString();
string strSql = @"update TAB_System_TransmitConfig set strWorkShopGUID=@strWorkShopGUID,nPost=@nPost where nid=@nid";
SqlParameter[] sqlParams = { new SqlParameter("strWorkShopGUID", SqlDbType.VarChar, 50, model.strWorkShopGUID),
new SqlParameter("@nPost", model.nPost),
new SqlParameter("nid", model.nId) };
return(SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams) > 0);
}
